教您如何安全的应用 MySQL

#groupadd mysql

#useradd mysql -c "start mysqld's account" -d /dev/null -g mysql -s /sbin/nologin

#wget http://mysql.he.net/Downloads/MySQL-4.0/mysql-4.0.16.tar.gz

#tar -zxvf mysql-4.0.16.tar.gz

#./configure  --prefix=/usr/local/mysql \ 

--with-mysqld-user=mysql \ 

--with-unix-socket-path=/tmp/mysql.sock \ 

--with-mysqld-ldflags=-all-static

#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

#/usr/local/mysq/bin/mysqld_safe --user=mysql &

#/usr/local/mysql/bin/mysql

[root@ftp bin]# mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 687 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

mysql> show databases;

+--------------+

| Database     |

+--------------+

| mysql       |

| test         |

+--------------+

2 rows in set (0.00 sec)

mysql>quit

#/usr/local/mysql/bin/mysqladmin -uroot shutdown

#more /usr/local/mysql/var/`hostname`.err

#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 -p /usr/local/mysql/libexec/mysqld /chroot/mysql/usr/local/mysql/libexec/

#cp -p /usr/local/mysql/