Menu
▾
▴
Re: [webmin-l] New to MySQL
|
From: John H. <web...@ew...> - 2006-02-23 16:08:32
|
da...@so... wrote: > 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. You have deleted or not created the master 'mysql' database which contains all the connection information for any other existing databases. The line, 'mysql.host' would be the host table in the mysql database. This one contains info about what host are allowed to connect to mysql. So there's no method for mysql to connect to itself. This database holds host, user, db, and most of the time columns_priv, func, tables_priv. Each of these instruct mysql as to what databases exist and what who can do from where with them. The basic addressing and permission system. I don't think there are any direct methods within Webmin to create this database. I'm thinking you're going to need to go back through your installation of mysql and find out where/how this database gets created based on your particular installation method (packaged, compiled, etc.). Sounds like a mysql question instead of a Webmin question at this point as this would be a botched install of mysql or at least an incomplete install. Best, John Hinton > > ****************************************************************************** > 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 > !DSPAM:43fdd01a147262127750296! |
