添加用户 & 用户授权:
用文件倒入整个数据库
导出一个数据到文件
| : |
| mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost'; mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost'; |
用文件倒入整个数据库
| : |
| mysql -u chineseinla -p -h localhost chineseinla --default-character-set=utf8 < /srv/www/mysql.sql |
导出一个数据到文件
:
mysqldump -u username -p --databases database > database.sql
