Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

CrastyCrap's avatar

Connect to remote database with phpmyadmin

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.
0 likes
1 reply
lbecket's avatar

You're defining a user of mysqlUserName and the error shows a denial for user root.

Please or to participate in this conversation.