Troubleshooting MySQL : can connect to localhost but not to 127.0.0.1 or IP
- by mireille raad
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 :)
