How To Resolve MySQL Slow Connection Error in Linux

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: remoteuser@10.20.2.33
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