Being an open source platform, MySQL is one of the greatest utility for web hosting services providers and their clients to manage their databases, furthermore it can be used with both most widely used platforms of Windows web hosting as well as Linux Hosting. MySQL is a fast, robust, secured with encryption and also has very easy installation process. Following are few commands mostly used while operating MySQL.
ps -auxwww | grep mysql
This command is used for Checking whether MySQL Server is running or not
For Starting mysql you should use this command
./mysqladmin -u root shutdown
After the work completed for Shutting down the MySQL you need to use this command.
./mysqladmin -u root processlist
./mysqladmin -u root kill ProcessID
Any help required about mysql can be opened by enterting this command.
This is a useful command to check which query is running on which host, from which location query has been fired , which query has locked which table etc.
This command is used to Kill processes
mysql> help alter;
REPAIR TABLE TableName
You can Repair a table by using this command.
Note :- Few more MySQL commands will shared in upcoming posts.