MySQL Forums
Forum List  »  Install & Repo

Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
Posted by: Martin Quinn
Date: October 25, 2005 12:34AM

I have installed mysql 4.1.15 thru pkgadd on solaris 10, all goes fine until i try to start up using the install_mysql_db script --user=mysql and then the safe_mysqld --user=mysql

I get the error:
# more Felicia.err
051025 14:45:34 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
051025 14:45:35 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
051025 14:45:36 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...
051025 14:45:37 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
051025 14:45:39 InnoDB: Started; log sequence number 0 0
051025 14:45:39 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
051025 14:45:39 mysqld ended

and again this error when i use the mysqld --user=root
# bin/mysqld --user=root
051025 16:24:55 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...
051025 16:24:55 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 36808.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
051025 16:24:56 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 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
051025 16:24:56 InnoDB: Flushing modified pages from the buffer pool...
051025 16:24:56 InnoDB: Started; log sequence number 0 43634
051025 16:24:56 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

please what do I need to do now to get the mysql server running??

Options: ReplyQuote


Subject
Written By
Posted
Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
October 25, 2005 12:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.