Navicat连接虚拟机中的MySQL

登录MySQL

[root@localhost ~]# mysql -u root -p

选择数据库

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

授权访问

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
mysql> FLUSH   PRIVILEGES;

查看ip地址

新建连接