- Plesk for Linux
Database was created in Plesk and a "root"' user for this database. However, trying to open phpMyAdmin on behalf of this user, phpMyAdmin shows a "denied access" error.
The new version of phpMyAdmin prohibits use of the "root" username by default.
- Connect to the server using SSH.
- Manually change phpMyAdmin settings. Open the
/usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/config.default.phpfile and set the property as follows:
CONFIG_TEXT: $cfg['Servers'][$i]['AllowRoot'] = true