MySQL Basic Administration Commands

 

If you are beginner then this post will help you to monitor the mysql server.

Here I am listing some most commonly used MySQL administration commands.

  • How to login into the Mysql

> mysql -u root -p

  • Check the number and list of databases.

> show databases;

  • Check the current database in which you logged in.

> select DATABASE();

  • Check the numbers and list of tables in database.

> show tables;

  • Check the database  in which currently we are working.

> select DATABASE() FROM DUAL;

  • Check the numbers,list of engines and  details of engines.

> show engines;

  • Check the detailed information about the tables in particular database.

> show tables status;

  • Assign the Engine to the table.

  • Check processes which is currently active or running on machine.

> show processlist;

  • How to check the particular variables.

> show variables like ‘%gen%’;

Note:- You can use single quote ‘ ‘ instead of ” “ on windows environment on linux system you should use  single quote ‘  ‘  only.

  • Change the values of the variables.

> set global general_log=’OFF’;

  • Check the version of the MySQL sever.

> show global variables like ‘%version%’;

  • Show the detailed information about the version, connection,current database etc.

> status;

How to do MySQL binary installation.

Click here :-  https://dbtut.com/index.php/2018/08/17/how-to-do-mysql-binary-installation/

Rabikumar Singh
Author: Rabikumar Singh

Leave a Reply

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