I had accidently delete "root" user @localhost in phpmyadmin, now browser says access denied with following message, i need to recover it

Asked Jan 05 '20 at 18:23

Active Mar 28 '20 at 05:29

Viewed 138 times

1

MySQL said:
Cannot connect: invalid settings.

mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

2.Connection for controluser as defined in your configuration failed

mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

asked Jan 05 '20 at 18:23

Sandun Nawagamuwa

11
1

1

Does this answer your question? [How can I restore the MySQL root user’s full privileges?](https://stackoverflow.com/questions/1709078/how-can-i-restore-the-mysql-root-user-s-full-privileges) – Joseph Sible-Reinstate Monica Jan 05 '20 at 18:25

0 Answers0