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.
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
- Related Questions & Answers
- Why can't my HTML file find the JavaScript function from a sourced module?
- How do I find the location of my Python site-packages directory?
- Can I write my own MySQL functions to use in MySQL queries?
- Can't find user by name with MongoDB?
- How to find MySQL my.cnf on my windows computer?
- How can I replace & with an ampersand in my MySQL database?
- Which version is my MySQL?
- How to find the MySQL data directory from command line in Windows?
- Can my home WiFi be hacked?
- mysql_install_db - Initialize MySQL Data Directory
- How can I enhance my select query to make it faster in MySQL?
- How can I find the percentage of my users whose birth date is between 1980 and 1996 in MySQL?
- How to can I get the names of my MySQL table columns?
- Why can't we use column name “desc” in MySQL?
- How can I set my auto-increment value to begin from 1 in MySQL?
Asked 1 year, 7 months ago
Viewed 2k times
I upgraded MySql workbench to version 8.
I'm running MySql Server 5.7. When I open the options file in workbench it says it cannot locate a file for
MySql 8 and that it will create one in the path C:\ProgramData\MySql\MySql Server 8\my.ini
I do not have MySql Server 8 installed.
- Why is workbench not finding the file?
- How can I point it towards the correct file?
- Do I need to downgrade workbench?
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.
- Audits
- Items
- %PROGRAMDATA%\MySQL\MySQL Server 5.7\my.ini Exists
- Items
Item Details
Audit Name: CIS MySQL 5.7 Enterprise Windows OS L1 v1.0.0
Plugin: Windows
Control ID: fca1e10599fa3d6bb98983340d1963d956205f238e68b3226d6a76e1cd2d2fec