Menu
▾
▴
Re: [webmin-l] New to MySQL
|
From: <da...@so...> - 2006-02-23 15:08:11
|
Hi Jamie, Actually MySQL isn't running, it shuts down even on system reboot. Below are the last two error log entries. The second is after I deleted the databases as in a new start. This is a new install so MySQL hasn't run yet. ****************************************************************************** 060223 08:36:00 mysqld started 060223 8:36:01 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... 060223 8:36:01 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 060223 8:36:02 InnoDB: Flushing modified pages from the buffer pool... 060223 8:36:02 InnoDB: Started; log sequence number 0 43634 060223 8:36:02 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 060223 08:36:02 mysqld ended 060223 08:59:38 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 060223 8:59:39 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 060223 8:59:39 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... 060223 8:59:39 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 060223 8:59:40 InnoDB: Started; log sequence number 0 0 060223 8:59:40 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 060223 08:59:40 mysqld ended ************************************************************************************************ To: web...@li... Subject: Re: [webmin-l] New to MySQL From: "Jamie Cameron" <jca...@we...> Send reply to: web...@li... <mailto:web...@li...?subject=unsubscribe> <mailto:web...@li...?subject=subscribe> Date sent: Thu, 23 Feb 2006 15:47:00 1100 [ Double-click this line for list subscription options ] Hi Dan, You should check if MySQL actually gets started or not.. The problem may be that it really is running, but Webmin doesn't detect it properly. If it is running, you should see a process called 'mysqld'. - Jamie -----Original Message----- From: da...@so... Subj: Re: [webmin-l] New to MySQL Date: Thu 23 Feb 2006 9:22 am Size: 2K To: da...@so..., web...@li... I forgot to include this is a new install, webmin 1.260 on Slackware 10.2 with MySQL 4.1.14 From: da...@so... To: web...@li... Priority: normal Subject: [webmin-l] New to MySQL Send reply to: web...@li... <mailto:web...@li...?subject=unsubscribe> <mailto:web...@li...?subject=subscribe> Date sent: Wed, 22 Feb 2006 16:48:40 -0600 Hi, Probably something simple. I can't seem to get MySQL server to run. When I click the start server button it grinds for a short bit then comes back to the start server. I feel like a chicken or egg problem here as the start button refers "Click this button to start the MySQL database server on your system with the command cd /usr ; (/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &. This Webmin module cannot administer the database until it is started. " ************************************************** The host error log reads: 060222 16:33:18 mysqld started 060222 16:33:18 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... 060222 16:33:18 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 060222 16:33:18 InnoDB: Flushing modified pages from the buffer pool... 060222 16:33:18 InnoDB: Started; log sequence number 0 43634 060222 16:33:18 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 060222 16:33:18 mysqld ended ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 - Forwarded by the Webmin mailing list at web...@li... To remove yourself from this list, go to http://lists.sourceforge.net/lists/listinfo/webadmin-list --- message truncated --- ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd- Forwarded by the Webmin mailing list at web...@li... To remove yourself from this list, go to http://lists.sourceforge.net/lists/listinfo/webadmin-list |
