The option file does not affect MySQL 5.6 client

I created an option file C:\my.ini

basedir=C:\Program Files\MySQL\MySQL Server 5.6
datadir=C:\Program Files\MySQL\MySQL Server 5.6\data

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:

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: