1、确保本地拥有mysql安装包
2、查找默认用户名和密码
sudo cat /etc/mysql/debian.cnf
[client]
host = localhost
user = debian-sys-maint
password = 5M3ayJbyJT1R1OKO
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = 5M3ayJbyJT1R1OKO
socket = /var/run/mysqld/mysqld.sock
3、用client下面的user 和 password来登录
mysql -u(user) -p(password)
use mysql;
flush privileges;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的mysql密码';
flush privileges;
4、远程连接
use mysql;
create user 'root'@'%' identified by '你的mysql密码';
grant all privileges on *.* to 'root'@'%';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的mysql密码';
flush privileges; #退出mysql#mysql配置文件中把 127.0.0.1 那行注释掉
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf#注释下面这行
bind-address =127.0.0.1
重启mysql服务
sudo service mysql restart