Arch Linux

karmapolice

Member

Registered: 2007-01-31

Posts: 113

mysql won't start

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)

harlekin

Member

From: Germany

Registered: 2006-07-13

Posts: 408

Re: mysql won't start

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!

rico1986

Member

From: Slovenia

Registered: 2007-05-13

Posts: 34

Website

Re: mysql won't start

did you start mysql with /etc/rc.d/mysqld start ?

did you install default db? mysql_install_db ?

regards, Tim

---

regards, Tim

karmapolice

Member

Registered: 2007-01-31

Posts: 113

Re: mysql won't start

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.

KRTac

Member

From: Croatia

Registered: 2008-07-01

Posts: 99

Re: mysql won't start

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)