CODEWITHSUNDEEP
mysqlmampvmwarehostdbforge
Chriz74
Chriz74

Reputation: 1480

access mysql database (mamp) in host from Windows guest (dbforge query builder)

I need to be able to access mysql database that I am running in the host through MAMP (not pro) from a program called dbforge query builder running in the windows host. I try to put the ip address of the host in the program but it returns an error: (vmware guest ip address) is not allowed to connect to this MySQL server. How can this be solved?

enter image description here

Upvotes: 1

Views: 612

Answers (2)

Devart
Devart

Reputation: 121922

The root cause of the issue is that the configurations do not have the proper permission for the IP address.

Allow remote access to MySQL server. This can be done via my.cnf file (MySQL configuration file) as:

[mysqld]
bind-address = YOUR_SERVER_IP (or 0.0.0.0 which means all)

Upvotes: 0

mitkosoft
mitkosoft

Reputation: 5316

  1. Allow remote access to MySQL server. This can be done via my.cnf file (MySQL configuration file) as:

    [mysqld]
bind-address = YOUR_SERVER_IP (or 0.0.0.0 which means all)

  2. grand user with priviliege to access it out of localhost (like 'user'@'%' or at least 'user'@'192.168.1.92' if you want to restrict it to specific IP):

    mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

Upvotes: 0

Related Questions