Important MySQL and Ubuntu Console Commands

In this post I am providing some important commands for MySQL and Ubuntu.

Let’s first see MySQL Command:

You can execute this all commands in the root directory of the MySQL.
You don’t require to connect MySQL because this command executed by MySQLAdmin.

Check MySQL is running or not:

Check MySQL Current Version:

Check MySQL Current Status:

Check MySQL Server Variables:

Check status of MySQL Server variable’s values:

Check running all MySQL Server Processes:

Safely Shutdown of MySQL:

Let’s see Ubuntu Commands:

Check MySQL is running or not:

Start MySQL Service:

Restart MySQL Service:

Stop MySQL Service:

Check Status of MySQL Service:

Check MySQL Config File:

To Change MySQL Root Password:

You can also visit this article to reset MySQL Root Password:

How to reset MySQL root Password in Ubuntu

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

Leave a Reply

1 Comment on "Important MySQL and Ubuntu Console Commands"

Notify of

Sort by:   newest | oldest | most voted
1 year 1 month ago

Nice Article !
Thanks, this helped in my interview !