groupadd mysql
useradd -g mysql mysql -d /dev/null -s /sbin/nologin
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql --with-unix-socket-path=/tmp/mysql.sock --with-mysqld-ldflags=-all-static --without-innodb 
make
make install
strip /usr/local/mysql/libexec/mysqld
scripts/mysql_install_db
chown -R root /usr/local/mysql
chown -R mysql /usr/local/mysql/var
chgrp -R mysql /usr/local/mysql
cp support-files/my-medium.cnf /etc/my.cnf
chown root:sys /etc/my.cnf
chmod 644 /etc/my.cnf

mkdir -p /chroot/mysql/dev
mkdir -p /chroot/mysql/etc
mkdir -p /chroot/mysql/tmp
mkdir -p /chroot/mysql/var/tmp
mkdir -p /chroot/mysql/usr/local/mysql/libexec
mkdir -p /chroot/mysql/usr/local/mysql/share/mysql/english
chown -R root:sys /chroot/mysql
chmod -R 755 /chroot/mysql
chmod 1777 /chroot/mysql/tmp
cp /usr/local/mysql/libexec/mysqld /chroot/mysql/usr/local/mysql/libexec/
cp /usr/local/mysql/share/mysql/english/errmsg.sys /chroot/mysql/usr/local/mysql/share/mysql/english/
cp /etc/hosts /chroot/mysql/etc/
cp /etc/host.conf /chroot/mysql/etc/
cp /etc/resolv.conf /chroot/mysql/etc/
grep mysql /etc/group > /chroot/mysql/etc/group
grep mysql /etc/passwd > /chroot/mysql/etc/passwd
mknod /chroot/mysql/dev/null c 2 2
chown root:sys /chroot/mysql/dev/null
chmod 666 /chroot/mysql/dev/null

cp -R /usr/local/mysql/var/ /chroot/mysql/usr/local/mysql/var
chown -R mysql:mysql /chroot/mysql/usr/local/mysql/var

chrootuid /chroot/mysql mysql /usr/local/mysql/libexec/mysqld &

mysql     2015  0.0  2.8  31420  3552 pts/0    Sl   09:32   0:00 /usr/local/mysql/libexec/mysqld
root      2023  0.0  0.5   4000   696 pts/0    R+   09:44   0:00 grep mysql

[root@dhcppc7 ~]# ldd /chroot/mysql/usr/local/mysql/libexec/mysqld
        not a dynamic executable

#!/bin/sh

CHROOT_MYSQL=/chroot/mysql
SOCKET=/tmp/mysql.sock
MYSQLD=/usr/local/mysql/libexec/mysqld
PIDFILE=/var/run/mysqld/`hostname`.pid
CHROOTUID=/usr/local/bin/chrootuid

echo -n " mysql"

case "$1" in
start)
        rm -rf ${CHROOT_PHP}/${SOCKET}
        nohup ${CHROOTUID} ${CHROOT_MYSQL} mysql ${MYSQLD} >/dev/null 2>&1 &
        sleep 5 && ln ${CHROOT_MYSQL}/${SOCKET} ${CHROOT_PHP}/${SOCKET} && ln ${CHROOT_MYSQL}/${SOCKET} ${SOCKET}
        ;;
stop)
        kill `cat ${CHROOT_MYSQL}/${PIDFILE}`
        rm -rf ${CHROOT_MYSQL}/${SOCKET}
        ;;
*)
        echo ""
        echo "Usage: `basename $0` {start|stop}" >&2
        exit 64
        ;;
esac

exit 0

/etc/init.d/mysql start
 mysqlln: creating hard link `/tmp/mysql.sock' to `/chroot/mysql//tmp/mysql.sock': File exists

ls -la /chroot/mysql/usr/local/mysql/libexec/mysqld
-rwxr-xr-x 1 root root 4019924 Sep 20 09:28 /chroot/mysql/usr/local/mysql/libexec/mysqld

file /chroot/mysql/usr/local/mysql/libexec/mysqld

/chroot/mysql/usr/local/mysql/libexec/mysqld: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.6.9, statically linked, for GNU/Linux 2.6.9, stripped

[root@dhcppc7 /]# chroot /chroot/mysql

bash-3.2# /usr/local/mysql/bin/mysqld_safe &

[1] 4714
bash-3.2# chown: `mysql': invalid user
Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/dhcppc7.pid
110921 09:57:19  mysqld ended

/hvaonline/posts/list/0/19738.html#119195

