eForum.ro

Programare & stuff => mysql => Subiect creat de: Admin din Mai 27, 2019, 12:10:15 p.m.

Titlu: MySQL Error: : 'Access denied for user 'root'@'localhost'
Scris de: Admin din Mai 27, 2019, 12:10:15 p.m.

/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;