You are not logged in.
Pages: 1
I don't know what's wrong and I don't know why mysql isn't running, everytime I tried to start it all I get is:
:: Starting MySQL [FAIL]
Is there a way to see more information about why it is not running?
THX
EDIT:
I find this in /var/lib/mysql in a .err file
070513 13:42:16 mysqld started
070513 13:42:16 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...
070513 13:42:16 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
070513 13:42:16 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 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
070513 13:42:17 InnoDB: Started; log sequence number 0 43655
070513 13:42:17 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
070513 13:42:17 mysqld ended
Last edited by karmapolice (2007-05-13 18:44:10)
Offline
Can you say this are the errors that cause mysqld not to start or are these just errors you found (but which could not be related)?
Did you run mysqld successfully until a crash or something?
Try to start mysqld manually. This will do some output:
# mysqld_safe
Nice nick, btw. <:
Last edited by harlekin (2007-05-13 19:34:21)
Hail to the thief!
Offline
did you start mysql with /etc/rc.d/mysqld start ?
did you install default db? mysql_install_db ?
regards, Tim
regards, Tim
Offline
I fixed it.
1. I uninstalled it completely.
2. Reinstalled it and still it wouldn't start
3. Removed /var/lib/mysql
4. Restarted my laptop and it was working.
Offline
hi....old topic, but I had the same problem, and I too deleted the /var/lib/mysql dir, restarted my computer and then ran '/etc/rc.d/mysqld start' and it worked. Should i make a wiki entry about this?
EDIT: I would do the wiki update myself but I don't know exactly what went wrong, so if someone could do that with more detail, that would be great. If not, I'll edit the wiki entry myself as best a I can.
Just trying to contribute...
Last edited by KRTac (2008-07-07 20:50:19)
Offline
Pages: 1