PHP :: Connection database another host very slow on ubuntu.

PHP :: Connection database another host very slow on ubuntu server

On the server we connect to.
1. Edit file my.cnf

1. nano /etc/mysql/my.cnf

2. Adding the following line on [mysqld]
on the my.cnf file now looks like this:

1. port = 3306
2. socket = /tmp/mysql.sock
3. skip-locking
4. skip-name-resolve

3. restart mysql.

1. /etc/init.d/mysql restart

Link:
https://bobbyallen.wordpress.com/2007/11/02/slow-connections-on-remote-mysql-servers/