MySQL Basic Operations Command

MySQL Permissions:

#查看mysql中用户权限

Show GRANTS;

#查看mysql中指定用户权限

Show GRANTS for ' root ' @ '% ';

#mysql授权:

GRANT all privileges on * * to ' Zabbix ' @ ' percent ' identified by ' Zabbix ';

FLUSH privileges;

#创建数据库:

CREATE database dba_hr;

CREATE schema Dba_ops;

#查询数据库:

show databases;

#进入某个数据库:

Use DBA_HR;

#查看当前在哪个库, the state of the library:

Status

#见表:

CREATE TABLE Test (id int (), col1 VARCHAR (5), col2 TIMESTAMP);

#查看表结构

DESCRIBE test;

#显示表列, describe functions Similarly, describe can be understood as a shortcut to show columns.

Show COLUMNS from host;

#显出错误信息

Show ERRORS;

#显示告警信息:

SHOW WARNINGS

This article is from the "LINUX Super Dream" blog, make sure to keep this source http://215687833.blog.51cto.com/6724358/1893046

MySQL Basic Operations Command