Search
Back
Mykhailo Liepieshko
January 16, 2023 ・ Basics
[SOLVED] PMM Server Installation Error – Connection Check Failed: Error 1130: Host Is Not Allowed To Connect To This Server.
If you get this type of error, it means that you need to create right access for pmm user to database.
You can check current permissions for the pmm users by the SHOW GRANT queries.
SHOW GRANTS FOR 'pmm';
SHOW GRANTS FOR 'pmm'@'XXX.XXX.XXX.XXX';
The request should return a response like this:
+--------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for pmm@XXX.XXX.XXX.XXX |
+--------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, RELOAD, PROCESS, REPLICATION CLIENT ON *.* TO 'pmm'@'XXX.XXX.XXX.XXX' IDENTIFIED BY PASSWORD 'XXX' |
+--------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
Probably in case of a problem, the request will return a similar error to this:
ERROR 1141 (42000): There is no such grant defined for user 'pmm' on host 'XXX.XXX.XXX.XXX'
So the fix in this situation would be to create a user with the right permissions:
On MySQL 8.0
CREATE USER 'pmm'@'XXX.XXX.XXX.XXX' IDENTIFIED BY 'PASSWORD' WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, PROCESS, REPLICATION CLIENT, RELOAD, BACKUP_ADMIN ON. TO 'pmm'@'XXX.XXX.XXX.XXX';
On MySQL 5.7
CREATE USER 'pmm'@'[XXX.XXX.XXX.XXX](http://xxx.xxx.xxx.xxx/)' IDENTIFIED BY 'PASSWORD' WITH MAX_USER_CONNECTIONS 10;
GRANT SELECT, PROCESS, REPLICATION CLIENT, RELOAD ON *.* TO 'pmm'@'[XXX.XXX.XXX.XXX](http://xxx.xxx.xxx.xxx/)';
And after creating the user, you need to flush the privileges
FLUSH PRIVILEGES;
- Basics