mysql -uroot -p -hlocalhost 登录;
show create database xxx :查看数据库编码;
create user 'xxx'@'%' :创建用户,%表示所有用户都可以访问 ;
create user 'xxx'@'192.168.0.%' :表示该网段下所有用都可以访问;
create user 'xxx'@' %' identified by 'abc':创建秘密为abc;
select user,host from mysql.user查看用户信息;
alter user 'xxx'@'%' identified by '123' 修改密码;
grant replication slave on *.* to 'xxx'@'%' :赋予读取权限给xxx用户;
revoke all on *.* from 'xxx'@'%' :收回权限;
drop user 'xxx' :删除用户;
desc table :查看表结构;
show create table xxx\G:查看建表xxx的创建语句;
mysqldump -uroot -p xxx > /usr/local/mysqlbak.sql;数据库备份;
mysql -uroot -p xxx<mysqlbak.sql :数据库恢复