Hi,
I can create new user with following.
mysqlINSERT INTO user (Host,User,Password)
VALUES('localhost','ads11',PASSWORD('ads11'));
mysqlINSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv) VALUES
:
Subject: Problem creating new user.
12/17/2003 07:45
AM
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
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
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
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
cc: [EMAIL PROTECTED]
Subject: Re: Problem creating new
user.
12/17/2003 10:44
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
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 changed
mysql GRANT SELECT,INSERT,UPDATE,DELETE