Linux mysql安装

1.将安装包mysql-5.0.60sp1.tar.gz拷贝到/opt目录下。
2.安装：

# groupadd mysql
# useradd -g mysql mysql
# cd /opt
# tar –zxvf /opt/mysql-5.0.60sp1.tar.gz
# cd mysql-5.0.60sp1
# ./configure --prefix=/usr/local/mysql --with-extra-charsets=gb2312 --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static
# make
# make install
# cp support-files/my-medium.cnf /etc/my.cnf
# cd /usr/local/mysql
# chown -R mysql .
# chgrp -R mysql .
# /opt/mysql-5.0.60sp1/scripts/mysql_install_db --user=mysql
# chown -R root .
# chown -R mysql var
# bin/mysqld_safe --user=mysql &
# /usr/local/mysql/bin/mysqladmin -u root password '123456'

3.设置环境变量：

# cp /etc/profile.d/
# touch mysql.sh
# chmod 755 /etc/profile.d/mysql.sh

mysql.sh 内容如下:

PATH="/usr/local/mysql/bin:$PATH"
export PATH

# exit //然后重新登录
# which mysql
/usr/local/mysql/bin/mysql
# mysql --version
mysql Ver 14.12 Distrib 5.0.60sp1, for redhat-linux-gnu (i686) using  EditLine wrapper

4.配置MySql账户密码：

# mysql -u root -p'123456'
mysql> use mysql
Database changed
mysql> delete from user where password="";
mysql> update user set Host='%' where Host='localhost';
mysql> quit

5.配置MySql自动加载文件

# cd /usr/local/mysql
# cp /opt/mysql-5.0.60sp1/support-files/mysql.server /etc/init.d
# chmod +x /etc/init.d/mysql.server

6.重启mysql

# /etc/init.d/mysql.server restart