[root@LNMP ~]# /etc/init.d/MysqL start
Starting MysqL. ERROR! The server quit without updating PID file (/usr/local/MysqL/var/LNMP.pid).

root@LNMP var]# tail -f /usr/local/MysqL/var/LNMP.err 
/usr/local/MysqL/bin/MysqLd: Can't create/write to file '/tmp/ibJb9vcs' (Errcode: 13)
161201  8:45:41  InnoDB: Error: unable to create temporary file; errno: 13
161201  8:45:41 [ERROR] Plugin 'InnoDB' init function returned error.
161201  8:45:41 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE Failed.
161201  8:45:41 [ERROR] UnkNown/unsupported storage engine: InnoDB
161201  8:45:41 [ERROR] Aborting

161201  8:45:41 [Note] /usr/local/MysqL/bin/MysqLd: Shutdown complete

161201 08:45:41 MysqLd_safe MysqLd from pid file /usr/local/MysqL/var/LNMP.pid ended

root@LNMP var]# chmod 777 /tmp

[root@LNMP var]# /etc/init.d/MysqL restart
 ERROR! MysqL server PID file Could not be found!
Starting MysqL.. SUCCESS! 
[root@LNMP var]# ps -ef | grep MysqL
root      5305     1  0 08:49 pts/0    00:00:00 /bin/sh /usr/local/MysqL/bin/MysqLd_safe --datadir=/usr/local/MysqL/var --pid-file=/usr/local/MysqL/var/LNMP.pid
MysqL     5690  5305  1 08:49 pts/0    00:00:00 /usr/local/MysqL/bin/MysqLd --basedir=/usr/local/MysqL --datadir=/usr/local/MysqL/var --plugin-dir=/usr/local/MysqL/lib/plugin --user=MysqL --log-error=/usr/local/MysqL/var/LNMP.err --pid-file=/usr/local/MysqL/var/LNMP.pid --socket=/tmp/MysqL.sock --port=3306
root      5712  1969  0 08:49 pts/0    00:00:00 grep MysqL

mysql> CREATE USER ''xxxx''@''localhost'' IDENTIFIED BY ''xxxx'';
Query OK, 0 rows affected (0.00 sec)//这是成功时候应出现的

ERROR 1290 (HY000):      
The MySQL server is running with the --skip-grant-tables     option so it cannot execute this statement

mysql> flush privileges;  //直译：更新权限

PS C:\Windows\system32> net start mysql         //输入这句话啊
MySQL 服务正在启动 .
MySQL 服务无法启动。

C:\MySQL\mysql-5.7.20-winx64\bin>mysqladmin -u root -p password

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.20
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type ''help;'' or ''\h'' for help. Type ''\c'' to clear the current input statement.
mysql>

这样将导入文件放在 /var/lib/mysql-files/文件夹下，之后再从这里导入就可以了

导出文件时候，也是将 文件导出到这个文件夹里。

root@localhost:mysql3306.sock [(none)]>show global variables like ''%secure%'';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| require_secure_transport | OFF |
| secure_auth | ON |
| secure_file_priv | /data/mysql/mysql3306/tmp/ |

Type ''help;'' or ''\h'' for help. Type ''\c'' to clear the current input statement.

root@localhost:mysql3306.sock [(none)]>select * from qt into outfile ''/data/mysql/mysql3306/tmp/qt.sql'';
ERROR 1046 (3D000): No database selected
root@localhost:mysql3306.sock [(none)]>select * from qq.qt into outfile ''/data/mysql/mysql3306/tmp/qt.sql''; //备份表
Query OK, 8 rows affected (0.01 sec)

[root@node1 ~]# cd /data/mysql/mysql3306/tmp/
[root@node1 tmp]# ll
total 4
-rw-rw-rw- 1 mysql mysql 56 Aug 13 06:06 qt.sql
[root@node1 tmp]# pwd
/data/mysql/mysql3306/tmp

恢复：

root@localhost:mysql3306.sock [(none)]>use qq;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
root@localhost:mysql3306.sock [qq]>select * from qt;
Empty set (0.01 sec)

root@localhost:mysql3306.sock [qq]>LOAD DATA INFILE ''/data/mysql/mysql3306/tmp/qt.sql'' into table qq qt;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''qt'' at line 1
root@localhost:mysql3306.sock [qq]>LOAD DATA INFILE ''/data/mysql/mysql3306/tmp/qt.sql'' into table qq.qt;
Query OK, 8 rows affected (0.00 sec)
Records: 8 Deleted: 0 Skipped: 0 Warnings: 0

root@localhost:mysql3306.sock [qq]>

如果显示ERROR 1261 (01000): Row 1 doesn''t contain data for all columns
这个错误，是因为数据行不匹配，默认不能有空，用下列命令解决set sql_modul = 0;