Hoffe, dass mir jemand weiterhelfen kann.
Ich habe auf einem W2K-Server MySQL installiert. Soweit lief auch alles gut, bis ich den Server neu starten musste.
Nun lässt sich MySQL weder als Dienst noch als Standalone starten.
Die Error-Datei gibt folgende Fehler aus:
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
030606 8:04:35 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
030606 8:04:35 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
030606 8:04:36 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
030606 8:04:40 InnoDB: Started
mysqld-nt: ready for connections.
Version: '4.0.13-nt-log' socket: '' port: 3306
030606 8:07:16 mysqld-nt: Normal shutdown
030606 8:07:16 InnoDB: Starting shutdown...
030606 8:07:17 InnoDB: Shutdown completed
030606 8:07:17 mysqld-nt: Shutdown Complete
030606 8:19:06 InnoDB: Started
MySql: ready for connections.
Version: '4.0.13-nt-log' socket: '' port: 3306
030607 22:25:50 MySql: Normal shutdown
030607 22:25:51 InnoDB: Starting shutdown...
030607 22:25:54 InnoDB: Shutdown completed
030607 22:25:54 MySql: Shutdown Complete
030607 22:29:20 InnoDB: Started
MySql: ready for connections.
Version: '4.0.13-nt-log' socket: '' port: 3306
030723 17:22:13 MySql: Normal shutdown
030723 17:22:15 InnoDB: Starting shutdown...
030723 17:22:25 InnoDB: Shutdown completed
030723 17:22:25 MySql: Shutdown Complete
030723 17:25:59 InnoDB: Started
030723 17:25:59 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030723 17:25:59 Aborting
030723 17:25:59 InnoDB: Starting shutdown...
030723 17:26:01 InnoDB: Shutdown completed
030723 17:26:01 MySql: Shutdown Complete
030724 8:33:06 InnoDB: Started
030724 8:33:06 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030724 8:33:06 Aborting
030724 8:33:06 InnoDB: Starting shutdown...
030724 8:33:08 InnoDB: Shutdown completed
030724 8:33:08 MySql: Shutdown Complete
030724 8:33:18 InnoDB: Started
030724 8:33:18 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030724 8:33:18 Aborting
030724 8:33:18 InnoDB: Starting shutdown...
030724 8:33:20 InnoDB: Shutdown completed
030724 8:33:20 MySql: Shutdown Complete
030724 8:33:52 InnoDB: Started
030724 8:33:52 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030724 8:33:52 Aborting
030724 8:33:52 InnoDB: Starting shutdown...
030724 8:33:54 InnoDB: Shutdown completed
030724 8:33:54 MySql: Shutdown Complete
030724 9:02:19 InnoDB: Started
030724 9:02:19 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030724 9:02:19 Aborting
030724 9:02:19 InnoDB: Starting shutdown...
030724 9:02:21 InnoDB: Shutdown completed
030724 9:02:21 MySql: Shutdown Complete
030724 9:03:07 InnoDB: Started
030724 9:03:07 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030724 9:03:07 Aborting
030724 9:03:07 InnoDB: Starting shutdown...
030724 9:03:09 InnoDB: Shutdown completed
030724 9:03:09 MySql: Shutdown Complete
030724 9:20:16 InnoDB: Started
030724 9:20:16 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030724 9:20:16 Aborting
030724 9:20:16 InnoDB: Starting shutdown...
030724 9:20:18 InnoDB: Shutdown completed
030724 9:20:18 mysqld-nt: Shutdown Complete
030724 10:29:12 InnoDB: Started
030724 10:29:16 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030724 10:29:16 Aborting
030724 10:29:16 InnoDB: Starting shutdown...
030724 10:29:18 InnoDB: Shutdown completed
030724 10:29:19 mysqld: Shutdown Complete
030724 10:30:10 InnoDB: Started
030724 10:30:10 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030724 10:30:10 Aborting
030724 10:30:10 InnoDB: Starting shutdown...
030724 10:30:12 InnoDB: Shutdown completed
030724 10:30:12 MySql: Shutdown Complete
030724 10:42:43 InnoDB: Started
030724 10:42:43 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030724 10:42:43 Aborting
030724 10:42:43 InnoDB: Starting shutdown...
030724 10:42:45 InnoDB: Shutdown completed
030724 10:42:45 MySql: Shutdown Complete
Wie ersichtlich kann MySQL anscheinend nicht starten, da die InnoDB einen Fehler verursacht (Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist)
Da ich in MySQL nicht so bewandert bin (blutiger newbie) sagt mir die Fehlermeldung nichts. Ich wĂĽsste auch nicht, dass ich die InnoDB verwende. Auf dem Server sehe ich auch keine InnoDB Dateien oder Verzeichnisse.
Falls notwendig, kann ich auch die my.cfg posten.
Wäre für eine rasche Hilfe sehr dankbar!