Linux-ubuntu(18.04) and Mysql 远程登录方法

查看mysql服务状态

systemctl status mysql

用根用户进入mysql

mysql -u root -p

MYsql远程登录方法

MYSQL 查看用户授权

一般授权到 %

show grants for root;

GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY "123456";

localhost 为本地，修改为% 为所有，“123456”为密码

mysql 查看用户

use mysql;
SELECT user, host, plugin, authentication_string FROM user;

查看和修改 MYSQL 的访问地址权限

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

bind-address = 0.0.0.0

重启MYSQL 服务

sudo service mysql restart

检查UBUNTU 端口

远程登录前

netstat -an | grep 3306
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN   

远程登录后

netstat -an | grep 3306                    
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN     
tcp        0      0 192.168.249.128:3306    192.168.249.1:60768     ESTABLISHED
tcp        0      0 192.168.249.128:3306    192.168.249.1:60769     ESTABLISHED