Can't get php script to connect to asterisk internal mysql database

Question

I'm trying to get a PHP script to connect to Asterisks internal sql database.

I tried the to use the standard method for example

$con = mysqli_connect("192.168.1.126","root","mysql","asterisk");

However when I log into the asterisk server to access the mysql database all I need it to type "mysql" and I'm logged in.

Im wondering is it possible for my php script to connect to asterisk internal database.

//edit The following mysql error is shown

Warning: mysqli_connect(): (HY000/2003): Can't connect to MySQL server on '192.168.1.126' (111) in /var/www/html/project/sipSubScript.php on line 6
Failed to connect to MySQL: Can't connect to MySQL server on '192.168.1.126' (111)

Answer 1

The problem in the end was that mysql was only listening for connections from localhost. So to solve the problem find your my.cnf file which should be located in the /etc/ folder.

To find it I used ls -l my* im not sure if this commad is correct but it found it for me anyway.

Inside the file should look like this:

[mysqld]
#bind-address = 127.0.0.1   //uncommented this line using #
general_log = 1
general_log_file = /var/log/mysql/mysql.log
datadir=/var/lib/mysql/mysql/sock
user=root
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Next you need to restart mysql and you done, this can be done using:

sudo /etc/init.d/mysqld restart