mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) error on Mac

Question

This is the error message I got after I tried to make a password and username for localhost and root. Please help me. I am using Mac by the way.

MySQL said: Documentation

Cannot connect: invalid settings.

mysqli::real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)

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.

Answer 1

go to xampp\mysql\bin\my.ini and open it. change the port to 3307 and go to xampp\phpMyAdmin\config.inc.php and check the name of the host $cfg['Servers'][$i]['host'] = 'localhost:3307';