Re: Problem creating new user.

[gerald_clark]

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 <[EMAIL PROTECTED]> 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]