-   Red Hat (
-   -   why I got "Access denied for user: 'root@localhost'" (

likedreamer 11-09-2003 12:49 AM

why I got "Access denied for user: 'root@localhost'"
I had not given hostname or ip address during my initial installation of Redhat 9. MySQL was up and running and I was able to connect to MySQL instance after my Redhat 9 initial starting up, and even I startup OS many times later.
Then I use 'neat' command to change hostname and IP address and reboot my Redhat 9, the os up and running including MySQL DB. However, I got message of "Access denied for user: 'root@localhost' (Using password: NO)" when I tried to logon to MySQL instance by using user either 'mysql' or 'root'. Please anyone tell me how to fix it !! TKS, TKS.

:confused: :confused:

j-ray 11-09-2003 06:06 AM

log in as root, type
mysql -p
or sth like
/usr/bin/mysql -p

this should give u a prompt to enter the password

All times are GMT -5. The time now is 01:41 PM.