Remote Desktop Connection MySQL encountered problems and solutions summary

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.