LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Red Hat (http://www.linuxquestions.org/questions/red-hat-31/)
-   -   why I got "Access denied for user: 'root@localhost'" (http://www.linuxquestions.org/questions/red-hat-31/why-i-got-access-denied-for-user-root%40localhost-113982/)

likedreamer 11-08-2003 11:49 PM

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 05: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:20 PM.