my.ini LOCATION ON WINDOWS MYSQL 5.6 MSI (USING THE INSTALL WIZARD) Show Open a Windows command shell and type: According to http://dev.mysql.com/doc/refman/5.6/en/option-files.html, the first location MySQL will look under is in Unlike most suggestions you will find in Stackoverflow and around the web, putting the file in
The 5.6 MSI installer does create a my.ini in the highest priority location, meaning no other file will ever be found/used, except for the one created by the installer. The solution accepted above will not work for 5.6 MSI-based installs. answered Dec 1, 2013 at 10:46
amateur baristaamateur barista 4,2303 gold badges24 silver badges37 bronze badges 4
answered Feb 23, 2015 at 22:35
Bae Cheol ShinBae Cheol Shin 1,4001 gold badge10 silver badges10 bronze badges 1 I've found mine in
(It is a hidden folder) You can type
sɐunıɔןɐqɐp 2,99515 gold badges34 silver badges38 bronze badges answered Jul 3, 2018 at 6:13
Mangue SutcliffMangue Sutcliff 1,2091 gold badge10 silver badges16 bronze badges 0 You
have to look I the folder
Once, you do this,
superjos 11.7k5 gold badges86 silver badges128 bronze badges answered Jan 30, 2013 at 6:51
RolandoMySQLDBARolandoMySQLDBA 43.2k16 gold badges89 silver badges130 bronze badges 8 Start MySQL Workbench, then Server -> Options File and look at bottom of the window; it will say something like "Configuration File: C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" (And note the subtle difference between "ProgramData" and "Program Files" - easy to gloss over if you're looking for a quick answer.) answered Sep 2, 2014 at 15:29
ChiraelChirael 2,9354 gold badges27 silver badges28 bronze badges 1 Answered for only MySQL Workbench users, answered Jul 3, 2017 at 11:27
MAXMAX 1,5044 gold badges16 silver badges23 bronze badges You can find the my.ini file in windows at this location- C:\ProgramData\MySQL\MySQL Server 5.6 the ProgramData folder is a hidden folder, so make the according setting to see that folder. And open my.ini file as an administrator to edit and then save that. answered Aug 28, 2015 at 9:12
anubhsanubhs 5568 silver badges26 bronze badges In my case, the folder After selecting show hidden files and folders option, I was able to
find the Display hidden files and folders on windows 7:
answered Feb 6, 2017 at 14:38
it is there at C:\Program Files\MySQL\MySQL Server 5.5 there are various .ini files with small, medium & large names. generally medium is used or it depends on your requirement. answered Jan 30, 2013 at 6:28
RaulRaul 5791 gold badge5 silver badges17 bronze badges 2
Be sure to update the correct You can look into service to see which
answered Apr 5, 2018 at 10:06
Press the windows key > type services > press enter > Look up mysql in the list > right click > properties > Path to Executable will have the location of the defaults file right below it (my.ini) answered Jul 31, 2019 at 20:50
Open your run console type: services.msc look for: mysql right click properties where is written "path to executable", click and move the cursor to the right until you see the directory of my.ini, it's written "defaults-file-". to reach it manually on your explore folders you have to enable the visualization of hidden elements (explore folder>top menu>visualize>visualize hidden elements) as explained by this video https://www.youtube.com/watch?v=SvCAa2XuQhg answered Feb 11, 2019 at 11:35
Tms91Tms91 2,8322 gold badges34 silver badges61 bronze badges on Windows if MySQL is install as a service you can change the binpath of the service. For example
space after binpath is important. You must escape double quotes answered May 14, 2020 at 10:59
MySQL and MariaDBAccording to the documentation of both MySQL and MariaDB you need to run mysql with Go to the command or terminal
You will see large output but first few lines will show the order the server is looking for the file. I got the following response. It will be different for your computer or server.
answered Oct 3, 2021 at 14:56
I met with the same problem when I did MSI install of MySQL and there were no my-medium.ini files too when I tried the above steps. Only installing the ZIP file of MySQL helped me. So, I suggest you to uninstall the MSI installed folder and reinstall using the ZIP file. answered Jan 22, 2017 at 4:58
For MySql Server 8.0 The default location is %WINDIR% or C:\Windows. You need to add a "my.ini" file there. Here's a sample of what I put in the ini file.
Make sure to restart the MySQL service after that. answered Dec 10, 2020 at 20:33
user890332user890332 1,21714 silver badges15 bronze badges How do I access my ini?The my. ini is in hidden folder of program data. First go to C: drive and then hidden folder of program data. From that, move to the MySQL version directory.
How can I edit my CNF file in Windows?Editing the Mysql my.. Login to your server via SSH.. To edit the MySQL settings with nano type the following: ... . Find the line to edit. ... . To increase the max_connections to 110 change it to the following. ... . Enter Ctrl + O to “WriteOut” or save the settings.. Then Ctrl + X to exit.. Restart MySQL by typing the following.. Where is MySQL my INI file on Windows?According to http://dev.mysql.com/doc/refman/5.6/en/option-files.html, the first location MySQL will look under is in %PROGRAMDATA%\MySQL\MySQL Server 5.6\my. ini . In your Windows shell if you do ls "%PROGRAMDATA%\MySQL\MySQL Server 5.6\my. ini" , you will see that the file is there.
How do you create an INI file?Creating the my.. Open the my. ini file in a text editor.. Add the following settings to the my. ini file in the text editor. Note: Make sure that the path for the MySQL database is correctly specified for socket . my.ini File for Small Size Cube. my.ini File for Mid Size Cube. ... . Save the file.. |