ubuntu
安装
sudo apt-get update
sudo apt-get install mysql-server mysql-client
设置root密码
cat /etc/mysql/debian.cnf 查看默认密码
mysql -u debian-sys-maint -p 连接输入密码
use mysql; select user,plugin from user;
update user set plugin='mysql_native_password' where user='root'; # 修改其密码格式 select user,plugin from user; # 查询其用户
alter user 'root'@'localhost' identified by '12345678';
update user set host = '%' where user = 'root';
flush privileges;
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
注释掉bind-address = 127.0.0.1:
重启
sudo service mysql restart