Determine what MySQL Server is running

Definition of Terms:
MySQL Server = refers to the mysql server that was installed using Ubuntu Software Center/Synaptic Package Manager. The one that can be started using “sudo /etc/init.d/mysql start” or “sudo /etc/init.d/mysqld start”
Lampp MySQL = refers to the mysql server that is bundled with the lampp server. The one that can be started using “sudo /opt/lampp/lampp start” or “sudo /opt/lampp/lampp startmysql”

When troubleshooting mysql server errors/issues it is very important to know what mysql server is running to properly solve the issue.

How to find what type of MySQL Server is running?

  • Open terminal by going to Applications > Accessories > Terminal or by keyboard shortcut “CTL+Alt+T”.
  • Test if Computer is using MySQL Server:
    sudo /etc/init.d/mysql status

    The above command will output something like the following:

    Rather than invoking init scripts through /etc/init.d, use the service(8)
    utility, e.g. service mysql status
    Since the script you are attempting to invoke has been converted to an
    Upstart job, you may also use the status(8) utility, e.g. status mysql
    *mysql start/running, process 7488*

    The most important part of the above output is the last line which tells you that mysql is running. Therefore, you are using MySQL Server. If the result is notmysql start/running, it tells you that MySQL Server was installed but not running.

  • Test if Computer is using Lampp MySQL:
    sudo /opt/lampp/lampp status

    The above command will output something like the following:

    Version: XAMPP for Linux 1.7.3
    Apache is running.
    MySQL is running.
    ProFTPD is running.

    The above code tells you that Lampp MySQL is running and you are using that server. If the result is not MySQL is running, it tells you that Lampp MySQL is installed but not running.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

I did not put any annoying ads which are forcing you to open other sites and install apps.

However, maintaining this site isn't a freebie. I put this up to help fellow travelers in planning their trip and expecting no return.

This time, I am asking for a small favor by subscribing to the youtube channel below which focuses on travel videos and IT-related tips.

It only takes one click and tadan... it's done! 

Also, please like this blog's Facebook page to show your support and get updates on the latest articles.