FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Redhat > Fedora User

 
 
LinkBack Thread Tools
 
Old 01-31-2008, 11:34 PM
Dave Stevens
 
Default mysqld won't start

Hi,

I have mysql installed in my F7 x86-64 system. When I try to use the System |
Administration | Server Settings and highlight mysqld and click on start I
get a delay and

"mysqld failed. The error was: Timeout error occurred trying to start MySQL
Daemon.
Starting MySQL: [FAILED]"

This is less informative than I would like it to be.

/var/log/mysqld.log ends with:

080131 16:19:46 mysqld ended

080131 16:25:55 mysqld started
080131 16:25: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...
080131 16:25: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 43655
080131 16:25:55 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
5
1 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
080131 16:25:56 InnoDB: Started; log sequence number 0 43655
080131 16:25:56 [ERROR] Fatal error: Can't open and lock privilege tables:
Table
'mysql.host' doesn't exist
080131 16:25:56 mysqld ended

I don't know what this means or what to do about it. I have searched for
mysql.host and it seems not to be present. Ideas?


Dave

--
There is no single government agency that views sustainability through a broad
lens, taking into account the values of the people affected by government
decisions. Any model of sustainability that is driven solely by an economic
engine is deficient if it is incapable of taking into account social values.

Mr. Justice David Vickers, BC Supreme Court in Tsilhqot'in Nation v. British
Columbia,2007

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 02-01-2008, 12:15 AM
"Aldo Foot"
 
Default mysqld won't start

On Jan 31, 2008 4:34 PM, Dave Stevens <geek@uniserve.com> wrote:
> Hi,
>
> I have mysql installed in my F7 x86-64 system. When I try to use the System |
> Administration | Server Settings and highlight mysqld and click on start I
> get a delay and
>
> "mysqld failed. The error was: Timeout error occurred trying to start MySQL
> Daemon.
> Starting MySQL: [FAILED]"
>
> This is less informative than I would like it to be.
>
> /var/log/mysqld.log ends with:
>
> 080131 16:19:46 mysqld ended
>
> 080131 16:25:55 mysqld started
> 080131 16:25: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...
> 080131 16:25: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 43655
> 080131 16:25:55 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
> 5
> 1 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
> 080131 16:25:56 InnoDB: Started; log sequence number 0 43655
> 080131 16:25:56 [ERROR] Fatal error: Can't open and lock privilege tables:
> Table
> 'mysql.host' doesn't exist
> 080131 16:25:56 mysqld ended
>
> I don't know what this means or what to do about it. I have searched for
> mysql.host and it seems not to be present. Ideas?
>
>
> Dave
>
> --
> There is no single government agency that views sustainability through a broad
> lens, taking into account the values of the people affected by government
> decisions. Any model of sustainability that is driven solely by an economic
> engine is deficient if it is incapable of taking into account social values.
>
> Mr. Justice David Vickers, BC Supreme Court in Tsilhqot'in Nation v. British
> Columbia,2007
>
> --
> fedora-list mailing list
> fedora-list@redhat.com
> To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
>

See if this will save you some time and effort:
Try removing the server and then reinstall it.
yum remove mysql-server
yum install mysql-server

~af

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 02-01-2008, 12:31 AM
Dave Stevens
 
Default mysqld won't start

On Thursday 31 January 2008 05:15:58 pm Aldo Foot wrote:
> On Jan 31, 2008 4:34 PM, Dave Stevens <geek@uniserve.com> wrote:
> > Hi,
> >
> > I have mysql installed in my F7 x86-64 system. When I try to use the
> > System | Administration | Server Settings and highlight mysqld and click
> > on start I get a delay and
> >
> > "mysqld failed. The error was: Timeout error occurred trying to start
> > MySQL Daemon.
> > Starting MySQL: [FAILED]"
> >
> > This is less informative than I would like it to be.

snip!

> See if this will save you some time and effort:
> Try removing the server and then reinstall it.
> yum remove mysql-server
> yum install mysql-server
>
> ~af

Thanks, a good idea but no go:


[root@localhost log]# tail mysqld.log
080131 17:28:44 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
080131 17:28:44 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
080131 17:28:45 InnoDB: Started; log sequence number 0 43655
080131 17:28:45 [ERROR] Fatal error: Can't open and lock privilege tables:
Table 'mysql.host' doesn't exist
080131 17:28:45 mysqld ended

other ideas?

Dave





--
There is no single government agency that views sustainability through a broad
lens, taking into account the values of the people affected by government
decisions. Any model of sustainability that is driven solely by an economic
engine is deficient if it is incapable of taking into account social values.

Mr. Justice David Vickers, BC Supreme Court in Tsilhqot'in Nation v. British
Columbia,2007

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 02-01-2008, 12:41 AM
"Chris Mohler"
 
Default mysqld won't start

On Jan 31, 2008 7:31 PM, Dave Stevens <geek@uniserve.com> wrote:
>
> other ideas?

Same idea?

yum erase mysql-server
yum install mysql-server
service mysqld start

Some of that log seems to indicate a corrupt 'mysql' DB - not sure on
that. I think the relevant DB is in /var/lib/mysql - a "rpm -ql
mysql-server" will let you know for sure...

Chris

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 02-01-2008, 12:43 AM
"Aldo Foot"
 
Default mysqld won't start

