Solved

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

Posted on 2013-12-07
7
922 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
  • 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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
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…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

786 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