Mysql 5.7 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. Show Here is the snapshot of the C: drive − Click on C drive. The snapshot is as follows. Here, you can see the Program Data folder − Now go to MySQL under Program Data folder. The snapshot is as follows − Go to MySQL version. The snapshot is as follows − Note − Here, we are using MySQL version 8.0.12 Here is the my.ini file. In order to reach the location, you can also use the following command − mysql> select @@datadir; The following is the output − +---------------------------------------------+ | @@datadir | +---------------------------------------------+ | C:\ProgramData\MySQL\MySQL Server 8.0\Data\ | +---------------------------------------------+ 1 row in set (0.00 sec)
Updated on 30-Jul-2019 22:30:25
Asked 1 year, 7 months ago Viewed 2k times I upgraded MySql workbench to version 8.
asked Feb 2, 2021 at 9:09
0 MySQL Workbench tries to find the config file at a common location. If there's none then it will create it, when you edit the configuration and save it (and only then). However, you can set the ini location in your connection details. For that open the connection editor (e.g. by right clicking on a connection tile on the home screen and selecting "Edit Connection...". Once the dialog is open switch to the "System Profile" tab. On this page you will find places where you can set an own config file path and even the config file section, if that differs from the default ("[mysqld]"). answered Feb 3, 2021 at 7:44
Mike LischkeMike Lischke 1,5139 silver badges11 bronze badges Not the answer you're looking for? Browse other questions tagged mysql-5.7 mysql-workbench my.ini or ask your own question.
Item DetailsAudit Name: CIS MySQL 5.7 Enterprise Windows OS L1 v1.0.0 Plugin: Windows Control ID: fca1e10599fa3d6bb98983340d1963d956205f238e68b3226d6a76e1cd2d2fec How do I find my MySQL 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 do I change my ini file in MySQL?Right click on NotePad, and select "Run as Administrator" Then from NotePad open the MySQL my. ini file. Make edits as needed, and save.
Where is the MySQL config file?MySQL config file cnf possible locations. What is my CNF file in MySQL?cnf, /usr/my.
This file contains configuration settings that will be loaded when the server is first started including settings for the clients, server, mysqld_safe wrapper and various other mysql client programs. Note: As of 5.6 version, the my. cnf is written, but all the lines are commented out.
|