groupadd mysql
useradd -g mysql mysql 
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql --with-unix-socket-path=/tmp/mysql.sock --with-mysqld-ldflags=-all-static --without-innodb 
make
make install
strip /usr/local/mysql/libexec/mysqld
scripts/mysql_install_db
chown -R root /usr/local/mysql
chown -R mysql /usr/local/mysql/var
chgrp -R mysql /usr/local/mysql
cp support-files/my-medium.cnf /etc/my.cnf
chown root:sys /etc/my.cnf
chmod 644 /etc/my.cnf

mkdir -p /chroot/mysql/dev
mkdir -p /chroot/mysql/etc
mkdir -p /chroot/mysql/tmp
mkdir -p /chroot/mysql/var/tmp
chown -R root:sys /chroot/mysql
chmod -R 755 /chroot/mysql
chmod 1777 /chroot/mysql/tmp
cp /etc/hosts /chroot/mysql/etc/
cp /etc/host.conf /chroot/mysql/etc/
cp /etc/resolv.conf /chroot/mysql/etc/
grep mysql /etc/group > /chroot/mysql/etc/group
grep mysql /etc/passwd > /chroot/mysql/etc/passwd
mknod /chroot/mysql/dev/null c 2 2
chown root:sys /chroot/mysql/dev/null
chmod 666 /chroot/mysql/dev/null

mkdir -p /chroot/mysql/usr/local/mysql/
cp -R /usr/local/mysql/ /chroot/mysql/usr/local/mysql/
chown -R mysql:mysql /chroot/mysql/usr/local/mysql/

chrootuid /chroot/mysql mysql /usr/local/mysql/libexec/mysqld &

chroot /chroot/mysql

mkdir -p /chroot/mysql/bin
mkdir -p /chroot/mysql/lib
mkdir -p /chroot/mysql/usr/lib/

cp /lib/libdl.so.2 /lib/libtermcap.so.2 /lib/libc.so.6 /lib/ld-linux.so.2 \ 
/lib/librt.so.1 /lib/libssl.so.6 /lib/libcrypto.so.6 /lib/libpthread.so.0 \
/lib/libcrypt.so.1 /lib/libnsl.so.1/lib/libm.so.6 /lib/libgcc_s.so.1 \
/lib/libcom_err.so.2 /lib/libresolv.so.2 \
/lib/libkeyutils.so.1 /lib/libselinux.so.1 /lib/libsepol.so.1 /chroot/mysql/lib/

cp /usr/lib/libkrb5.so.3 /usr/lib/libz.so.1  /usr/lib/libstdc++.so.6 /usr/lib/libgssapi_krb5.so.2 \
/usr/lib/libk5crypto.so.3 /usr/lib/libkrb5support.so.0 /chroot/mysql/usr/lib/

chroot /chroot/mysql

/usr/local/mysql/bin/mysqld_safe &

/usr/local/mysql/bin/mysqld_safe: line 75: sed: command not found
/usr/local/mysql/bin/mysqld_safe: line 74: sed: command not found
/usr/local/mysql/bin/mysqld_safe: line 223: dirname: command not found
/usr/local/mysql/bin/mysqld_safe: line 255: /bin/hostname: No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 262: /bin/hostname: No such file or directory
/usr/local/mysql/bin/mysqld_safe: line 285: /dev/null: No such device or address
/usr/local/mysql/bin/mysqld_safe: line 316: /dev/null: No such device or address
/usr/local/mysql/bin/mysqld_safe: line 333: touch: command not found
/usr/local/mysql/bin/mysqld_safe: line 333: chown: command not found
Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/bin/mysqld_safe: line 394: date: command not found
/usr/local/mysql/bin/mysqld_safe: line 397: rm: command not found
STOPPING server from pid file /mysql/var/.pid
/usr/local/mysql/bin/mysqld_safe: line 442: date: command not found
/usr/local/mysql/bin/mysqld_safe: line 442: tee: command not found
/usr/local/mysql/bin/mysqld_safe: line 443: tee: command not found

chroot /chroot/mysql/ 
/usr/local/mysql/bin/mysqld_safe &

chown: `mysql': invalid user
Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/dhcppc7.pid
110922 02:24:39  mysqld ended

chown root:root /var
chown 'root': invalid user

[root@dhcppc7 ~]# chrootuid /chroot/mysql mysql /usr/local/mysql/libexec/mysqld &
[1] 1986
[root@dhcppc7 ~]# 110921 13:42:48 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.0.92-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

ps aux| grep mysql
mysql     1986  0.0  2.8  31420  3556 pts/0    Sl   09:42   0:00 /usr/local/mysql/libexec/mysqld
root      1994  0.0  0.5   4000   672 pts/0    R+   09:43   0:00 grep mysql

chrootuid /chroot/mysql mysql /usr/local/mysql/bin/mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.92-log Source distribution

No entry for terminal type "xterm";
using dumb terminal settings.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>