How To Resolve MySQL Slow Connection Error in Linux

How To Resolve MySQL Slow Connection Error in Linux

mysql, mysql download, mysql tutorial, mysql version, mysql slow query log, mysql slow query, mysql server, mariadb slow query log,mysql download,mysql commands, mysql queries
MySQL 

mysql, mysql download, mysql tutorial, mysql version, mysql slow query log, mysql slow query, mysql server, mariadb slow query log,mysql download,mysql commands, mysql queries




Question : MySQL Server is slow performing ?
Question : MySQL Slow Connection Error Resolve.

MySQL Server lookup a Hostname for authentication,  for example: [email protected]
So we required  speed up remote connections to your remote database servers.
We Just Change Your Setting in MySQL Configuration File

Verify MySQL version
mysql -V
MySQL Configuration File :

Add following Line in /etc/my.cnf

skip-locking

skip-name-resolve

# vi /etc/my.cnf

[mysqld] 

port = 3306

socket = /tmp/mysql.sock

skip-locking

skip-name-resolve


Now Restart The MySql Server

#service mysqld restart

Previous
Next Post »