Hi!

noreply> Bug #115518, was updated on 2000-Sep-27 17:34 noreply> Here is a current snapshot of the bug.

noreply> Project: MySQL noreply> Category: None noreply> Status: Open noreply> Resolution: None noreply> Bug Group: None noreply> Priority: 5 noreply> Summary: MySQL hangs with the --user option

noreply> Details: By default /etc/rc.d/init.d/mysql is run as root and it runs a
command like noreply> this:

noreply> exec nice --5 nohup /usr/sbin/mysqld --basedir=/
--datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid
--skip-locking --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid

noreply> This DOES NOT work on my Redhat 6.2 system.

noreply> I removed each of the command line options, hoping it was one of them
that caused a problem.

noreply> --user=mysql is the problem.

noreply> BUT if I do this:

noreply> # su - mysql noreply> % nice --5 nohup /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
--pid-file=/var/lib/mysql/mysqld.pid --skip-locking --datadir=/var/lib/mysql
--pid-file=/var/lib/mysql/mysqld.pid

noreply> Things work.

noreply> When run with the --user option the command utility mysql just hangs.

I will test the 3.23.25 RPM with this at once.

In the mean time, could you please try to run the following as root and check if it hangs.

strace -o/tmp/mysqld.trace /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql
--user=mysql --pid-file=/var/lib/mysql/mysqld.pid --skip-locking
--datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid

If yes, please post the last 100 lines from the /tmp/mysqld.trace file to me so that I can figure out what's going on!

Regards, Monty