sudo mysql -uroot -p
use mysql;
update user set authentication_string=PASSWORD("要设置的密码") where user='root';
update user set plugin="mysql_native_password";
flush privileges;
quit;
3、设置允许远程访问(非必要)
#修改配置文件sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
#加#注释掉绑定ip#bind-address = 127.0.0.1#登录数据库
mysql -uroot -p
use mysql;#删除匿名用户
delete from user where user='';#(不推荐)#给root授予在任意主机(%)访问任意数据库的所有权限(不推荐)
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;#(推荐)#或者,这个比上面好(推荐)
update user set host='%' where user='root' and host='localhost';#mysql5.7.9之后要用这个
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';#重启MySQLservice mysql restart