Linux (Ubuntu) 服务器安装MySQL，设置不限ip，root远程密码访问

1.注释bind-address = 127.0.0.1

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

 

将bind-address = 127.0.0.1注释掉（即在行首加#），如下：

代码如下:

# 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

除了注视掉这句话之外，还可以把后面的IP地址修改成允许连接的IP地址

 

2.查看 user表， root的plugin 是 auth_socket，用密码登陆的plugin应该是mysql_native_password

select user, host,plugin from mysql.user;

 

设置密码登录：

update mysql.user set authentication_string=PASSWORD('新密码'), plugin='mysql_native_password' where user='root';

flush privileges;

相关命令：

停止MySQL：

sudo service mysql stop

启动MySQL：

sudo service mysql  start