navicat-fot-mysql - 怎样使用Navicat for Mysql连接Ubuntu虚拟机上的mysql服务器

Answer 1

I guess so
1. When you are in the virtual machine, you log in as user root@127.0.0.1;
2. In Windows 7, you log in as user root@%;

User permissions are different in these two cases.
Suppose you log in to the virtual machine as user root and create db, house, yst, etc., but these databases are not authorized to you as user root@%;
All you need to do is
grant <privileges> to root@% identified by <password>;
flush privileges;
3. Then log in to Windows 7 to use it.

Answer 2

1. First you have to ensure that win7 can access ubuntu, ping ubuntu’s ip on win7
2. Fill in the ubuntu information when creating a database connection in Navicat

Answer 3

First of all, your Navicat login user must have corresponding database permissions. You can use the grant command to configure permissions. After creating a new database on the server, you must use flush privilege to refresh the permissions

Answer 4

It is indeed a permissions issue
The use, mysql, information_schema databases can be accessed locally or remotely
As for your newly created database, accessing it from a virtual machine is called local access, and accessing it from win7 When navicat was accessed in the past, it was remote access
It is very likely that you only have local permissions and no remote access permissions
So you need to authorize so that you can see the database