Programare & stuff > mysql

MySQL Error: : 'Access denied for user 'root'@'localhost'

(1/1)

Admin:

/etc/my.cnf
add skip-grant-tables under [mysqld]
mysql -h localhost -u root -p
mysql> flush privileges;
eventual new password by ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
remove comment
restart mysqld

Daca apar mesaje eroare cu parola, drepturi, etc
repetat pasii pana la prompter mysql
mysql> uninstall plugin validate_password;

Navigare

[0] Indexul de Mesaje