Solution for mysql connection failure of php using 127.0.0.1 in CentOS

Source: Internet
Author: User
Php code is simple: $ server127.0.0.1; println (Begin); $ linkmysql_connect ($ server, mysql, mysql); if (! $ Link) {die (Couldnotconnect:. mysql_error (). mysql_errno ();} You can use phpmysql. php on a linux machine to view the running results, but in my wind

Php code is simple: $ server = "127.0.0.1"; println ("Begin"); $ link = mysql_connect ($ server, "mysql", "mysql"); if (! $ Link) {die ('could not connect :'. mysql_error (). mysql_errno ();} Use php mysql in linux. php can view the running results, but in my wind

Php code is simple:


$ Server = "127.0.0.1 ";
Println ("Begin ");
$ Link = mysql_connect ($ server, "mysql", "mysql ");
If (! $ Link ){
Die ('could not connect: '. mysql_error (). mysql_errno ());
}

In linux, you can use php mysql. php to view the running result, but an error is reported in my windows browser:


Cocould not connect: Can't connect to MySQL server on '2017. 0.0.1 '(13) 127

Cause:


# Getsebool-a | grep httpd
[Neo @ neo phpMyTest] $ getsebool-a | grep httpd


Httpd_can_network_connect --> off
Solution:


# Setsebool httpd_can_network_connect 1

It turns out to be SELINUX, so I usually disable SELINUX and iptables ip6tables directly.


# Disable SELINUX
Chkconfig -- level 12345 iptables off

Chkconfig -- level 12345 ip6tables off

Service iptables stop

Service ip6tables stop


View SELinux status:

1./usr/sbin/sestatus-v # If The SELinux status parameter is enabled, it is enabled.

SELinux status: enabled

2. getenforce # You can also use this command to check

Disable SELinux:

1. temporarily shut down (no need to restart the machine ):

Setenforce 0 # Set SELinux to permissive Mode

# Setenforce 1 Set SELinux to enforcing Mode

2. to modify the configuration file, restart the machine:

Modify the/etc/selinux/config file

Change SELINUX = enforcing to SELINUX = disabled

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.