By BlackAndWhite on

I can't get mySQL to run even though I have the correct password.

I had drupal6 running on a website and foolishly tried to upgrade from 6.16 to 6.22 by uninstalling 6.16 and then installing 6.22. I was having simple directing problems and I tried fixing things in myphpadmin. I deleted my root directory and then things took a turn for the bad. mySQL could no longer run and I have no idea how to fix it.

I've tried reinstalling phpmyadmin and everything related to mySQL and still do not have any luck getting it to run. I know mySQL is running because when I type in:

ps -ef | grep mysql

I get
mysql 1149 1 0 20:23 ? 00:00:00 /usr/sbin/mysqld
jeremy 2314 2283 0 20:34 pts/0 00:00:00 grep mysql

When I type in: "mysql -u root -p" and enter the password I get reset I get the message:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I've tried using an init file and loading it from there, resetting passwords and using dkpg to reset things but still have no luck.

Does anyone ever had this happen to them or know how to fix it?

⋅ Categories: Drupal 6.x

Comments

sachinbal’s picture

sachinbal commented

Hi,

I have been trying to install and I am facing the same problem. Did you find a solution for the same? Can someone help, please?

Regards

Sachin

itzme’s picture

itzme commented

the most probable reason could be the entry for the username used by you does not have the FILE privilege enabled in the user table.

praveenkv1988’s picture

praveenkv1988 commented

Re-installing phpmyadmin will not help. You should reset your mysql server root password. You can do this by starting mysql with skip grant privilleges option.