Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

saving MySQL settings

Tags:

mysql

wamp

how can i save permanently settings of MySQL ?
i got MySQL from WAMP, and there is no my.cnf file, there is a my.ini file !
how can i set some global variable,

like image 702
Sourav Avatar asked Apr 22 '11 13:04

Sourav


People also ask

Where is MySQL config file in Windows?

Default Configuration File Locations (Windows) Default file locations that MySQL Router searches for configuration files on Windows. Execute mysqlrouter.exe --help to see the default configuration file locations (and their availability) on your system. In addition: C:\Users\ username \AppData\Roaming\mysqlrouter.

What is MySQL configuration file?

Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient way to specify commonly used options so that they need not be entered on the command line each time you run a program.

Where is MySQL ini file located?

ini file. The default data directory location is C:\Program Files\MySQL\MySQL Server 5.7\data , or C:\ProgramData\Mysql on Windows 7 and Windows Server 2008. The C:\ProgramData directory is hidden by default. You need to change your folder options to see the directory and contents.


1 Answers

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

this is the place to save settings.

like image 87
Sourav Avatar answered Sep 30 '22 13:09

Sourav