Saving MySQL Settings

Question

How can I keep MySQL settings persistent?
I got MySQL from WAMP, and there is no my.cnf file, there is my.ini file!
how can i set some global variable

Answer 1

Drive:\wamp\bin\mysql\mysql5.5.8\my.ini

This is the place to save the settings.

Answer 2

WAMP uses the my.ini file.

To get to the my.ini file, simply click on the WAMP tray icon and hover over the MySQL menu and click on my.ini.

• Edit the my.ini file and in the [mysqld] section add the following:

  setting-name=setting-value, example: event-scheduler = on

• restart all services

.

Answer 3

SQL ( /) ().

Answer 4

, WAMP my.ini my.conf.

SQL :

mysql> SET global max_heap_table_size=524288000;
mysql> SET global tmp_table_size=524288000;

:

select @@global.tmp_table_size, @@global.max_heap_table_size

.

my.ini, :

max_heap_table_size=524288000
tmp_table_size=524288000

.