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
[EMAIL PROTECTED] writes:
> If I (admin1) have all privileges with grant option on database 'db1' and
> no privileges in 'mysql', why this does not work
> mysql> grant all privileges on db1.* to aaa@localhost identified by 'aaa';
> ERROR 1044: Access denied for user: 'admin1@localhost' to d
Hi,
I've put here this my problem, but without an answer.
If I (admin1) have all privileges with grant option on database 'db1' and
no privileges in 'mysql', why this does not work
mysql> grant all privileges on db1.* to aaa@localhost identified by 'aaa';
ERROR 1044: Access denied for user:
11 matches
Mail list logo