Installing MySQL

xilen2099

1.creat account
$ pw groupadd mysql
$ pw useradd mysql -c "MySQL Server" -d /dev/null -g mysql -s /sbin/nologin
2.Compiling MySQL
$ ./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 //进入mysql目录后执行
$ scripts/mysql_install_db
$ chown -R root /usr/local/mysql
$ chown -R mysql /usr/local/mysql/var
$ chgrp -R mysql /usr/local/mysql
3.Copy configuration file
$ cp support-files/my-medium.cnf /etc/my.cnf
$ chown root:sys /etc/my.cnf
$ chmod 644 /etc/my.cnf
4.Start the server
$ /usr/local/mysql/bin/mysqld_safe &
5.Test the connection
Try to establish a connection with the database as follows:
$ /usr/local/mysql/bin/mysql -u root mysql
mysql> show databases;
mysql> quit;
6.shutdown the database
/usr/local/mysql/bin/mysqladmin -u root shutdown


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u1/52955/showart_446300.html