Hi, I just installed MySQL 3.23.49 on NT and executed the following commands:
UPDATE USER SET password=password("test1") WHERE host="localhost"; UPDATE USER SET password=password("test1") WHERE host="%"; Now, after doing 'mysqladmin reload', I cannot connect... > mysql -p > Enter password: ***** > Error 1045: Access denied for user: 'ODBC@localhost' (Using password: YES) > mysql -p[test1] > Error 1045: Access denied for user: 'ODBC@localhost' (Using password: YES) > mysql -u root -p[test1] > Error 1045: Access denied for user: 'root@localhost' (Using password: YES) Have I done something wrong? Can I connect to the database, or do I have to re-install? Thanks very much in advance for any advice. - Best regards, Lee Reilly --------------------------------------------------------------------- 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