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,
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.
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.
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.
Drive:\wamp\bin\mysql\mysql5.5.8\my.ini
this is the place to save settings.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With