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
Post a Comment