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
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
om> 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@'
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
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
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
cc:
Subject: Problem creating new user.
12/17/2003 07:45
Hi,
I can create new user with following.
mysql>INSERT INTO user (Host,User,Password)
VALUES('localhost','ads11',PASSWORD('ads11'));
mysql>INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,
Create_priv,Drop_priv) VALUES
('localhost','bankaccount','ads11','Y','Y','Y','Y
