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/[EMAIL PROTECTED]

Reply via email to