Visualizzazione dei risultati da 1 a 8 su 8

Discussione: Mysql non va

  1. #1
    Utente di HTML.it L'avatar di SMASH
    Registrato dal
    Jun 2001
    Messaggi
    952

    Mysql non va

    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
    .::Un consiglio può essere buono, ma tu ragiona da solo::.

  2. #2
    Utente di HTML.it L'avatar di SMASH
    Registrato dal
    Jun 2001
    Messaggi
    952
    nessuno mi sa aiutare?
    .::Un consiglio può essere buono, ma tu ragiona da solo::.

  3. #3
    è xchè tenti di avviarlo coi permessi errati, prova con mysqld_safe --user=mysql &


  4. #4
    Utente di HTML.it L'avatar di SMASH
    Registrato dal
    Jun 2001
    Messaggi
    952
    Mi dà lo stesso errore...
    .::Un consiglio può essere buono, ma tu ragiona da solo::.

  5. #5
    Utente di HTML.it L'avatar di Sym81
    Registrato dal
    Jan 2002
    Messaggi
    114
    Quello potrebbe essere un motivo, in ogni caso sotto /var/lib/mysql *dovresti* avere un file .err con i log degli errori. Ciao
    "Dream on
    Do you believe...all the things that you are seeing are true?
    The Start's where the End's leading you
    Do you believe...all's as twisted as one would perceive?
    Seek the Answer and soon you'll believe"

  6. #6
    Utente di HTML.it L'avatar di SMASH
    Registrato dal
    Jun 2001
    Messaggi
    952
    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
    .::Un consiglio può essere buono, ma tu ragiona da solo::.

  7. #7
    Utente di HTML.it L'avatar di Sym81
    Registrato dal
    Jan 2002
    Messaggi
    114
    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).
    "Dream on
    Do you believe...all the things that you are seeing are true?
    The Start's where the End's leading you
    Do you believe...all's as twisted as one would perceive?
    Seek the Answer and soon you'll believe"

  8. #8
    Utente di HTML.it L'avatar di SMASH
    Registrato dal
    Jun 2001
    Messaggi
    952
    Funziona, grazie.
    .::Un consiglio può essere buono, ma tu ragiona da solo::.

Permessi di invio

  • Non puoi inserire discussioni
  • Non puoi inserire repliche
  • Non puoi inserire allegati
  • Non puoi modificare i tuoi messaggi
  •  
Powered by vBulletin® Version 4.2.1
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.