Вариант раз:
1 |
mysql -p |
1 2 3 4 |
use mysql; update user set plugin='' where User='root'; flush privileges; exit |
Вариант два:
1 |
mysql -p mysql |
1 2 3 |
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'some_pass'; GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; |