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
mattlaure...@gmail.com
--
Matt
------
Matt Laurence
mattlaure...@gmail.com
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
