How can I see MySQL server running on Linux/ UNIX

[Wamilr]

There is a some problem i have with my MySQL server. I am using linux operating system in my computer. How do I find out if my MySQL server is running or not under Linux / UNIX operating systems? Is there is a any trick to find it? If anyone have any idea about it then please replay me as soon as possible.

[Praetor]

There is a some command that we have to use to check MySQL server running on Linux/ UNIX or not. Open command prompt. Type the following code / usr/ local/ mysql/ bin/ mysqladmin ping if your mysqladmin install in / usr/ local/ path. If your mysql is not found in that default path then first you have to find your mysql package. To find your mysqladmin you have to type code whereis mysqladmin. After finding the mysql package type first code with proper file path. If mysql is alive message displayed then MySQL server is running otherwise not.

[Katty]

You can use mysql startup script or mysqladmin command to find out if MySQL server is running on Linux/ Unix or not. Type mysqladmin command in a command prompt.

# mysqladmin -u root -p status

If MySQL serer is running it will display output without error message. It displays uptime and number of queries etc. If server is not running then it will give error as "connect to server at 'localhost' failed".

[kelfro]

I think mysqladmin command is a best option to see MySQL server running on Linux/ UNIX or not. Type following code to know your MySQL server status.

mysqladmin -umysql ping

If your MySQL server running on your Linux/ UNIX operating system then it will show "mysqld is alive” message to you. If it doesn’t work then try with another mysqladmin command which is also use to to replace DB_USERNAME and DB_USERPASSWORD with actual values.

mysqladmin -uDB_USERNAME -pDB_USERPASSWORD ping