Mysql: Occurs when you execute a source SQL script: Error 2

Deploying MySQL under CentOS:

1, yum-y install mysql*;

2, service mysqld start;

3, Chkconfig mysqld on;

4. Set user name and password: mysqladmin-uroot password123456

5, enter the database: Mysql-uroot-p Enter the password after entering the set

6. Establish database: Create database name;

7. Switch to the database you want to use

8, import the written sql:source absolute path/xx.sql;

At this point, if the following error occurs:

Mysql> Source/opt/openfire/database/openfire_mysql.sql;
ERROR:
Failed to open file '/opt/openfire/database/openfire_mysql.sql ', error:2

The error means that the file was not found

How to Troubleshoot:

1, there are files, however, do not have permission to execute

2, there are documents, the path is not correct

3. No documents

Mysql: Occurs when you execute a source SQL script: Error 2