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.

jundy

R&D Supervisor && Traveller && Nature Lover

More Posts - Website

Follow Me:
TwitterFacebookGoogle PlusYouTube

Leave a Reply

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


*