error handling - MySQL Workbench Will not connect to localhost. "Database server instance is unknown" -

my mysql workbench not connecting local host, , cannot figure out why reacting this. started doing 1 day, , randomly give me access although says still "unknown", tired of , fix it.

since website reqires have "10" reputation post images, have describe it.

on startup/shutdown tab in administration page, says:

the database server instance unknown. --the "start server" button faded out cannot click it.

startup message log 2013-07-11 08:57:51 - workbench use cmd shell commands start/stop instance

2013-07-11 08:57:51 - status check of service 'mysql' returned error: not found

2013-07-11 08:57:51 - status check of service 'mysql' returned error: not found

2013-07-11 09:00:55 - status check of service 'mysql' returned error: not found

2013-07-11 09:00:55 - status check of service 'mysql' returned error: not found

2013-07-11 09:02:01 - status check of service 'mysql' returned error: not found

then on server status tab in administration page, says:

name: mysqld@localhost host: localhost server:unknown status: unknown

connection there no connection mysql server. functionality requires established connection running mysql server work.

if can out, great!

thanks

i had problem on windows 8.1 machine , turned out problems file permissions.

to repair went folder @ "c:\program files\mysql\mysql server 5.6" , right clicked on "data" folder , selected properties. clicked security tab , clicked edit. there click add button advanced button , find button. in mine added users, administrators, , "all application packages". granted full control users listed data folder , users, administrators, , application packages.

after permissions repaired opened command prompt administrator , changed "c:\program files\mysql\mysql server 5.6\bin" directory cd "c:\program files\mysql\mysql server 5.6\bin". there can execute mysqld --install installs mysql service.

more information installing mysql service on windows can found @ http://dev.mysql.com/doc/refman/5.0/en/windows-start-service.html

[edit] please note if using different version of mysql path mysql data directory , bin directory may different on windows machine.