The option file does not affect MySQL 5.6 client

I created an option file C:\my.ini

[mysqld]
basedir=C:\Program Files\MySQL\MySQL Server 5.6
datadir=C:\Program Files\MySQL\MySQL Server 5.6\data
innodb_buffer_pool_size=6710886400
innodb_file_per_table=ON
innodb_file_format=Barracuda
innodb_large_prefix=ON
local_infile=ON

I can see the settings take effect in mysqld.exe --help --verbose.

However, when I query the system variables from the MySQL client, the settings are not effective.

mysql> select
    ->
    -> @@innodb_large_prefix as innodb_large_prefix,
    -> @@innodb_file_format as innodb_file_format,
    -> @@innodb_file_per_table as innodb_file_per_table,
    -> @@local_infile as local_infile;
+---------------------+--------------------+-----------------------+--------------+
| innodb_large_prefix | innodb_file_format | innodb_file_per_table | local_infile |
+---------------------+--------------------+-----------------------+--------------+
|                   0 | Antelope           |                     1 |            1 |
+---------------------+--------------------+-----------------------+--------------+
1 row in set (0.00 sec)

I installed MySQL 5.6 as a Windows Service on Windows 10.



Read more here: https://stackoverflow.com/questions/67376775/the-option-file-does-not-affect-mysql-5-6-client

Content Attribution

This content was originally published by Coo Lest at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: