Do you have a program called mysql_install_db? It looks like you need that to create the
initial mysql system database in your data directory.
Regards,
Gavin Towey
-----Original Message-----
From: Matthew Laurence [mailto:mattlaurence@stripped]
Sent: Thursday, October 22, 2009 10:24 AM
To: mysql@stripped
Subject: Help! Can't get my MySQL service started!
I'm trying to configure and start a MySQL 5.1 service for the first time,
and I'm having trouble. The MySQL Server 5.1 system was installed on a
separate drive from the system drive (if that's an issue). My GUI tools are
on the C: drive, and the server installation is on the E: drive.
Anyway, I'm using mysql administrator to try and create, configure and start
a new MySQL database. I've never done this before, and I'm having trouble
finding any clear guidance on how to do it online. I think I'm close, but
here is the log of my last three attempts to start my new service:
SERVICE SETTINGS:
Display Name: MySQL
Service Description: MySQLESAI
CONFIGURATION FILE:
Config fielname: E:\Program Files\MySQL\MySQL Server 5.1\my-large.ini
(I chose this one at random to have something to start with)
Section Name: mysqld
PATH TO BINARY: E:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld
This all seems pretty clear and ok... so here we go:
Attempt 1:
Trying to start the server ...
Server could not be started.
Can't create test file E:\Program Files\MySQL\MySQL Server
5.1\data\mail.lower-test
Can't create test file E:\Program Files\MySQL\MySQL Server
5.1\data\mail.lower-test
Aborting
E:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete
I then created a "data" folder in that directory, and tried to start it
again:
Attempt 2:
Trying to start the server ...
Server could not be started.
Plugin 'FEDERATED' is disabled.
Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
I ran mysql_upgrade which seemed to work (gave me no indication there were
any problems. Then tried again to start through Administrator:
Attempt 3:
Trying to start the server ...
Server could not be started.
Plugin 'FEDERATED' is disabled.
Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
Recovering after a crash using mysql-bin
Starting crash recovery...
Crash recovery finished.
Fatal error: Can't open and lock privilege tables: Table 'mysql.host'
doesn't exist
So this sounds bad. I don't know if this has anything to do with it, but I
followed the advice at this site:
http://dev.mysql.com/doc/refman/5.1/en/windows-start-service.html
and added the MyQL bin path (E:\Program Files\MySQL\MySQL Server 5.1\bin)
to my system PATH... any issues there?
Any help or guidance would be very very helpful - I need to get this thing
running ASAP! Thank you so much in advance - please send any responses to
mattlaurence@stripped
--
Matt
------
Matt Laurence
mattlaurence@stripped
http://www.mattlaurence.com/
Senior Interactive Art Director
http://www.linkedin.com/in/mattlaurence
Bassist, Publicist, Humorist
www.secretagentmen.com
Pix: www.flickr.com/mattlaurence
Follow me at: http://twitter.com/Mattynabib
DJ Nabib: http://blip.fm/Mattynabib
The information contained in this transmission may contain privileged and confidential
information. It is intended only for the use of the person(s) named above. If you are not
the intended recipient, you are hereby notified that any review, dissemination,
distribution or duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender by reply email and destroy all copies
of the original message.
