Troubleshooting MySQL : can connect to localhost but not to 127.0.0.1 or IP

Posted by mireille raad on Server Fault See other posts from Server Fault or by mireille raad
Published on 2010-04-25T21:15:04Z Indexed on 2010/04/25 21:23 UTC
Read the original article Hit count: 422

Filed under:
|

Hello, I'd appreciate some help on this, it is bit tricky to find the correct keywords to google :)

Using PHP i am able to connect using the following connection string : $link = mysql_connect('localhost', 'wlek' , 'wlek');

but when i use 127.0.0.1 or 10.10.40.15 (self-IP), i am getting connection failed Could not connect: Can't connect to MySQL server on '10.10.40.15' (13)

I used yum install mysql , yum install php yum install php-mysql

1 - is there anything more i should install for php ? 2 - any troubleshooting tips ? 3 - what keywords, links do u recommend

| % | mir | xdb | | 10.10.40.15 | mir | xdb |
| localhost | mir | xdb |

[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock

user=mysql port=3306

bind-address=0.0.0.0 old_passwords=1

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid ~

appreciate it :)

© Server Fault or respective owner

Related posts about mysql

Related posts about php