Help! Can"t get my MySQL service started!
am 22.10.2009 19:24:16 von Matthew Laurence
--0016e68f9b636482c10476895dc9
Content-Type: text/plain; charset=ISO-8859-1
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@gmail.com
--
Matt
------
Matt Laurence
mattlaurence@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
--0016e68f9b636482c10476895dc9--
RE: Help! Can"t get my MySQL service started!
am 23.10.2009 01:05:10 von Gavin Towey
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@gmail.com]
Sent: Thursday, October 22, 2009 10:24 AM
To: mysql@lists.mysql.com
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 star=
t
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@gmail.com
--
Matt
------
Matt Laurence
mattlaurence@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
The information contained in this transmission may contain privileged and c=
onfidential information. It is intended only for the use of the person(s) n=
amed above. If you are not the intended recipient, you are hereby notified =
that any review, dissemination, distribution or duplication of this communi=
cation is strictly prohibited. If you are not the intended recipient, pleas=
e contact the sender by reply email and destroy all copies of the original =
message.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg