Level 39
You're defining a user of mysqlUserName and the error shows a denial for user root.
Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
greeting, I bought a server in digital ocean and i installed MySQL on the server then i added MySQL credentials in my local PHPMyAdmin like below so i can access on it from local machine but i got can't access error on my PHPMyAdmin
Phpmyadmin
$i++;
$cfg['Servers'][$i]['host'] = 'HostName(IP ADDRESS):port';
$cfg['Servers'][$i]['user'] = 'mysqlUserName';
$cfg['Servers'][$i]['password'] = 'mysqlPassword'; //password
$cfg['Servers'][$i]['auth_type'] = 'config'; // keep it as config
Errors i got
Cannot connect: invalid settings.
mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES)
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.
Please or to participate in this conversation.