reset password
Author Message
kaancalstatela
Posts: 52
Posted 07:06 Feb 28, 2014 |

Hello,

I started having problems with Mysql. I managed to get the workbench working but I cannot connect to my root user local database because mysql does not start in the background. Checked the password on the workbench for root user. It stuck after configuration while attempting to start the database so I cancelled it and tried starting it from Services with the Log-on information. Nothing worked.

My lab is in a couple hours so I would really appreciate some help.

 

Thank you.

kaancalstatela
Posts: 52
Posted 07:14 Feb 28, 2014 |

Managed to run it from services, started the service in the background and works smoothly now.

 

kaancalstatela
Posts: 52
Posted 07:21 Feb 28, 2014 |

Ran into the same issue again. Feels like it's arbitrary at this point. A fresh restart seems to take care of the problem before it surfaces again.

 

Any help would be appreciated.
 

cysun
Posts: 2935
Posted 08:38 Feb 28, 2014 |

Make sure the Startup Type for the MySQL service is Automatic.

If the service just randomly dies, check the error log for error messages. The error log should be called <computer_name>.err and located in the data folder (usually C:\ProgramData\MySQL\MySQL Server 5.6\data).

You can also try reinstalling MySQL.

And you can always use your database on CS3. It may feel a little slower than a local database but it's perfectly usable.

Last edited by cysun at 08:38 Feb 28, 2014.