Autor Subiect: MySQL Error: : 'Access denied for user 'root'@'localhost'  (Citit de 13703 ori)

Admin

  • Administrator
  • guru
  • *****
  • Mesaje postate: 58
  • Karma: +0/-0
MySQL Error: : 'Access denied for user 'root'@'localhost'
« : 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;