Mariadb/mysql Usage Tips-Continuous update

1. Mysqladmin

   Mysqladmin-u User-p password ' new password ' ==> change password

   Mysqladmin-u User-P [-H remote server address] shutdown ==> can shut down the server locally or remotely

   Mysqladmin-u User-P status ==> view status

   Mysqladmin-u User-P procelesslist==> view Process

   Mysqladmin-u user-P kill id Number = = Kill process

2. mysql

Mysql-u User-P [-H remote server address] [database]-e ' SQL statement ' ==> Execute SQL directly

3. Common statements

Select Database ();==> View current Library

Select User ();==> displays the current user

Show status;==> display Run status

Show databases or tables;==> view library or table

status==> Display Status

TRUNCATE TABLE table name;==> empty tables

ALTER TABLE ADD column name parameter [frist|last column name];==> add column

ALTER TABLE DROP column name;==> Delete Column

Show grants for user @% or host name/ip;==> display permissions

Show privileges;==> display all system permissions

Create user user @% or host name/ip;==>

Revoke permissions from user ==> Reclaim permissions

This article is from the "Blue Sky" blog, make sure to keep this source http://shurk.blog.51cto.com/1134443/1745548

Mariadb/mysql Usage Tips-Continuous update