MySQL database import SQL file in CentOS

1. For the import of files, under CentOS is the first to create a new database with the same name as the file.

mysql>create database Student;

2. Switch to the database where you want to import the SQL file

use Student;

3. If there are no errors, the instructions are entered into your new database. Then set the code first:

mysql>set names utf8;

4. Then enter the location of the database text Student.sql file you imported into CentOS

mysql>source /usr/database.sql;   文件相同名字的数据库

5. Then you'll see the success of many query statements on the screen, then OK.

6. At this time through the local MySQL client is unable to log on to the remote server Linux MySQL, need to authorize a bit

GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘youpassword‘ WITH GRANT OPTION;

MySQL database import SQL file in CentOS