CentOS7安装mysql8

root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘China123456$‘;

4、支持远程连接

mysql> use mysql
mysql> select host,user,plugin from user;
mysql> update user set host=‘%‘ where user =‘root‘;
mysql> FLUSH PRIVILEGES;

5、字符集

从Mysql8.0开始，默认值的字符集为utf8mb4，不再是latin1。基本上不用再为字符集操心了。

 

CentOS7安装mysql8

标签：pre   pass   默认值   var   update   plugin   修改   info   emctl