Export files with Chinese data in MySQL under Linux from 0 to 1 (not complete)

Annotated version number:

Here's what it looks like when you've just installed MySQL:

First, solve the Secure_file_priv problem:

Since the file is read-only, it can only be changed in root mode. Edit mysqld.cnf using the VI command:

Add this line at the end of the file, save and exit.

Now look again:

Not to be continued.

Reference Links:

1.mysql Command two: Four ways to view MySQL version-duanxz-Blog Park

Https://www.cnblogs.com/duanxz/p/5244634.html

is to see a version number, you can enter MySQL after the status, or select version ();

2.MYSQL data export and import, secure_file_priv parameter settings-CSDN blog

78520511

Regarding MySQL this secure_file_priv question, gives the Linux under the solution is really not easy to find. This article basically operates on this article, adding some implementation details.

3.linux VI common Commands-CSDN blog

44853961

Linux Vi/vim | Beginner's Tutorial

Http://www.runoob.com/linux/linux-vim.html

Welcome Home:vim Online

http://www.vim.org/

Vi/vim operation on those, insert starts editing,: Q Save and exit,: q! do not save exit. Here are a few I think I can.

Export files with Chinese data in MySQL under Linux from 0 to 1 (not complete)