安装mysql5.1.49
MySQL客户端、服务端下载地址:
MySQL :: Download MySQL Community Server (Archived Versions)
一、安装准备
1.卸载自带 Mariadb并删除配置文件(my.cnf)
rpm -qa|grep mariadb
rpm -e --nodeps mariadb
2.MySQL客户端安装
rpm -ivh MySQL-client-5.1.49-1.glibc23.x86_64.rpm --nodeps --force
二、正式安装
1.解压tar.gz包并复制到/usr/local文件夹
tar -zxvf mysql-5.1.49-linux-x86_64-glibc23.tar.gz
mv mysql-5.1.49-linux-x86_64-glibc23 /usr/local/mysql-5.1.49
2.创建MySQL用户与组
groupadd mysql
useradd -g mysql mysql
chown -R mysql:mysql /usr/local/mysql-5.1.49
3.编辑my.cnf配置文件
[mysql]
default-character-set=utf8
socket=/var/lib/mysql/mysql.sock
[mysqld]
skip-name-resolve
port = 3306
socket=/var/lib/mysql/mysql.sock
# mysql的安装目录
basedir=/usr/local/mysql-5.1.49
# mysql数据目录
datadir=/usr/local/mysql-5.1.49/data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
lower_case_table_name=1
max_allowed_packet=16M
4.安装
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql-5.1.49 --datadir=/usr/local/mysql-5.1.49/data
如果报错:error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory
可尝试先安装 yum install libnsl.x86_64
5.后续配置
chown -R mysql:mysql data
chown 777 /etc/my.cnf
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig --list mysqld
#配置PATH
vim ~/.bash_profile
#在文件最下方插入以下内容,保存
“export PATH=$PATH:/usr/local/mysql-5.1.49/bin”
#刷新
source ~/.bash_profile
三、开启服务
service mysqld start
mysql -uroot -p #无密码,直接登录
------------------------------
#修改root密码,开启远程访问
mysql> use mysql
mysql> update user set password=password('设置的密码') where user='root' and host='localhost';
mysql> flush privileges;
mysql> grant all privileges on *.* to 'root'@'%' identified by '设置的密码' with grant option;
mysql> flush privileges;