【IT168 服务器学院】安装数据库MYSQL

　　安装mysql40-server和mysql40-client
　　进入/usr/ports/databases/mysql40-server
　　执行：
　　make clean
　　make deinstall
　　make WITH_OPENSSL=yes WITH_LINUXTHREADS=yes BUILD_OPTIMIZED=yes install
　　或者使用下面可参考的编译参数：BUILD_STATIC=yes
　　编译成静态执行版本
　　make clean

　　更改mysql的root密码：

　　mysqladmin –uroot –p password 123456
　　生成/etc/my.cnf，使用如下命令：

　　vi /etc/my.cnf
　　[client]
　　#password = your_password
　　port = 3306
　　socket = /tmp/mysql.sock

　　[mysqld]
　　skip-innodb
　　skip-locking
　　skip-networking
　　set-variable = port=3306
　　set-variable = socket=/tmp/mysql.sock
　　set-variable = back_log=50
　　set-variable = connect_timeout=3
　　set-variable = key_buffer=128M
　　set-variable = max_connections=1000
　　set-variable = max_allowed_packet=1M
　　set-variable = net_buffer_length=8K
　　set-variable = wait_timeout=3
　　set-variable = read_buffer_size=1M
　　set-variable = sort_buffer_size=1M
　　set-variable = table_cache=256
　　set-variable = myisam_sort_buffer_size=32M
　　set-variable = log_slow_queries=/var/log/log_slow_queries.log
　　#log-bin
　　server-id = 1

　　[mysqldump]
　　quick
　　set-variable = max_allowed_packet=16M

　　[mysql]
　　no-auto-rehash
　　# Remove the next comment character if you are not familiar with SQL
　　#safe-updates

　　[isamchk]
　　set-variable = key_buffer=20M
　　set-variable = sort_buffer=20M
　　set-variable = read_buffer=2M
　　set-variable = write_buffer=2M

　　[myisamchk]
　　set-variable = key_buffer=20M
　　set-variable = sort_buffer=20M
　　set-variable = read_buffer=2M
　　set-variable = write_buffer=2M

　　[mysqlhotcopy]
　　interactive-timeout

　　安装phpmyadmin

　　注意，此步骤需要在apache和php之后再执行
　　进入/usr/ports/databases/phpmyadmin
　　执行：
　　make clean
　　make deinstall
　　make install
　　make clean
　　新建立一个system的数据库备用。