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