基本指令
- 参看所有数据库
show databases;- 使用数据库
use databasename;- 参看当前数据库中的所有表
show tables;- 查看表的结构
describe tablename;- 查看建表的sql语句
show create table tablename;- 查看数据库版本
select version();
status;
权限管理
- 查看当前用户的权限:
show grants;- 查看某个用户的权限:
show grants for ‘jack’@’%’;- 赋予权限
grant all privileges on *.* to jack@’localhost’ identified by “jack” with grant option;- 刷新权限
flush privileges;- 回收权限
revoke delete on . from ‘jack’@’localhost’;- 查看所有用户
select * from mysql.user;- 创建用户
create user ‘root’@’%’ identified by ‘root’;
参考链接:https://www.cnblogs.com/Richardzhu/p/3318595.html
复制
- 快速复制数据库
mysql>CREATE DATABASEnewdb
DEFAULT CHARACTER SET UTF8 COLLATE UTF8_GENERAL_CI;
#mysqldump db1 -u root -ppassword –add-drop-table | mysql newdb -u root -ppassword
#mysqldump db1 -uroot -ppassword –add-drop-table | mysql -h 192.168.1.22 newdb -uroot- 拷贝数据库到文件
#mysqldump -h x.x.x.x -uroot -ppassword databasename > xx.sql- 导入数据
use databasename;
source D:\path\xx.sql;
参考链接:http://www.edbiji.com/doccenter/showdoc/10/nav/3078.html