Linux MySql commands and Linux MySql commands

Linux MySql commands and Linux MySql commands

1. Install the MySql server command:
Yum install mysql-server

Yum install mysql-devel

2. Install the MySql client

Yum install mysql

3. Start the service

Service mysqld start or/etc/init. d/mysqld start

Stop:
Service mysqld stop

Restart:
Service mysqld restart

4. Create a root administrator:
Mysqladmin-u root password 123456

5. Login

Mysql-uroot-p123456

6. Authorize remote connection access

Grant all privileges on *. * TO 'root' @ '%' identified by 'Password' with grant option;
7. display the database
Show databases;

8. Switch to a database

Use mysql (database name)

9. display tables in the database

Show tables;

10. display the data table structure:
Describe table name;