I've sent similar questions to the list with no replies so here's the best I can do for you.
I use debian so I dunno what's specific to it beyond the created user to start and stop the damon so; try mysqlaccess user host db to see what privileges you've got. u can restart msyql or safe_mysqld --skip-grant-tables check this page http://www.mysql.com/doc/A/c/Access_denied.html and make this is not dns and the machine your connecting from is in /etc/hosts ip hostname to remove the anonymous user do mysql> DELETE FROM user WHERE User = ''; mysql> DELETE FROM db WHERE Host = '%'; from article http://www.linuxsecurity.com/tips/tip-24.html lastly read the man pages carefully since using -p password, -ppassword, --password=password, and password ('password') do different things depending on your shell etc. -----Original Message----- From: Lehman, Jason (Registrar's Office) [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 7:27 AM To: '[EMAIL PROTECTED]' Subject: mysql -u is not working for me today but was yesterday 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 --------------------------------------------------------------------- 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
