First, when executing the load data command, a message appears, loading local data is disabled; this must be enabled on both the client and server sides
Set needs to be set on the server side local_infile=1
And set MySQL — local infile = 1 – uroot – P when connecting to the client
The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
The mysql.ini file already exists in the installed MySQL directory. You need to create a new my.ini file and add
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
secure-file-priv=
Read More:
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- How to Solve mysql [Err] 1067-Invalid default value for
- How to Solve MYSQL into outfile Error13
- MYSQL Insert Data Error: check the manual that corresponds to your MySQL server version for the right syntax
- Docker: How to Solve MYSQL8 & Navicat remote connection error
- How to Solve c3p0 connect mysql8.0 Error
- How to Solve MYSQL Error: No module named MySQLdb
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- How to Solve MYSQL ERROR: relation “table_name” does not exist
- C# Connect MYSQL Error: MySql.Data.MySqlClient.MySqlException:“SSL Connection error.”
- How to Solve MySQL version 5.7+ Group by group error
- [Solved] FATAL ERROR: please install the following Perl modules before executing /application/mysql/scripts/mysql_install_db: Data::Dumper
- Failed to load file or assembly MySql.Web Solution
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- MySQL: How to Turn on Functions
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- MySQL Error: [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file