MySQL Forums
Forum List  »  Newbie

DNS Resolution In MySQL
Posted by: Tim Dunphy
Date: August 28, 2010 05:41AM

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?

Options: ReplyQuote


Subject
Written By
Posted
DNS Resolution In MySQL
August 28, 2010 05:41AM
August 29, 2010 09:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.