mysql root用户远程登陆

mysql -u root -p

mysql> select user,host from user;
±--------------±----------+
| user | host |
±--------------±----------+
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
±--------------±----------+
3 rows in set (0.00 sec)

mysql> select version();
±------------------------------+
| version() |
±------------------------------+
| 5.7.40-ndb-7.6.24-cluster-gpl |
±------------------------------+
1 row in set (0.00 sec)

mysql> grant all privileges on . TO ‘root’@‘%’ IDENTIFIED BY ‘passfor root’ with grant option;
mysql> select user,host from user;
±--------------±----------+
| user | host |
±--------------±----------+
| root | % |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
±--------------±----------+
4 rows in set (0.00 sec)

mysql>

mysql8

use mysql;
update user set host=‘%’ where user=root;
flush privileges;

改密码

alter user ‘xx’@‘%’ IDENTIFIED BY ‘xx’;
flush privileges;