下载mysqltar包
wget -q http://mirrors.sohu.com/mysql/MySQL-5.6/mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
tar xf mysql-5.6.35-linux-glibc2.5-x86_64.tar.gz
mkdir -p /application
mv mysql-5.6.35-linux-glibc2.5-x86_64 /application/mysql-5.6.35
useradd -s /sbin/nologin -M mysql
chown -R mysql.mysql /application/mysql-5.6.35/
cd /application/mysql-5.6.35/
装依赖
yum -y install perl-Data-Dumper
一定要装这个不让后面将会报错。我就是卡在这个依赖上卡了好久
初始化数据库
cp support-files/my-default.cnf /etc/my.cnf ./scripts/mysql_install_db --basedir=/application/mysql-5.6.35/ --datadir=/application/mysql-5.6.35/data/ --user=mysql cp support-files/mysql.server /etc/init.d/mysqld sed -i 's#/usr/local/mysql#/application/mysql-5.6.35#g' /application/mysql-5.6.35/bin/mysqld_safe /etc/init.d/mysqld
启动登录
/etc/init.d/mysqld start yum install -y lsof lsof -i :3306 PATH="/application/mysql-5.6.35/bin/:$PATH"
登录测试
[root@test mysql-5.6.35]# mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 2 Server version: 5.6.35 MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. mysql> select version(); +-----------+ | version() | +-----------+ | 5.6.35 | +-----------+ 1 row in set (0.00 sec) mysql> create database chengzi; Query OK, 1 row affected (0.00 sec) mysql> create database chengzi1; Query OK, 1 row affected (0.00 sec) mysql> show databases like 'cheng%'; +-----------------+ | Database (cheng%) | +-----------------+ |chengzi | |chengzi1 | +-----------------+ 2 rows in set (0.00 sec)
配置ROOT密码等等权限信息
mysql_secure_installation
执行根据需要选择yes或者no