MySQL Workbench

Hi Everyone,

I am getting an error upon trying to Create New Server Instance Profile (click preceding link for image) :

Operation failed: /usr/local/mysql/support-files/mysql.server start is invalid

I am not sure where the setting panel is for the workbench to fix the start and stop commands, and the location of ‘/usr/local/mysql/support-files/mysql.server’. I am using Zend Server CE and I have no directory called ‘/usr/local/mysql’, instead mysql.server is situated in ‘/usr/local/zend/mysql/bin’ but how do I tell Workbench to look for it in the appropriate place.

The start and stop commands are :

sudo /usr/local/zend/mysql/bin/mysql.server <stop\\start>

Again how do I fix this for workbench.

See if these instructions help: http://dev.mysql.com/doc/workbench/en/wb-new-server-instance-wizard.html

I have been to that page before but unfortunately it does not give any troubleshooting information.

I took another look and apparently you can set it under Server Administration → Manage Server Instances → System Profile
Many Thanks.