添加用户 & 用户授权:

代码:

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

导出一个数据到文件