So I’ve been told that the connection properties I need to access the WP database are in wp-config.php in the root of my WordPress directory. I found this file and found these values:
/** MySQL database username */
define('DB_USER', '??????????');
/** MySQL database password */
define('DB_PASSWORD', '**********');
/** MySQL hostname */
define('DB_HOST', '++++++++++');
Obviously I starred out the real values, but suffice it to say I tried to log into this database with MySQL Workbench with:
Hostname: ++++++++++
Username: ??????????
Password: **********
Port: 3306
I keep getting an “Unknown MySQL server host” when I try to connect. My WordPress site seems to work fine.
Solution 1
Check MySQL Services is running ?
Run -> services.msc -> check if not then manually start.
If you use WAMP Server then you forgot to start WAMP Server.
Solution 2
you can not set instance (local user)
Local Instance ($ServerName) - root@127.0.0.1:3306 '<'Standard(TCP/IP)>Solution 3
Find this problem is connection problem or Workbench problem.
mysql -u root -p -h 127.0.0.1 -P 3306The problem was that MySQL Workbench apparently required the “Database Management IP Address” rather than the DB Hostname.