Grant remote access of MySQL database If you try to connect to a remote MySQL database from your client system, you will get “ERROR 1130: Host is not allowed to connect to this MySQL server” message as shown below. $ mysql -h 192.168.1.8 -u root -p Enter password: ERROR 1130: Host ‘192.168.1.4’ is not allowed […]
Hello, Error code : Error: Connection to the database server has failed because the supplied account does not possess administrative privileges:Access denied for user ‘admin’@’localhost’ to database This error means that MySQL administrator account that is used in Plesk does not have enough privileges to manage database/users in the MySQL server. Solution : […]
Hello, 1. Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql database! This is critical! 2. Learn the MySQL access privilege system. The GRANT and REVOKE statements are used for controlling access to MySQL. Do not grant more privileges than necessary. Never grant privileges to all […]
