ubuntu_18.04_mysql5.6安装

ubuntu_18.04_mysql5.6安装

apt-get update
apt-get install mysql-server
update mysql.user set plugin = 'mysql_native_password' where user = 'root' and host='localhost';
//开启远程访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
update mysql.user set authentication_string=PASSWORD('password') where USER='root';
flush privileges;
vim /etc/mysql/mysql.conf.d/mysqld.cnf
//注释掉仅本地连接限制
bind-address=127.0.0.1
service mysql restart