MySQL invalid - not incorrect - password ?
After installing PHPMyAdmin on a Cobalt 550r, I proceeded to modify the root password for MySQL.
I updated it for the user root through PHPMyAdmin which at the time gave me an unrestricted access, and updated the root password directly in the mysql database.
Access for root then was totally refused, in my MySQL log I have the following error :
"Found invalid password for user: 'root@localhost'; Ignoring user"
User root being ignored causes SOME problems, you see
Obviously I cannot access PHPMyAdmin anymore nor the base by the command line (Access denied for user: 'root@localhost' (Using password: YES).
Oddly enough Google does not have many results for that error, and none relevant for me.
I then proceeded to Kill MySQL to try and restart bypassing grant tables, but it seems MySQL won't stop, after I kill the process I always have another one running :
ex :
ps aux | grep mysql
kill -9 10904
after that ps aux | grep mysql
still gives
mysql 11933 0.0 1.6 28596 4120 ? S 16:47 0:00 /usr/sbin/mysqld-
etc...with a new PID
Has anybody seen this before ? Can anybody advise ?
thanks,
