Lee,
Tuesday, April 02, 2002, 8:54:44 PM, you wrote:
LPR> I just installed MySQL 3.23.49 on NT and executed the following
LPR> commands:
LPR> UPDATE USER SET password=password("test1") WHERE host="localhost";
LPR> UPDATE USER SET password=password("test1") WHERE host="%";
LPR> Now, after doing 'mysqladmin reload', I cannot connect...
LPR> mysql -p
LPR> Enter password: *****
LPR> Error 1045: Access denied for user: 'ODBC@localhost' (Using password:
LPR> YES)
If you use -p option you should also specify user name, for example:
mysql -utest1 -p
LPR> mysql -p[test1]
LPR> Error 1045: Access denied for user: 'ODBC@localhost' (Using password:
LPR> YES)
Don't use square brackets when you enter your password.
LPR> mysql -u root -p[test1]
LPR> Error 1045: Access denied for user: 'root@localhost' (Using password:
LPR> YES)
LPR> Have I done something wrong? Can I connect to the database, or do I have
LPR> to re-install?
LPR> Thanks very much in advance for any advice.
LPR> - Best regards,
LPR> Lee Reilly
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
