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]
