MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:sheeri kritzer Date:February 10 2006 2:55pm
Subject:Re: Problems Starting MySQL
View as plain text  
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