MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Rob Lacey Date:February 13 2006 4:59pm
Subject:Re: Problems Starting MySQL
View as plain text  
Anyone have any ideas on this one?

Many thanks.

RobL

On Friday 10 February 2006 15:07, Rob Lacey wrote:
> Running as root.
>
> RobL
>
> On Friday 10 February 2006 14:55, sheeri kritzer wrote:
> > Are you running the startup script as root, or is it setuid?
> >
> > -Sheeri
> >
> > On 2/10/06, Rob Lacey <mysql@stripped> wrote:
> > > Wondering if anyone can shed some light on a problem I am experiencing.
> > >
> > > I am running MySQL 4.1 on a Red Hat Enterprise Linux ES release 4
> > > (Nahant Update 2) machine.
> > >
> > > I have been trying to get the default /etc/init.d/mysqld script to
> > > restart the server but I keep running into the same problems. The MySQL
> > > server itself is running at the moment and has a number of live
> > > databases on it.
> > >
> > > 060209 18:40:43  mysqld started
> > > 060209 18:40:43 [Warning] Can't create test
> > > file /var/lib/mysql/thirdeye.lower-test
> > > /usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/' (Errcode:
> > > 13) 060209 18:40:43 [ERROR] Aborting
> > >
> > > 060209 18:40:43 [Note] /usr/libexec/mysqld: Shutdown complete
> > >
> > > 060209 18:40:43  mysqld ended
> > >
> > > I can't see where the thirdeye.lower-test file creation is coming into
> > > this at all. Since as far as can see the startup script doesn't seem to
> > > call any script to create test databases. Is this part of mysqld_safe?
> > >
> > > I can also see that /var/lib/mysql is already owned by mysql.mysql with
> > > 755 permissions. Indeed the RedHat startup script makes this so.
> > > Therefore the permissions error seems extremely odd as they seem fine
> > > to me.
> > >
> > > I can start the server using the following directly on the command
> > > line, which is what the startup script ultimately runs anyway.
> > >
> > > /usr/bin/mysqld_safe  --defaults-file=/etc/my.cnf
> > > --pid-file= /var/run/mysqld/mysqld.pid > /dev/null 2>&1 &
> > >
> > > Can anyone give me something further to go on?
> > >
> > > Many thanks.
> > >
> > > Rob
> > >
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
Thread
Problems Starting MySQLRob Lacey10 Feb
  • Re: Problems Starting MySQLsheeri kritzer10 Feb
    • Re: Problems Starting MySQLRob Lacey10 Feb
      • Re: Problems Starting MySQLRob Lacey13 Feb