Navicat连接虚拟机数据库2003错误

 

 

1. mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
2. mysql> flush privileges;
3. sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf 注释掉 #bind-address    = 127.0.0.1
4. sudo /etc/init.d/mysql restart