Look in the MySQL config file C:\xampp\mysql\bin\my. ini . # You can copy this file to # C:/xampp/mysql/bin/my. cnf to set global options, # mysql-data-dir/my.

Where can I find my CNF file xampp?

Look in the MySQL config file C:\xampp\mysql\bin\my. ini . # You can copy this file to # C:/xampp/mysql/bin/my. cnf to set global options, # mysql-data-dir/my.

Where is my CNF file located in Windows?

cnf file may be called my. ini . MySQL looks for it in the following locations (in this order): %PROGRAMDATA%\MySQL\MySQL Server 5.7\my.

Where can I find XAMPP CNF file in Ubuntu?

I installed xampp bundle with apache, php and mysql in ubuntu. There my.cnf file is located in /opt/lampp/etc/ folder. Hope it’ll help somebody. All great suggestions, in my case I didn’t find it in any of those locations, but in /usr/share/mysql, I have a RHEL VM and I installed mysql5.5

Where can I Find my CNF file?

There my.cnf file is located in /opt/lampp/etc/ folder. Hope it’ll help somebody. All great suggestions, in my case I didn’t find it in any of those locations, but in /usr/share/mysql, I have a RHEL VM and I installed mysql5.5 You will have to look through the various locations depending on your version of MySQL.

Where does MySQL read my CNF file?

As noted by konyak you can get the list of places mysql will look for your my.cnf file by running mysqladmin –help. Since this is pretty verbose you can get to the part you care about quickly with: Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /usr/local/etc/my.cnf ~/.my.cnf

Where does XAMPP find the default path for MySQL?

There is a block of text about 3/4 the way down describing what files it finds its defaults .my.cnf from. Here is an example from XAMPP v3.2.1: Your setup may differ. You will have to run the command to check the actual paths on your particular system. Show activity on this post. Look in the MySQL config file C:\xampp\mysql\bin\my.ini.