MySQL checks the IP address of the user connecting to it's server. It then does a Reverse DNS lookup on that IP address, to get the name associated with it (there is only one name associated with any IP, the rest are just aliases)
The host you are connecting from does not resolve to www.networkshastrihall.com , it resolves to 202-63-167-192.exatt.com . You would need to be connecting to MySQL from the computer www.networkshastrihall.com sits on to be able to connect. Chris -----Original Message----- From: ads mysql [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 17, 2003 7:44 AM To: gerald_clark Cc: [EMAIL PROTECTED] Subject: Re: Problem creating new user. Hi, I tried to create user with GRANt as follows : mysql> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO ads123@'www.networkshastrihall.com' IDENTIFIED BY 'ads123'; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) I think this is not entering into table. [EMAIL PROTECTED] root]# mysql -h www.networkshastrihall.com -u ads123 -p bankaccount Enter password: ERROR 1130: Host '202-63-167-192.exatt.com' is not allowed to connect to this MySQL server. DNS www.networkshastrihall.com is working. Help appreciated. Thanks gerald_clark <[EMAIL PROTECTED]> wrote: ads mysql wrote: >I tried to connect as follows : > >######### >[EMAIL PROTECTED] root]# mysql -h www.allnet.com -u ads11 bankaccount >ERROR 1130: Host 'xxx-xx-xxx-xxx.yyy.com' is not allowed to connect to this MySQL server >##### > > Your DNS is broken. >It gives error. >I sthere anything giving permission to connect to mysql for particular Host? > > Use GRANT unless you know what you are doing. >Thanks for support. > > >Duncan Hill wrote: >On Wednesday 17 December 2003 12:45, ads mysql wrote: > > > >>It gives following error :[EMAIL PROTECTED] root]# mysql -u ads11 -p >>bankaccount Enter password: (here I enter password 'ads11') >>ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: >>YES) >>Domain www.allnet.com is registered, having live IP on which web server is >> >> > >Your mysql command line statement provides no host to connect to, so it uses >the local socket to communicate. Mysql sees this as 'localhost'. > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > >--------------------------------- >Do you Yahoo!? >Free Pop-Up Blocker - Get it now > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --------------------------------- Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
