mysql连接时出现2003-,连接到mysql服务器时出现问题：ERROR 2003（HY000）

Server ip: 172.16.1.169

mysql user name: root

passwd: xxxxxxxxxx

database name: example

I'm trying to access a database from a client (ip 172.16.0.114). Both the server and client are running the Fedora distribution of Linux. What settings need to be configured, and what should they be set to, for both the server and client? How do I access a specific database (here, "example")? I tried but I got an error:

ERROR 2003 (HY000): Can't connect to MySQL server on '172.16.1.169'.

解决方案

That error message is generated by the client (not the server) because a connection to the server has been attempted but the server could not be reached.

There are various possible causes to that:

1) check that mysqld is running on the server:

ps -ef | grep mysqld

should return something like:

root 243