PDA

Visualizza la versione completa : Mysql non va


SMASH
04-08-2004, 19:45
Ciao, ho installato la Slack 10, con apache/php/mysql, ma purtroppo quando avvio mysql ottengo un errore:

# mysqld_safe&

# Starting mysqld daemon with databases from /var/lib/mysql
040804 18:42:45 mysqld ended

SMASH
07-08-2004, 15:37
nessuno mi sa aiutare? :(

side-server
07-08-2004, 15:41
xch tenti di avviarlo coi permessi errati, prova con mysqld_safe --user=mysql &

:ciauz:

SMASH
07-08-2004, 15:45
Mi d lo stesso errore...

Sym81
07-08-2004, 15:47
Quello potrebbe essere un motivo, in ogni caso sotto /var/lib/mysql *dovresti* avere un file .err con i log degli errori. Ciao :)

SMASH
07-08-2004, 15:55
040731 15:32:51 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
040731 15:32:51 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
040731 15:32:52 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...
040731 15:32:52 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
040731 15:32:54 InnoDB: Started
040731 15:32:54 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
040731 15:32:54 Aborting

040731 15:32:54 InnoDB: Starting shutdown...
040731 15:32:56 InnoDB: Shutdown completed
040731 15:32:56 /usr/libexec/mysqld: Shutdown Complete

040731 15:32:56 mysqld ended

040731 15:33:19 mysqld started
040731 15:33:19 InnoDB: Started
040731 15:33:19 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
040731 15:33:19 Aborting

040731 15:33:19 InnoDB: Starting shutdown...
040731 15:33:21 InnoDB: Shutdown completed
040731 15:33:21 /usr/libexec/mysqld: Shutdown Complete

040731 15:33:21 mysqld ended

040802 19:12:04 mysqld started
040802 19:12:05 InnoDB: Started
040802 19:12:05 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
040802 19:12:05 Aborting

040802 19:12:05 InnoDB: Starting shutdown...
040802 19:12:07 InnoDB: Shutdown completed
040802 19:12:07 /usr/libexec/mysqld: Shutdown Complete

040802 19:12:07 mysqld ended

040802 19:15:04 mysqld started
040802 19:15:05 InnoDB: Started
040802 19:15:05 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040802 19:15:05 Aborting

040802 19:15:05 InnoDB: Starting shutdown...
040802 19:15:07 InnoDB: Shutdown completed
040802 19:15:07 /usr/libexec/mysqld: Shutdown Complete

040802 19:15:07 mysqld ended

040802 19:15:22 mysqld started
040802 19:15:23 InnoDB: Started
040802 19:15:23 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040802 19:15:23 Aborting

040802 19:15:23 InnoDB: Starting shutdown...
040802 19:15:25 InnoDB: Shutdown completed
040802 19:15:25 /usr/libexec/mysqld: Shutdown Complete

040802 19:15:25 mysqld ended

040802 19:16:53 mysqld started
040802 19:16:53 InnoDB: Started
040802 19:16:53 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040802 19:16:53 Aborting

040802 19:16:53 InnoDB: Starting shutdown...
040802 19:16:56 InnoDB: Shutdown completed
040802 19:16:56 /usr/libexec/mysqld: Shutdown Complete

040802 19:16:56 mysqld ended

040802 19:20:07 mysqld started
040802 19:20:07 InnoDB: Started
040802 19:20:07 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040802 19:20:07 Aborting

040802 19:20:07 InnoDB: Starting shutdown...
040802 19:20:09 InnoDB: Shutdown completed
040802 19:20:09 /usr/libexec/mysqld: Shutdown Complete

040802 19:20:09 mysqld ended

040802 19:20:52 mysqld started
040802 19:20:52 InnoDB: Started
040802 19:20:52 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040802 19:20:52 Aborting

040802 19:20:52 InnoDB: Starting shutdown...
040802 19:20:54 mysqld started
040802 19:20:54 Can't start server: Bind on TCP/IP port: Address already in use
040802 19:20:54 Do you already have another mysqld server running on port: 3306 ?
040802 19:20:54 Aborting

040802 19:20:54 /usr/libexec/mysqld: Shutdown Complete

040802 19:20:54 mysqld ended

040802 19:20:55 InnoDB: Shutdown completed
040802 19:20:55 /usr/libexec/mysqld: Shutdown Complete

040802 19:20:55 mysqld ended

040803 16:56:53 mysqld started
040803 16:56:53 InnoDB: Started
040803 16:56:53 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040803 16:56:53 Aborting

040803 16:56:54 InnoDB: Starting shutdown...
040803 16:56:56 InnoDB: Shutdown completed
040803 16:56:56 /usr/libexec/mysqld: Shutdown Complete

040803 16:56:56 mysqld ended

040803 17:01:23 mysqld started
040803 17:01:23 InnoDB: Started
040803 17:01:23 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040803 17:01:23 Aborting

040803 17:01:23 InnoDB: Starting shutdown...
040803 17:01:25 InnoDB: Shutdown completed
040803 17:01:25 /usr/libexec/mysqld: Shutdown Complete

040803 17:01:25 mysqld ended

040803 17:01:52 mysqld started
040803 17:01:53 InnoDB: Started
040803 17:01:53 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040803 17:01:53 Aborting

040803 17:01:53 InnoDB: Starting shutdown...
040803 17:01:55 InnoDB: Shutdown completed
040803 17:01:55 /usr/libexec/mysqld: Shutdown Complete

040803 17:01:55 mysqld ended

040803 17:04:02 mysqld started
040803 17:04:02 InnoDB: Started
040803 17:04:02 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040803 17:04:02 Aborting

040803 17:04:02 InnoDB: Starting shutdown...
040803 17:04:04 InnoDB: Shutdown completed
040803 17:04:04 /usr/libexec/mysqld: Shutdown Complete

040803 17:04:04 mysqld ended

040804 18:42:42 mysqld started
040804 18:42:43 InnoDB: Started
040804 18:42:43 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040804 18:42:43 Aborting

040804 18:42:43 InnoDB: Starting shutdown...
040804 18:42:45 InnoDB: Shutdown completed
040804 18:42:45 /usr/libexec/mysqld: Shutdown Complete

040804 18:42:45 mysqld ended

040804 20:14:09 mysqld started
040804 20:14:09 InnoDB: Started
040804 20:14:09 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040804 20:14:09 Aborting

040804 20:14:09 InnoDB: Starting shutdown...
040804 20:14:11 InnoDB: Shutdown completed
040804 20:14:11 /usr/libexec/mysqld: Shutdown Complete

040804 20:14:11 mysqld ended

040807 14:44:25 mysqld started
040807 14:44:26 InnoDB: Started
040807 14:44:26 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
040807 14:44:26 Aborting

040807 14:44:26 InnoDB: Starting shutdown...
040807 14:44:28 InnoDB: Shutdown completed
040807 14:44:28 /usr/libexec/mysqld: Shutdown Complete

040807 14:44:28 mysqld ended

Sym81
07-08-2004, 16:12
Sembra che non esista il db degli utenti. Prova a lanciare mysql_install_db. Controlla anche i permessi, la directory dei db (/var/lib/mysql) deve avere come owner l'utente mysql (chown -R mysql /var/lib/mysql).

SMASH
07-08-2004, 16:21
Funziona, grazie. :yuppi:

Loading