linux下安装mysql

1、下载源码包

去 http://dev.mysql.com/downloads/mysql/6.0.html 里下载到 mysql-6.0.6-alpha.tar.gz

2、创建mysql的用户组和用户

>groupadd mysql
>useradd -g mysql mysql

3、编译安装 mysql

>cp mysql-6.0.0-alpha.tar.gz /usr/local/src
>tar -zxvf mysql-6.0.0-alpha.tar.gz
>cd mysql-6.0.0-alpha
>./configure --prefix=/usr/local/mysql #指定安装目录
>make
>make install

在编译Mysql时
./configure prefix=/usr/local/mysql
如果出现了以下错误：
......
checking for tgetent in -ltermcap... no
checking for termcap functions library... configure: error: No curses/termcap library found

说明 curses/termcap 库没有安装
yum search curses | grep lib

安装 ncurses-devel ，然后重新运行配置
yum install ncurses-devel

4、配置并启动mysql

>cp support-files/my-medium.cnf /etc/my.cnf
>cd /usr/local/mysql
>chown -R mysql .
>chgrp -R mysql .
>bin/mysql_install_db --user=mysql #初始化安装mysql数据库
>chown -R root .
>chown -R mysql var
>bin/mysqld_safe --user=mysql &

5、更改mysql的root密码

>/usr/local/mysql/bin/mysqladmin -u root password [新密码]

6、设置mysql开机自启动

>cp support-files/mysql.server /etc/rc.d/init.d/mysql
>chmod +x /etc/rc.d/init.d/mycql
>chkconfig --add mysql
>service mysql start