MySQL数据库的安装教程及相关问题

2018-07-13

问题1：

alter user 'root'@'%' identified with mysql_native_password by 'root';set password for 'root'@'%'='Test123';--Test123 为密码 root为user %对应host，默认是localhost，%是通配符 flush privileges;

 

问题2：

MySQL 8.0 Command Line Client - Unicode 

use mysql;select host,user,plugin from user where user='root'; update user set host ='%'where user ='root';

重启服务使其生效

+-----------+------------------+-----------------------+| Host      | User             | plugin                |+-----------+------------------+-----------------------+| %         | ming8006         | caching_sha2_password || localhost | mysql.infoschema | caching_sha2_password || localhost | mysql.session    | caching_sha2_password || localhost | mysql.sys        | caching_sha2_password || localhost | root             | caching_sha2_password |+-----------+------------------+-----------------------+

 

 

问题3：

MySQL 8.0 Command Line Client - Unicode 

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'quark@123';

重启服务使其生效