Fatal error: Can't open privilege tables: Table 'mysql.host'

Der MySQL Datenbank-Server für Internet- und Intranet-Lösungen.

Fatal error: Can't open privilege tables: Table 'mysql.host'

Beitragvon Gast » Do 24 Jul, 2003 12:42

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!
Gast
 

keine user-datenbank

Beitragvon Gustavo el Geranie » Do 24 Jul, 2003 16:20

Anscheinend hast du noch keine user-datenbank angelegt.
Lies noch mal die Installationsanweisung durch und such nach dem mysql_install_db skript.
Gustavo el Geranie
Neu im Board
Neu im Board
 
Beiträge: 14
Registriert: Mo 23 Jun, 2003 16:10


ZurĂĽck zu MySQL

Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 15 Gäste