创建数据库
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
转载于:https://blog.51cto.com/yunhuyuetian/810365