Re: Problem creating new user.

2003-12-17 Thread ads mysql
PROTECTED] Subject: Re: Problem creating new user. 12/17/2003 10:44 AM 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 chang

RE: Problem creating new user.

2003-12-17 Thread Chris
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 chang

Re: Problem creating new user.

2003-12-17 Thread jeffrey_n_Dyke
om> cc: [EMAIL PROTECTED] Subject: Re: Problem creating new user.

Re: Problem creating new user.

2003-12-17 Thread ads mysql
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@'

Re: Problem creating new user.

2003-12-17 Thread 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 permis

Re: Problem creating new user.

2003-12-17 Thread ads mysql
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 # It gives error. I sthere anything giving permission to connect to mysql for particular H

Re: Problem creating new user.

2003-12-17 Thread Duncan Hill
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

Re: Problem creating new user.

2003-12-17 Thread jeffrey_n_Dyke
Unless i'm misunderstanding(highly possible)...if you are on the command line, you are going to be seen by mysql as localhost and not allnet.com. You'll only be seen as another host if you connect remotely. the webserver running on the localmachine and the mysql client will be seen as localhost.