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
