安装MYSQL笔记

 

用了两天时间在FreeBSD下安装MYSQL,到最后才搞定,原来一开始就犯了个大错,把MYSQL的二进制包当成源代码包来编译了,怪不得老是出错,呵,得记住了。把安装过程简单记一下,免得日后又忘。

安装的MYSQL版本:mysql-4.0.21.tar.gz

下载地址: http://mysql.mirrored.ca/Downloads/MySQL-4.0/mysql-4.0.21.tar.gz

这里想给自己说明下,一般像mysql-4.0.21.tar.gz的文件名的是源代码包(安装时需要./configure和make和make install),而文件名是mysql-debug-4.0.22-unknown-freebsd4.7-i386.tar.gz 的一般为二进制安装包,安装方法有所不同!

以下为源代码包的安装方法:

ts# groupadd mysql

ts# useradd -g mysql mysql

ts# tar zxvf mysql4.0.21.tar.gz

ts# cd mysql4.0.21

ts# ./configure –prefix=/usr/local/mysql

ts# make /*编译这步大约需10分钟,请耐心等待:) */

ts# make install

ts# cp support-files/my-medium.cnf /etc/my.cnf /*询问你是否要覆盖时,输入"y" */

ts# cd /usr/local/mysql

ts# cd bin

ts# ./mysql_install_db –user=mysql /*这儿的user一定是mysql切记。*/

ts# chown -R root .

ts# chown -R mysql var

ts# chown -R mysql .

ts# bin/mysqld_safe –user=mysql & /*也要用mysql用户运行。*/

如果没任何反应,恭喜!成功了!

以下为二进制包的安装方法: (网上转的,别自己试验过!)

shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf –
shell> ln -s mysql-VERSION-OS mysql
shell> cd mysql
shell> scripts/mysql_install_db
shell> chown -R root /usr/local/mysql
shell> chown -R mysql /usr/local/mysql/data
shell> chgrp -R mysql /usr/local/mysql
shell> chown -R root /usr/local/mysql/bin
shell> bin/safe_mysqld –user=mysql &

Leave a Reply