Solved

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

Posted on 2013-12-07
7
932 Views
Last Modified: 2013-12-13
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
0
Comment
Question by:rgb192
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 43

Expert Comment

by:Chris Stanyon
ID: 39703057
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:

C:\wamp\bin\mysql\mysql5.5.24\my.ini

Yours may differ.
0
 

Author Comment

by:rgb192
ID: 39703127
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
0
 
LVL 43

Expert Comment

by:Chris Stanyon
ID: 39703139
No - that can't be done.
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 53

Assisted Solution

by:COBOLdinosaur
COBOLdinosaur earned 200 total points
ID: 39703177
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.

Cd&
0
 

Author Comment

by:rgb192
ID: 39703183
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
0
 
LVL 43

Accepted Solution

by:
Chris Stanyon earned 300 total points
ID: 39708042
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.
0
 

Author Closing Comment

by:rgb192
ID: 39717918
Thanks

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.
0

Featured Post

Webinar: MongoDB® Index Types

Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents “MongoDB Index Types, How, When and Where Should They be Used?” on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question