Solved

Unable to start MySQL server

Posted on 2006-11-07
7
1,609 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

813 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

14 Experts available now in Live!

Get 1:1 Help Now