MySQL Remote connection problem summary

and the summary will be a lot more enlightened! so about linux create mysql services and how this piece of talk.

The first step: if the use of the cloud host, then the installation is relatively easy, it is necessary to note that only install the relevant files, note the list of files

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/57/2D/wKioL1STySazDPkiAABqA13Dzgg580.jpg "style=" float: none; "title=" Qq20141218171425.png "alt=" Wkiol1stysazdpkiaabqa13dzgg580.jpg "/>

Second step: After the installation is complete, go to MySQL command line through mysql command , modify the root of MySQL Remote connections for users

　　Grant all privileges on * * to [email protected] '% ' identified by ' xxxxx ';// Modify Remote Permissions

　　Flush privileges;// Refresh Permissions

Step three: using the navicat tool for remote connection access under Windows, it is important to note that if the Linux Firewall is turned on, it's not going to be a successful connection .!! andSmall SeriesYesterdayis becausehave never thought of this question,soIt's not going to be connected, and it's wasting a lot of time .Hey .

Fourth step: Check The Linux firewall status, then close !! You can also use other, better ways

　　Service iptables status// View Status

　　Service iptables stop// Close

You can then access it through the Windows remote connection.

Summary: Although the process is very simple, but if you do not notice the problem of the firewall, it is a very bad brain !!

Troubleshooting MySQL cannot connect remotely with Linux

System environment : Linux centos-6.4-64bit

root The account is only accessed natively, if you want to access it through another machine linux mysql The database must be configured, so let me introduce my solution. First, use the root The account is entered from the command line mysql

1. Span style= "font-family: ' The song Body '; The statement below gives accessible permissions to the corresponding account, " User name and ' password '

　　Grant all privileges on * * to ' User name ' @ '% ' identified by ' Password ' with GRANT option;

　　2. Write permissions

　　Flush privileges;

　　3. Restart the database

　　Service mysqld Restart

In the event that the network is being secured, I find that it is not possible to remotely connect to the MySQL database on Linux as configured above . Later I found that the firewall in the mischief, there are still two solutions, one in the configuration file add 3306 port exceptions, a direct shutdown of the firewall, I now use the second approach, the direct shutdown of the firewall. Next, I open the terminal, enter setup, the following interface will appear

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/57/30/wKiom1STyIOiVAemAAEP0LbUtUc517.jpg "title=" Qq20141218172234.png "style=" Float:none; "alt=" wkiom1styioivaemaaep0lbutuc517.jpg "/>

Press ENTER to enter, the following interface will appear

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/57/2D/wKioL1STySegkWHEAAE2yCL8WuY667.jpg "title=" Qq20141218172300.png "style=" Float:none; "alt=" wkiol1stysegkwheaae2ycl8wuy667.jpg "/>

Use the space bar to select whether to enable, when I disable, using the remote client connection, it is now possible to connect, the problem finally successfully resolved.

Share from multi-backup forum bbs.dbfen.com Reprint please specify the source

This article is from the "Big Meatball" blog, please make sure to keep this source http://12478147.blog.51cto.com/9663367/1591723

MySQL Remote connection problem summary