I have a new phpMyAdmin installation on y Synology NAS-Server. On the main page it indicated that the root password should be set to avoid unauthorized access.
Therefor I want to set a password so that a user is asked the password when trying to access the phpMyAdmin or the DB:
- I set a password for the root@localhost account.
- Accidentally I removed the email@example.com account.
In the conifg.inc.php I put the following information:
/* Authentication type */
$cfg[Servers][$i][host] = localhost;
$cfg[Servers][$i][auth_type] = config;
$cfg[Servers][$i][user] = root;
$cfg[Servers][$i][password] = new_root_pwd;
When I try to load the phpMyAdmin in the browser of my PC, the following message is displayed:
- #1045 - Access denied for user 'root'@'localhost' (using password: NO)
Does anyone have an Idea how to solve this?