数据库常用命令

mysqldump备份全库

mysqldump -u root -p --all-databases > backup.sql

还原

mysql -u root -p [dbname] < backup.sql

eg:

mysql -u root -p < C:\backup.sql

创建用户

CREATE USER 'test'@'localhost' IDENTIFIED BY 'test1234'; 

授权

GRANT ALL PRIVILEGES ON *.* TO 'test'@'%' IDENTIFIED BY 'test1234' ;

查询所有用户

SELECT User, Host, Password FROM mysql.user;