How to kill a hanging MySQL Client Process?

First you need to identify the Loading MySQL client process using the mysql processlist command. # mysqladmin -u root processlist +—–+————–+———–+————–+———+——+——-+——————+ | Id  | User         | Host      | db           | Command | Time | State | Info             | +—–+————–+———–+————–+———+——+——-+——————+ | 95  | eximstats    | localhost | eximstats    | Sleep   | … Continue reading

How to check mysql version/uptime

Check the mysql version,protocol version as well as mysql uptime to using the following command from the shell but you need to use server root login details to run the command from the shell. [root@youknowlinux ~]mysqladmin -hlocalhost version mysqladmin  Ver 8.42 Distrib 5.5.23, for Linux on x86_64 Copyright (c) 2000, … Continue reading