phpmyadmin - MySQL root deleted or lost password? -


i lost root privileges on localhost/phpmyadmin , don't know if accidentally deleted root or if lost root password... :

- when type "root" no password on config.inc.php, can access localhost/phpmyadmin can't see databases nor privileges. have nothing.

- when type "root" possible passwords, fail. tried every logins , passwords possibilties, #1045 error (password: "yes")

- in console server (ubuntu via putty), can type mysql -u root -p , access mysql password...

can please me? thank you!

try using username , password debian.conf can using

sudo cat /etc/mysql/debian.cnf  

log in using commandline/putty

$ mysql -u debian-sys-maint -p   mysql> grant on *.* 'root'@'localhost'; mysql> flush privileges; 

once logged in can restore privileges user.


Comments