phpmyadmin | Covax Blog

Ошибка #1698 — Access denied for user ‘root’@’localhost’

Posted on 15.02.2018 by Covax

Вариант раз:

mysql -p

mysql -p

use mysql;
update user set plugin='' where User='root';
flush privileges;
exit

use mysql;

update user set plugin='' where User='root';

flush privileges;

exit

Вариант два:

mysql -p mysql

1	mysql -p mysql

CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'some_pass';

GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;

FLUSH PRIVILEGES;