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
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