假设用户名umysql,需要把mysql安装到用户目录下 /home/umysql/mysql (~/mysql)
1. 安装Mysql基础依赖包:
yum install -y libaio numactl
2.下载Mysql软件包
在 MySQL 网站上找到需要的版本,以5.7为例
https://dev.mysql.com/downloads/mysql/
cd /home/umysql/mysql
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-server-5.7.22-1.el7.x86_64.rpm wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-common-5.7.22-1.el7.x86_64.rpm wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-libs-5.7.22-1.el7.x86_64.rpm
3.解压软件包
rpm2cpio mysql-community-server-5.7.22-1.el7.x86_64.rpm | cpio -idvm rpm2cpio mysql-community-common-5.7.22-1.el7.x86_64.rpm | cpio -idvm rpm2cpio mysql-community-libs-5.7.22-1.el7.x86_64.rpm | cpio -idvm
4.设置环境变量
echo \'export PATH=$PATH:/home/umysql/mysql/usr/bin/:/home/umysql/mysql/usr/sbin/\' >> /home/umysql/.bashrc
source /home/umysql/.bashrc
5.编辑my.cnf
vi /home/umysql/mysql/etc/my.cnf
[mysqld] symbolic-links=0 socket=/home/umysql/mysql/var/lib/mysql/mysql.sock basedir=/home/umysql/mysql/usr datadir=/home/umysql/mysql/var/lib/mysql/data secure-file-priv=/home/umysql/mysql/var/lib/mysql-files init-connect=\\'SET NAMES utf8\\' collation_server=utf8_unicode_ci character_set_server=utf8
6. 安装mysql
注意这个步骤生成的默认密码
mysqld --defaults-file=/home/umysql/mysql/etc/my.cnf --initialize --user=umysql
7.启动mysql
mysqld --defaults-file=/home/umysql/mysql/etc/my.cnf --user=umysql &
大功告成~ 可以用netstat检查一下mysql是否运行
netstat -nl | grep 3306