Results 1 to 4 of 4

Thread: How can I see MySQL server running on Linux/ UNIX

  1. #1
    Join Date
    Oct 2010
    Posts
    27

    How can I see MySQL server running on Linux/ UNIX

    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.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,948

    Re: How can I see MySQL server running on Linux/ UNIX

    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.
    Last edited by Praetor; 12-11-2010 at 12:42 PM.

  3. #3
    Join Date
    May 2008
    Posts
    2,012

    Re: How can I see MySQL server running on Linux/ UNIX

    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.
    Code:
    # 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".
    Last edited by Katty; 12-11-2010 at 12:51 PM.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,005

    Re: How can I see MySQL server running on Linux/ UNIX

    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.
    Code:
    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.
    Code:
    mysqladmin -uDB_USERNAME -pDB_USERPASSWORD ping
    Last edited by kelfro; 12-11-2010 at 12:59 PM.

Similar Threads

  1. Is Wine capable to running server-client application on linux
    By Enton Dou in forum Operating Systems
    Replies: 5
    Last Post: 19-01-2011, 03:16 PM
  2. Replies: 4
    Last Post: 13-01-2011, 01:08 AM
  3. Running unix commands within Perl Scripts
    By Ash maker in forum Software Development
    Replies: 5
    Last Post: 09-03-2010, 04:17 PM
  4. Replies: 3
    Last Post: 07-11-2009, 09:36 PM
  5. How to convert UNIX timestamp to MySQL
    By Warner in forum Software Development
    Replies: 2
    Last Post: 16-05-2009, 08:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,675,030,498.89410 seconds with 17 queries