Guten Abend,
ich verstehe es einfach nicht
ich habe auf meinem root(gleiche bsd version und mysql version) folgendes Problem. Ich krieg mysql nicht gestartet.
Irgendwas mit host doesnt exist kommt da.
weiß da jemand weiter?
Code
- 181009 18:04:16 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
- 181009 18:04:16 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
- 181009 18:04:16 [Note] /usr/local/libexec/mysqld (mysqld 5.5.53) starting as process 1336 ...
- 181009 18:04:16 InnoDB: The InnoDB memory heap is disabled
- 181009 18:04:16 InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 181009 18:04:16 InnoDB: Compressed tables use zlib 1.2.8
- 181009 18:04:16 InnoDB: Initializing buffer pool, size = 128.0M
- 181009 18:04:16 InnoDB: Completed initialization of buffer pool
- InnoDB: The first specified data file ./ibdata1 did not exist:
- InnoDB: a new database to be created!
- 181009 18:04:16 InnoDB: Setting file ./ibdata1 size to 10 MB
- InnoDB: Database physically writes the file full: wait...
- 181009 18:04:16 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...
- 181009 18:04:16 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: 127 rollback segment(s) active.
- InnoDB: Creating foreign key constraint system tables
- InnoDB: Foreign key constraint system tables created
- 181009 18:04:16 InnoDB: Waiting for the background threads to start
- 181009 18:04:17 InnoDB: 5.5.53 started; log sequence number 0
- 181009 18:04:17 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
- 181009 18:04:17 [Note] - '0.0.0.0' resolves to '0.0.0.0';
- 181009 18:04:17 [Note] Server socket created on IP: '0.0.0.0'.
- 181009 18:04:17 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- 181009 18:04:17 mysqld_safe mysqld from pid file /var/db/mysql/localhost.pid ended
- 181009 19:43:24 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
- 181009 19:43:24 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
- 181009 19:43:24 [Note] /usr/local/libexec/mysqld (mysqld 5.5.53) starting as process 1645 ...
- 181009 19:43:24 InnoDB: The InnoDB memory heap is disabled
- 181009 19:43:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 181009 19:43:24 InnoDB: Compressed tables use zlib 1.2.8
- 181009 19:43:24 InnoDB: Initializing buffer pool, size = 128.0M
- 181009 19:43:24 InnoDB: Completed initialization of buffer pool
- 181009 19:43:24 InnoDB: highest supported file format is Barracuda.
- InnoDB: Log scan progressed past the checkpoint lsn 48941
- 181009 19:43:24 InnoDB: Database was not shut down normally!
- InnoDB: Starting crash recovery.
- InnoDB: Reading tablespace information from the .ibd files...
- InnoDB: Restoring possible half-written data pages from the doublewrite
- InnoDB: buffer...
- InnoDB: Doing recovery: scanned up to log sequence number 1595675
- 181009 19:43:24 InnoDB: Starting an apply batch of log records to the database...
- InnoDB: Progress in percents: 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
- InnoDB: Apply batch completed
- 181009 19:43:25 InnoDB: Waiting for the background threads to start
- 181009 19:43:26 InnoDB: 5.5.53 started; log sequence number 1595675
- 181009 19:43:26 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
- 181009 19:43:26 [Note] - '0.0.0.0' resolves to '0.0.0.0';
- 181009 19:43:26 [Note] Server socket created on IP: '0.0.0.0'.
- 181009 19:43:26 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
- 181009 19:43:26 mysqld_safe mysqld from pid file /var/db/mysql/localhost.pid ended