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.
hth
Jeff
ads mysql
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
om> cc:
Subject: Problem creating new user.
12/17/2003 07:45
AM
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','Y','Y');
mysql> FLUSH PRIVILEGES;
But when I use Host 'www.allnet.com' in place of 'localhost' in both above
mentioned INSERT command It enters values in to table but when I try to
access database by
mysql>mysql -u ads11 -p bankaccount
mysql > (Here I enter password 'ads11')
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 registered, having live IP on which web server is
running succefully.
Any clue about problem.
Thanks
---------------------------------
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
