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