I am running MySQL 5.1.49 on FreeBSD 8.1.
Hello, I have a large network of machines that needs to get access to a MySQL database. I have tried adding users with a wildcard to identify the host portion of the dns name, but am unable to login from remote machines even tho DNS resolution is fine on both remote
the host and the server.
mysql> GRANT ALL on mylibrary.* TO 'bluethundr'@'%.example.com' IDENTIFIED BY 'mySecret';
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT user, host FROM user;
+------------+--------------------------+
| user | host |
+------------+--------------------------+
| bluethundr | %.example.com |
| bluethundr | %example.com |
| root | 127.0.0.1 |
| bluethundr | 192.168.1.23 |
| root | ::1 |
| | lbsd8-2.example.com |
| bluethundr | lbsd8-2.example.com |
| root | lbsd8-2.example.com |
| | localhost |
| nobody | localhost |
| root | localhost |
| bluethundr | virt1 |
| bluethundr | virt1.example.com |
+------------+--------------------------+
13 rows in set (0.00 sec)
mysql>
From one host on the network:
[bluethundr@virtCent02:~]$:mysql -ubluethundr -pmySecret -hbsd2
ERROR 1130 (00000): Host '192.168.1.24' is not allowed to connect to this MySQL server
[bluethundr@virtCent02:~]$:host bsd2
bsd2.summitnjhome.com has address 192.168.1.44
[root@virtcCent04 ~]# mysql -uroot -pmySecret -hbsd2
ERROR 1130 (00000): Host '192.168.1.26' is not allowed to connect to this MySQL server
[root@virtcCent04 ~]# host bsd2
bsd2.example.com has address 192.168.1.44
Are wild cards not allowed in specifying the host portion of the name?