Mysql8安装配置

1、修改访问Ip
root@Ubuntu-01 14:22:34:/etc/mysql$vi /etc/mysql/mysql.conf.d/mysqld.cnf
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1
bind-address            = 192.168.x.x  修改为本地IP
mysqlx-bind-address     = 127.0.0.1
#
# * Fine Tuning
#
key_buffer_size         = 16M

2、创建访问用户
mysql> alter user 'admin'@'localhost' identified with mysql_native_password by 'admin';
mysql> flush privileges;

3、修改登录加密方式后输入：
ALTER USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY 'admin';
flush privileges;