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
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.