In the terminal I type mysql -u root and I receive “ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)”. From the terminal I type mysql -u root -p and receive “ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)”. The only way I can login is by typing: 1) /etc/init.d/mysql stop 2) mysqld_safe –skip-grant-tables & 3) mysql -u root But when I restart the server, I no longer have access to mysql from the terminal and no access to phpMyadmin from web browser using root user. Before I started having login issues , I was inside phpMyAdmin. I was inside the Users interface and I was looking at User root with Host localhost. I remember selecting the specific user and clicking Edit Privileges and entered a password in the Change Login Information / Copy User section and I clicked Go. When I tried logging back into phpMyAdmin I started receiving “Error 1045”. I don't think its a password issue using root user because when I log into phpMyAdmin using the above three steps to enter mysql without password. I no longer see root user using localhost. I say localhost because I remember seeing localhost and not the name of my network hostname. I think that might be the problem, but I'm not sure. I do see root user using my network hostname and its the primary user I use for mysql and phpMyAdmin. I don't understand why root user can no longer access mysql. When I try creating localhost root user I receive error message “#1290 – The MYSQL server is running with the –Skip-grant-tables option so it cannot execute this statement” What if I click the reset button to reset all settings and restore them to default values. Would that help. I don't want to create more issues. That is why I'm asking if it's OK if I reset phpMyAdmin. I don't want to delete my databases along with their tables. So it's probably a good idea not to reset phpMyAdmin. What can I do to fix this, so I can log in using root user again? I've already tried resetting root password and it did not help. My web server is Apache 2.2.15 (CentOS). The database server is running version 5.1.73 - source distribution.
Have you Googled? This thread on stack seems to have a few possible solutions: http://stackoverflow.com/questions/...enied-for-user-rootlocalhost-using-password-y
phpMyAdmin is a php script to use SQL databases. I don't really think you loss the data if you reset it, it should be just a configuration reset. You can change the root password by entering mysql through the command line (you can google it, it's quite easy)