“Cannot connect: invalid settings.
mysqli_real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
Connection for controluser as defined in your configuration failed.
mysqli_real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.
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.”
Question posted in PhpMyAdmin
The official documentation can be found here.
The official documentation can be found here.
2
Answers
Depending on your environment, OS (Linux/Windows..), you should make sure the mysql/mariadb service is running.
and which port is listening to :
Second, make sure the credentials defined in your configuration actually exist an have the proper rights inside mysql
If the mysql/mariadb service is running, you can connect and check :
from os shell :
here you should find your user as defined in file “wp-config.php”, where wordpress should store mysql connection data.
Examples are from Linux, since I think is the most common, but if you share more on your environment, the answer could be more accurate.
Locate config.inc.php
find this,
if there is localhost change it to 127.0.0.1
Like this
Change
into
Save.
Then restart your local server.