MySQL Forums
Forum List  »  Newbie

Re: Can't Start MySQL
Posted by: Peter Brawley
Date: September 17, 2014 11:14AM

> After clicking mySQL from the start menu

Usually not a reliable way to start the mysql server. What command does your menu option try to execute?

To debug the server start process, open a command window, navigate to the bin folder of the mysql installation, and issue this command ...

mysqld --defaults-file="MYSQL_HOME\my.ini" --console –-skip-grant-tables

... substituting for MYSQL_HOME the path to your mysql installation.

If it fails, you will see error messages. If they befuddle you, post them here.

If it succeeds, it will hang, so ...

(i) Stop the server in Task Manager or from another command window with

mysqladmin shutdown

(ii) The command you need for starting the server is therefore

MYSQL_HOME\bin=mysqld --defaults-file="MYSQL_HOME\my.ini"

with the same substitution.



Edited 1 time(s). Last edit at 09/17/2014 11:15AM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
Re: Can't Start MySQL
September 17, 2014 11:14AM
September 17, 2014 04:33PM
September 17, 2014 07:59PM
September 17, 2014 11:03PM
September 18, 2014 05:52AM
September 18, 2014 10:48AM
September 18, 2014 11:14AM
September 18, 2014 11:40AM
September 19, 2014 04:05AM
September 19, 2014 06:00AM
September 19, 2014 03:05PM
October 04, 2014 03:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.