Thursday, September 10, 2020

Mariadb Connection Issues (Host not allowed to connect to this MariaDB Server)

 Here is  a good source:

https://mariadb.com/kb/en/troubleshooting-connection-issues/


Here is my problem:



[root@database bin]# ./mysql -h localhost -u root -pP@ssw0rd

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 7

Server version: 10.5.5-MariaDB MariaDB Server


Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [(none)]> SELECT User, Host FROM mysql.user WHERE Host <> 'localhost';

+------+------------------------------------+

| User | Host                               |

+------+------------------------------------+

|      | rhel-server-7.6-x86-64.localdomain |

+------+------------------------------------+

1 row in set (0.005 sec)


MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.%'   IDENTIFIED BY 'P@ssw0rd' WITH GRANT OPTION;

Query OK, 0 rows affected (0.001 sec)


MariaDB [(none)]> SELECT User, Host FROM mysql.user WHERE Host <> 'localhost';

+------+------------------------------------+

| User | Host                               |

+------+------------------------------------+

| root | 192.168.1.%                        |

|      | rhel-server-7.6-x86-64.localdomain |

+------+------------------------------------+

2 rows in set (0.001 sec)


MariaDB [(none)]>


No comments:

Post a Comment