MySQL Bugs: #51730: Creating a connection to an existing running MySQL service

Bug #51730	Creating a connection to an existing running MySQL service
Submitted:	4 Mar 2010 17:07	Modified:	10 Apr 2010 10:31
Reporter:	dan phipps	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.2.16	OS:	Windows (Server 2003)
Assigned to:		CPU Architecture:	Any

Description:
Exception = System.Runtime.InteropServices.SEHException
Message = External component has thrown an exception.
FullText = System.Runtime.InteropServices.SEHException: External component has thrown an exception.
   at MySQL.Forms.DrawBoxImpl.drawbox_mouse_click(Object sender, MouseEventArgs e)
   at System.Windows.Forms.Control.OnMouseClick(MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

How to repeat:
Setting up the connection to the server. clicking on Server Administartion from the Main Screen, select the instance and clicking ok.

What exact version of MySQL Workbench, 5.x.y, do you use? Do you connect to local or remote MySQL server?

This is running the WorkBench 5.2 on the same machine as the MySQL Server 5.0

If it makes any difference both workbench and MySQL server are running on a Server 2003 VM Image.

Thank you for the feedback. Is your version 5.2.16?. If no please try it. Thanks in advance.

Full Version number is MySQL Workbench 5.2.16

Did you test if connection itself is working?
Did you configure services correct?

Yes the connection works fine and works correctly using the Test Connection feature.

Not sure about the services. Which services are you referring to? And could you give me a tip on the correct configuration.

When you configure a new server instance in Workbench then you will find a field where you need to add the MySQL server service name. Default this is set to mysqld but maybe your MySQL server service is named different.

The MySQL instance already existed prior to the installation and use of WorkBench. WorkBench was then setup to use a new connection to this instance. I can't see where to change the service name howverer, the install of MySQL was a default install so the service is called mysqld

"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini" MySQL

http://dev.mysql.com/doc/workbench/en/wb-manage-server-instance-dialog.html

Look into figure 7.2.

There you need to fill the right place for your my.ini

and additionally at "Instance [name] ..." the correct service name.

You can find the service name on your Windows system under System -> Services.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".