if your password is "mysql" then try this
mysql -u root -pmysql
(note that there is no space between the -p and the actual password)
but this is not great from a security standpoint. an alternative is:
mysql -u root -p
which will prompt you for your password
or
-----Original Message-----
From: kalyansk [mailto:kaly...@world2web.com]
Sent: Tuesday 09 November 2004 11:56
To: ja...@lists.mysql.com
Subject: mysql error
Hi
i am new to mysql i am worling on linux operating
(redhat 8)system i have installed
MySQL-3.23.52-1.i386.rpm,MySQL-client-3.23.52-1.i386.rpm,MySQL
-Max-3.23.52-1.i386.rpm on my machine & when i try to login
as root i get the following error
ERROR 1045: Access denied for user: 'root@localhost' (Using
password: NO)
i am using mysql -u root mysql
plz help i have tried all possible methods to login
thks in advance
-regards
kelly