Solved

Unable to start MySQL server

Posted on 2006-11-07
7
1,603 Views
Last Modified: 2010-04-28
Experts,

I have installed MySQL version 4, released on mysql.com and also GUI tools 5, again from mysql.com

I am using php to query website.

I have set MySQL to use old passwords using mysql admin, however when I stop the service and then try to start it up again it hangs....

When I attempt to start within Services the error reports;

Error 1067, the process terminate unexpectedly

??

0
Comment
Question by:nickmarshall
7 Comments
 
LVL 1

Author Comment

by:nickmarshall
ID: 17888905
Message from MySQL admin.  I have commented out the OLD_Passwords part within my.ini however the same problem is apparent.

Trying to start the server ...

Could not re-connect to the MySQL Server.
Server could not be started.

Can't init databases


0
 
LVL 30

Accepted Solution

by:
todd_farmer earned 84 total points
ID: 17891083
Is the MySQL server running?  If you are on Windows, check the Process Manager.  If Linux, run ps aux | grep mysqld

If the server is not running, start it.  If it cannot start, please locate the error log file (hostname.err in the data directory) and post the contents.
0
 
LVL 14

Assisted Solution

by:ppfoong
ppfoong earned 83 total points
ID: 17895100

The clue is this:

"Can't init databases"

If it is a new install, delete all the database files inside the MYSQL\data folder, and let MySQL recreate them.

Before this, you might want to check for any error message in the file yourservername.err, inside the MYSQL\data folder.

0
 
LVL 4

Assisted Solution

by:Sheeri
Sheeri earned 83 total points
ID: 17895369
try to run mysql_install_db in your binary folder -- it should be the same folder mysql and mysqld are in.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This video discusses moving either the default database or any database to a new volume.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now