Level 39
You're defining a user of mysqlUserName and the error shows a denial for user root.
Summer Sale! All accounts are 50% off this week.
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.