Results 1 to 5 of 5

Thread: can not start mysql server

  1. #1
    Just burned his ISO
    Join Date
    Nov 2007
    Posts
    9

    Default can not start mysql server

    Code:
    bt Desktop # mysqld_safe --user=mysql &
    [2] 20416
    bt Desktop # nohup: ignoring input and redirecting stderr to stdout
    Starting mysqld daemon with databases from /var/lib/mysql
    STOPPING server from pid file /var/lib/mysql/bt.pid
    080107 13:54:57  mysqld ended
    bt Desktop # cat /var/lib/mysql/bt.err


    Code:
    080107 13:54:57  mysqld started
    nohup: ignoring input
    080107 13:54:57  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...
    080107 13:54:57  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
    080107 13:54:57  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
    080107 13:54:57  InnoDB: Started; log sequence number 0 43655
    080107 13:54:57 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
    080107 13:54:57  mysqld ended
    080107 13:54:57 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
    tell me how to fix this bug ,please

  2. #2
    Just burned his ISO
    Join Date
    Nov 2007
    Posts
    9

    Default

    sorry,i fixed it,thx everyone

  3. #3
    Jenkem Addict imported_wyze's Avatar
    Join Date
    Jul 2007
    Posts
    1,543

    Default

    Quote Originally Posted by kieuanh View Post
    sorry,i fixed it,thx everyone
    You should post your solutions so that others can see.
    dd if=/dev/swc666 of=/dev/wyze

  4. #4
    Just burned his ISO
    Join Date
    Sep 2008
    Posts
    2

    Default

    Quote Originally Posted by kieuanh View Post
    Code:
    bt Desktop # mysqld_safe --user=mysql &
    [2] 20416
    bt Desktop # nohup: ignoring input and redirecting stderr to stdout
    Starting mysqld daemon with databases from /var/lib/mysql
    STOPPING server from pid file /var/lib/mysql/bt.pid
    080107 13:54:57  mysqld ended
    Hi,

    Solution: chown /var/lib/mysql directory. For me it worked.

    bt# chown -R mysql:mysql /var/lib/mysql

  5. #5
    Just burned his ISO
    Join Date
    Sep 2008
    Posts
    2

    Default can not start mysql server

    Hi,

    Solution : chown /var/lib/mysql directory. For me it worked.

    bt# chown -R mysql:mysql /var/lib/mysql

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •