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
cc: Subject: Problem creating new user. 12/17/2003 07:45

Problem creating new user.

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

Re: Creating new user

2001-09-17 Thread Carl Troein
[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

Creating new user

2001-09-17 Thread j . stary
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: