Run mysql database server running3/1/2023 ![]() ![]() Join the nixCraft community via RSS Feed, Email Newsletter or follow on Twitter. He wrote more than 7k+ posts and helped numerous readers to master IT topics. Vivek Gite is the founder of nixCraft, the oldest running blog about Linux and open source. Shell script to restart MySQL server if it is killed or not working due to ANY causes.# service mysqld statusOR # /etc/init.d/mysqld statusSee also: If you are using RedHat of Fedora then you can use following script” Threads: 1 Questions: 66 Slow queries: 0 Opens: 51 Flush tables: 1 Open tables: 45 Queries per second avg: 0.258 This is free software,Īnd you are welcome to modify and redistribute it under the GPL license This software comes with ABSOLUTELY NO WARRANTY. To run the test suite, change location into your mysql-test directory and invoke the script: shell> cd mysql-test shell>. # /etc/init.d/mysql statusOutput: /usr/bin/mysqladmin Ver 8.41 Distrib 4.1.15, for pc-linux-gnu on i486Ĭopyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB Under Debian Linux you can type following command to find out if MySQL server is running or not Output: mysqladmin: connect to server at 'localhost' failedĮrror: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'Ĭheck that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists! If server is not running then it will dump error as follows It displays uptime and number of queries etc. If MySQL serer is running it will display output as above. Uptime: 4 Threads: 1 Questions: 62 Slow queries: 0 Opens: 51 Flush tables: 1 Open tables: 45 Queries per second avg: 15.500 ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |