Linux下mysql的操作命令

mysql -u root -p

show databases;

SELECT count(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA='数据库名';

SELECT sum(DATA_LENGTH)+sum(INDEX_LENGTH) FROM information_schema.TABLES where TABLE_SCHEMA='数据库名';

create database 数据库名;

create database 数据库名 character set utf8;

mysqldump -u root -p 数据库名 > 2015.9.21.sql;

source +文件路径/文件名

use database_name;

show tables; 

exit;

show processlist;

grant all on location.* to gk1020@'10.1.11.71' identified by 'gk1020';

revoke all on location.* from gk1020@'10.1.11.71';

flush privileges;

grant all on location.* to gk1020@'%'

show grants for 你的用户

update user set authentication_string='****' where user='121221'