looking for my.ini that I am using in mysql workbench

I am using mysql workbench on my windows7 desktop

I have installed mysql many times on my computer because I have mysql, wamp and zend php framework

how can I find the my.ini that corresponds to the mysql workbench localhost I am using in the query window
Who is Participating?
Chris StanyonConnect With a Mentor Commented:
When you start mySQL workbench you have the option of creating a new server instance. It looks like your Workbench is configured to connect to an old instance of mySQL (the xampp one) but since you've un-installed it, you'll need to re-configure Workbench.

When you start up Workbench, you'll see a panel for Server Administration - delete the entry that's there (you may have to right-click and select Delete Server Instance), and then create a new one (New Server Instance)

That should then pick up your server correctly.

You may also need to set up or a new connection or edit your existing connection details if the differ  between your XAMPP and WAMP installations.
Chris StanyonCommented:
my.ini is for the server installation, not the software installation, and will be stored in your mysql folder.

It will depend on where you installed wamp. My copy is stored here:


Yours may differ.
rgb192Author Commented:
I am asking if I could type a command in mysql workbench and run a query
Where my.ini

and query would return a file path
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Chris StanyonCommented:
No - that can't be done.
COBOLdinosaurConnect With a Mentor Commented:
Well installing stuff and not knowing where it is does not bode well for a usable development environment.  You should have everthing documented.  If nothing else works just search from the search in windows explorer.

rgb192Author Commented:
Note: I have wamp, xampp (uninstalled and deleted), php zend framework installed.
C:\xampp\ does not exist in windows explorer (even with show hidden files and folders).

Please do not just tell me to uninstall my entire computer so I can find the actual my.ini

using mysql workbench

menu->server->options file

there are error dialog boxes that appear stating I am not using the correct my.ini file and a new one has to be created.

there are error dialog boxes that appear stating I am not using the correct mysqld file and a new one has to be created.

is this the correct my.ini file
rgb192Author Commented:

So I think I will uninstall and reinstall -- when stuff starts going wrong.
Until then, mysql is running

And I should keep track of my own computer installations.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.