5 18

MySQL常用

mysqldump -uusername -ppassword -h ip db_name table > file   导出数据库表
mysql  -uusername -ppassword -h ip db_name < file 导入数据
grant all privileges on *.* to 'user'@'host' identified by 'pass' with grant option 给用户有所有权限(包含授权权限)