On Jan 31, 2008 5:31 PM, Dave Stevens <geek@uniserve.com> wrote:
> On Thursday 31 January 2008 05:15:58 pm Aldo Foot wrote:
> > On Jan 31, 2008 4:34 PM, Dave Stevens <geek@uniserve.com> wrote:
> > > Hi,
> > >
> > > I have mysql installed in my F7 x86-64 system. When I try to use the
> > > System | Administration | Server Settings and highlight mysqld and click
> > > on start I get a delay and
> > >
> > > "mysqld failed. The error was: Timeout error occurred trying to start
> > > MySQL Daemon.
> > > Starting MySQL: [FAILED]"
> > >
> > > This is less informative than I would like it to be.
>
> snip!
>
> > See if this will save you some time and effort:
> > Try removing the server and then reinstall it.
> > yum remove mysql-server
> > yum install mysql-server
> >
> > ~af
>
> Thanks, a good idea but no go:
>
>
> [root@localhost log]# tail mysqld.log
> 080131 17:28:44 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
> 080131 17:28:44 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
> 080131 17:28:45 InnoDB: Started; log sequence number 0 43655
> 080131 17:28:45 [ERROR] Fatal error: Can't open and lock privilege tables:
> Table 'mysql.host' doesn't exist
> 080131 17:28:45 mysqld ended
>
> other ideas?
>
>
> Dave


try uninstalling the mysql-server again, but this time
remove /var/lib/mysql and /etc/my.cnf. Backup them
up first in case you have something in there you need to keep.

then reinstall again.and do "service mysqld start"

~af

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 02-01-2008, 05:16 AM
Saurabh Bathe
 
Default mysqld won't start

Dave Stevens wrote:

Hi,

I have mysql installed in my F7 x86-64 system. When I try to use the System |
Administration | Server Settings and highlight mysqld and click on start I
get a delay and


<snip>

080131 16:25:56 InnoDB: Started; log sequence number 0 43655
080131 16:25:56 [ERROR] Fatal error: Can't open and lock privilege tables:
Table

'mysql.host' doesn't exist


This means that mysql cannot find privilege information.
Might be caused due to corrupt mysql databases or worst case, someone
deleted/dropped the database "mysql" (the directory /var/lib/mysql/mysql).


One way would be to backup the current mysql databse, if it exists (use
mysqldump). Then run the script /usr/bin/mysql_install_db. This will
create a default privilege table.


One more thing that can be done is to try and run myisamcheck on all the
files in /var/lib/mysql/mysql/*MYD files and see what it says. If there
is no tables_priv.MYD then depending on how customized this server was,
you could be in serious trouble. You will have to try the above
procedure and then grant the necessary privileges that are not currently
in the table.



--Saurabh

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 02-01-2008, 08:38 PM
Dave Stevens
 
Default mysqld won't start

On Thursday 31 January 2008 05:43:07 pm Aldo Foot wrote:
> On Jan 31, 2008 5:31 PM, Dave Stevens <geek@uniserve.com> wrote:
> > On Thursday 31 January 2008 05:15:58 pm Aldo Foot wrote:
> > > On Jan 31, 2008 4:34 PM, Dave Stevens <geek@uniserve.com> wrote:
> > > > Hi,
> > > >
> > > > I have mysql installed in my F7 x86-64 system. When I try to use the
> > > > System | Administration | Server Settings and highlight mysqld and
> > > > click on start I get a delay and
> > > >

snip!

>
> try uninstalling the mysql-server again, but this time
> remove /var/lib/mysql and /etc/my.cnf. Backup them
> up first in case you have something in there you need to keep.
>
> then reinstall again.and do "service mysqld start"
>
> ~af

yes, that worked. Thanks all. This was a new install not a production system
so there was no data at risk. a learning opportunity.

Dave




--
There is no single government agency that views sustainability through a broad
lens, taking into account the values of the people affected by government
decisions. Any model of sustainability that is driven solely by an economic
engine is deficient if it is incapable of taking into account social values.

Mr. Justice David Vickers, BC Supreme Court in Tsilhqot'in Nation v. British
Columbia,2007

--
fedora-list mailing list
fedora-list@redhat.com
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
 
Old 06-19-2010, 10:51 AM
Nilesh Govindarajan
 
Default Mysqld won't start

I compiled mysqld from ABS with some flag modification. But it doesn't
start and I see this in the error log:
00619 12:44:23 mysqld_safe Starting mysqld daemon with databases from
/var/lib/mysql

/usr/sbin/mysqld: Table 'plugin' is read only
100619 12:44:23 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
100619 12:44:23 [ERROR] /usr/sbin/mysqld: Can't create/write to file
'/var/lib/mysql/s1.mrova.com.pid' (Errcode: 13)
100619 12:44:23 [ERROR] Can't start server: can't create PID file:
Permission denied
100619 12:44:23 mysqld_safe mysqld from pid file
/var/lib/mysql/s1.mrova.com.pid ended


It complains about this pid file or the socket. For now I have
configured no socket in my.cnf, so I get the pid-file error.
Also I tried chmod 777 -Rf on /var/lib/mysql and /var/run/mysqld, but
still its the same.


--
Regards,
Nilesh Govindarajan
Facebook: http://www.facebook.com/nilesh.gr
Twitter: http://twitter.com/nileshgr
Website: http://www.itech7.com
Cheap and Reliable VPS Hosting: http://j.mp/arHk5e
 

Thread Tools




All times are GMT. The time now is 10:11 PM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright 2007 - 2008, www.linux-archive.org