Solved

Unable to start MySQL server

Posted on 2006-11-07
7
1,614 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Creating and Managing Databases with phpMyAdmin in cPanel.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 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