Remote Desktop Connection MySQL encountered problems and solutions summary

Background: You want to use Delphi to make a desktop application that connects to the MySQL database. There are some problems that make you very distressed. Because he is a novice,Delphi is not familiar with,FireDAC This connection database control is not contact, to install on the CentOS MySQL is more smattering. For a long while, do out of the thing is not connected to the database. It's going to be a big time. But finally found the problem, are in the MySQL Server Setup.

Problem one: The port of the MySQL server is not open. The 3306 port is not open by default. You need to add the 3306 statement in the /etc/sysconfig/iptables configuration file .

question two, remote login The PC client needs to be licensed for a login license. Statements such as.

problem three,etc/my.conf This configuration file restricts the listening requests except for Local. The bind_address needs to be modified to 0.0.0.0 or commented out directly. It is best to add the statement in.

Remote Desktop Connection MySQL encountered problems and summary of solutions