Solved

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

Posted on 2013-12-07
7
928 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
mysql ide 10 48
MySQL Memory Keeps Increasing 4 63
i am unable to add data to mysql database 6 53
restriction of entering a a page 5 34
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
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.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 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