Hi
I added a new user in mysql using the following
mysql>insert into user
values('localhost','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N','
N','N','N','N','N','Y','Y');
mysql>insert into user
values('%','aman',PASSWORD('mysql024'),'Y','Y','Y','Y','Y','Y','N','N','N','
N','N','N','Y','Y');
mysql>FLUSH PRIVILEGES;I am trying to connect from the shell by shell>mysql -p -u aman Enter password: ERROR 1045: Access denied for user: 'aman@localhost' (Using password: YES) Why so? Thank you Aman --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
