创建数据库

mysql>CREATE DATABASE `newdatabase` ;

创建用户

mysql>GRANT USAGE ON * . * TO 'username'@'host' IDENTIFIED BY 'password' WITH

MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

权限分配
mysql>GRANT ALL PRIVILEGES ON `databasename` . * TO 'username'@'host' WITH GRANT OPTION ;

把sql文件导入到database数据库中,用户名为：username

shell>mysql -h localhost -u username -p database < /var/lib/mysql/database.sql