mysql 操作命令

1，添加用户及全部权限：

grant all privileges on *.* to username@”%” identified by "password";
flush privileges;

2，删除用户权限及用户

mysql> revoke all on *.* from unism
;
Query OK, 0 rows affected

mysql> use mysql;
Database changed

mysql> Delete from user where user = "unism" ;
Query OK, 1 row affected

mysql> flush privileges ;
Query OK, 0 rows affected

3，备份数据库命令：

mysqldump -uroot -p unism_uic > /www/software/unism_uic.dump

4，数据库远程登录：

mysql -h192.168.30.70 -P3306 -uunismjdbc -p