Mysql8.0

homebrew 安装 && 启动

1
2
3
4
brew install mysql
# 一般安装完后就默认启动了
brew services start mysql
brew services info mysql

修改root密码

homebrew 安装完的mysql,默认是没有密码的

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
mysql -uroot
# 允许弱密码登录
SET GLOBAL validate_password.policy=LOW
#SET GLOBAL validate_password.LENGTH = 4;
#SET GLOBAL validate_password.policy = 0;
#SET GLOBAL validate_password.mixed_case_count = 0;
#SET GLOBAL validate_password.number_count = 0;
#SET GLOBAL validate_password.special_char_count = 0;
#SET GLOBAL validate_password.check_user_name = 0;
ALTER USER 'root'@'localhost' IDENTIFIED BY '你的新密码'

# 刷新
FLUSH PRIVILEGES;

# 授权
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

重置root密码

使用sudo mysqld_safe --skip-grant-tables启动如失败,考虑下面的命令

1
2
mkdir -p /var/run/mysqld
chown mysql:mysql /var/run/mysqld

登录mysql

1
2
3
drop user admin@localhost;
flush privileges;
create user admin@localhost identified by 'admins_password'

mysql完全卸载

1
2
3
4
5
6
7
sudo systemctl stop mysql

sudo apt purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*
sudo rm -rf /etc/mysql /var/lib/mysql /var/log/mysql

sudo apt autoremove
sudo apt autoclean

查看mysql连接情况

查看最大连接数 show variables like 'max_connections';
查看当前连接数 show status like 'max%connections';
更改最大连接数 set GLOBAL max_connections=1000;