Use the -p option so that the server can prompt you for the password you just created. mysql -uroot -p
-----Original Message----- From: Francois A. Atallah To: [EMAIL PROTECTED] Sent: 8/20/04 12:59 PM Subject: Login problem After Installed mysql on Windows I have entered a root password using the command below mysql> UPDATE mysql.user SET Password = PASSWORD('test') -> WHERE User = 'root'; After saves had been made I get the erros below ? Any help C:\>c:\mysql\bin\mysql -u root ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) C:\>c:\mysql\bin\mysqlshow mysql c:\mysql\bin\mysqlshow: Access denied for user: '@localhost' to database 'mysql' Thanks, Francois A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]