I have read the documentation and I understand the grant and revoke but mysql -u is just not working for me. Yesterday I was able to do a mysql -u root and it would ask me for my password and I would enter the one that I created for root in my grant statement and it would let me in. But any other user that I had created and try to use with mysql -u username would just let me in and not prompt me for a password. Today no matter what mysql -u username I put in it lets me slide thru. Now if I add the -p it prompts me for my password but even when I put in the correct passwords I get errors even for the root. But if I login to linux with my root username and password then go to mysql it allows me to do root mysql admin. So I must have done something but I don't know what I have done. Any help would be appreciated.
--------------------------------------------------------------------- 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