Im trying to connect to a remote MySQL host, but I receive only the “Host not allowed to connect to server” message. What can the reason be?
This error occurs because you don’t have a permission to connect to remote MySQL server from your host. Please contact your database administrator or, if you have access to MySQL server with grant privilege, you can use the GRANT statement to add a new user. For example, the following command will give full access from your host to the user: /*!50003 CREATE USER ‘user’@’user_host’*/; GRANT ALL PRIVILEGES ON *.* TO ‘user’@’user_host’ IDENTIFIED BY ‘ user_password ‘; (http://dev.mysql.com/doc/refman/5.1/en/privileges.
Related Questions
- Why do I get the error message "Supplied credentials dont have enough privileges to audit the remote host" when I try and execute compliance checks?
- Im trying to connect to a remote MySQL host, but I receive only the "Host not allowed to connect to server" message. What can the reason be?
- I try to connect to a remote MySQL host, but I receive only the "Host not allowed to connect to server" message. What can the reason be?
