MySQL Server Basic Commands In Daily Use On CentOS 7

MySQL Server basic commands, I’m going to show you how to create users, create databases and tables. These are the MySQL daily use commands with these commands we can manage the little tasks on the servers. you can also check a number of processes are running on the servers using the below command.   

show processlist; 

With the above command, you can check which query is taking a long time to execute.

Check Out: Solve MySQL Can’t Connect To Local MySQL Server Through Socket

MySQL Server Basic Commands In Daily Use On CentOS 7:

First of all, check how many databases is present thereby command

show databases;  

Basic Commands of MySQL

Then Choose any database or you can create your database as well.

create database server;

mysql basic commands

Check Out: Install MySQL 5.6 Database Server Using Repository In Linux

Now Use database by below command

use server;

mysql commands for database

Now try to create a table

CREATE TABLE cus_abl(

cus_ids INT NOT NULL AUTO_INCREMENT,

cus_ftname VARCHAR(100) NOT NULL,

cus_srname VARCHAR(100) NOT NULL,

PRIMARY KEY ( cus_ids )

);

Now the table has been created.

Check Out: How To Check Users In Mysql Database Server In Linux

You can see what’s inside the tables it will empty as we did not assign any values.

You’re done. mysql commands for database  create table

Share on:

I'm the founder of Curious Viral. I hope this blog will provide you complete information about Linux Technology & I would like to share my technical knowledge with you which I have learned during this period.

Other Posts You May Like...

Leave a comment