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:mattlaure...@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 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 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org