MySQL Bugs: #56911: creating new (first) server instance: find_config

Bug #56911	creating new (first) server instance: find_config_file/local fails
Submitted:	21 Sep 2010 23:11	Modified:	13 Dec 2010 11:58
Reporter:	Phil Freihofner	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.28 CE/5.2.29	OS:	Windows (XP-Home)
Assigned to:	Mike Lischke	CPU Architecture:	Any

Description:
I just installed MySQL 5.1 (from mysql-essential-5.1.50-win32.msi) and MySQL Workbench 5.2 CE.

I am able to run MySQL from the command prompt.

I am trying to Create a New Server Instance profile, in order to be able to connect to my localhost instance of MySQL. I have selected standard settings as much as possible. When I come to the "Test Settings" step, I get the following message:

What find_config_file/local
Check if  can be accessed
Operation failed: File  doesn't exist

This seems puzzling. Does it refer to my.ini? This file does exist at 
c:\Program Files\MySQL\MySQL Server 5.1\my.ini
and can be read.

Any suggestions?

Thanks!

How to repeat:
Run installation file 
mysql-workbench-gpl-5.2.28-win32.msi

When application comes up, select "Create New Server Instance Profile"

once yo are create a a 'server instance' to server administration, open this. Then click 'Open server profile manager' icon and there select 'System profile' and 'configuration file' option to select the correct file configuration (C:\xampp\mysql\bin\my.cnf, for example). Close and open the server instance.

My apologies. I may have overstated the severity and am putting it at non-critical. But I'm not really sure, as I do not know enough and haven't tried to do everything that will really test this setup.

>>[22 Sep 5:01] Gerardo Gutierrez S 
once yo are create a a 'server instance' to server administration, open this. Then click 'Open server profile manager' icon and there select 'System profile' and 'configuration file' option to select the correct file configuration (C:\xampp\mysql\bin\my.cnf, for example). Close and open the server instance.<<

HI - Thanks!
I'm afraid I have further questions:

1) I am unclear as to what file should be selected for the configuration. I am currently trying "\MySQL Server 5.1\my.ini". I cannot find anything that is a .cnf file. Also, there are no .ini or .cnf files in my \bin subdirectory.

2) There is an additional field on this page: "Configuration File Section:" and I am wondering what this refers to and if it is ok to leave it blank.

3) When I bring up the "Configuration" tab, I see very little has been filled in. There is not even a basedir or datadir. Do these have to be put in by hand? I thought they were standard. How do I know what other aspects of the config need to be filled in? Is there an area in any manual that specifies what the standards settings might be?

4) When I go to the Startup tab and try and turn off the server, I get an error: "Could not stop server--expected a character buffer object" on a popup and the server keeps running. Could this be related?

Thank you for your time.

Holy Smokes! I see now that the Edit Configuration section purposely leaves things blank! Doh!

So, I guess I am good to go. Thanks again!

I really think too that it should find (or propose) the configuration file automatically when it is in installation folder.  I had the same issue.

But if multiple 'my.ini/cnf's exist on the system it may not be the one in installation folder that is used.  An instance in c:\ will have precedence for instance (refer http://dev.mysql.com/doc/refman/5.0/en/option-files.html)

(... and that is a mess actually - this reflects the Unix heritage of MySQL and traditional Unix thinking that 'there is only of server instance of same kind on a computer'.  The copy in installation folder should be 1st choice in Windows - and it should actually be moved to 'AppData' BTW (due to UAC problems)).

Thank you for the bug report.

Bug:http://bugs.mysql.com/bug.php?id=57498 marked as duplicate of this one.

Fixed in repository.

New User; Same confusion; Same bug in 5.2.30 CE Rev 6790

Scott, this issue is still under review and did not make it into 5.2.30. It does not get released before it has been tested and documented.

I think I found a workaround.
In Testing Host Machine Settings after you see in log "What find_config.....doesn't exist" you click next
In the Review MySQL Management Parameters screen that comes up you tick Change parameters (lower left) and click next
Then it opens the Information about MySQL configuration page where you just use the file finder button to declare where your configuration file is (my.ini)click check path to see it is OK and fill in the Section of the Sever instance name you put mysql.
(Since I am completely new to this I can't help you with the commands needed in the next screen (Start stop and status command) If you or anyone knows please report it.)
BUT you don't need the next screen. You go back until you find Testing Host Machine Settings again where is PASSES the test and then you UNTICK the Change parameters and go on with the wizard.
It worked for me

fix confirmed in repository

An entry has been added to the 5.2.31 changelog:

When creating a new server instance, the following error occurred on testing settings:

Operation failed: File  doesn't exist

I had the same problem and the following worked for me.
1. Open MySQL Workbench.
2. In the Server Administration column click on Manage Server Instances (last item in list).
3. Click the New button to create a new instance.
4. Type a name for the Instance Profile Name.
5. In the connection tab make sure you have the correct connection selected.
6. On the System Profile tab, if the values were not automatically filled in, make sure System Type and Installation Type are correctly selected, then browse to your my.ini file for the Configuration File field.
7. If the Configuration File Section field is empty, type in mysqld.
8. Click Close.

The server instance should now be available in the Server Administration list.  Hope this saves you some time.