On the server we connect to.
1. Edit file my.cnf
- nano /etc/mysql/my.cnf
2. Adding the following line on [mysqld]
on the my.cnf file now looks like this:
- port = 3306
- socket = /tmp/mysql.sock
- skip-locking
- skip-name-resolve
3. restart mysql.
- /etc/init.d/mysql restart
Link:
https://bobbyallen.wordpress.com/2007/11/02/slow-connections-on-remote-mysql-servers/
No comments:
Post a Comment