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
