Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

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
Sign in to Comment

Related questions

How to write raw query in Laravel
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
com.mysql.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library
Random ids in sqlalchemy (pylons)
No duplicates in SQL query
How to get the greatest of two columns values in MySQL?
Want Row Number on Group of column in MY SQL?
Multiple MYSQL queries vs. Multiple php foreach loops
How can I store PHP code inside of a mysql table
How to include the mysql header?
Adding database results to array
Read a text file and transfer contents to mysql database
Should you do validation checks that go outside the possiblility of normal user activity?
MySQL "IS IN" equivalent?
How do I create a database if it doesn't exist, using PHP?
How can I change my MySQL collation in WAMPSERVER
SQL NOT BETWEEN query
Padding the beginning of a mysql INT field with zeroes
mysql_fetch_array does not retrieve all rows
mysql group_concat in where

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!