1.下载
cd /opt
wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
tar xvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql
2.路径配置
basedir=/opt/mysql
datadir=/opt/mysql/data
2.新增mysql用户
groupadd mysql
useradd -r -g mysql mysql
cd /opt
mkdir /opt/mysql/data
chown -R mysql:mysql mysql
//mysql初始化
./bin/mysql_install_db --user=mysql --basedir=/opt/mysql/ --datadir=/opt/mysql/data/
-- 如遇错误--
/opt/mysql/bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
yum install libaio
3.配置文件修改
cp -a ./support-files/my-default.cnf /etc/my.cnf
cp -a ./support-files/mysql.server /etc/init.d/mysqld
//修改以上文件,修改以下内容
basedir=/opt/mysql
datadir=/opt/mysql/data
//非默认安装目录还需配置mysqld
mkdir -p /usr/local/mysql/bin
ln -s /opt/mysql/bin/mysqld /usr/local/mysql/bin/mysqld
4.mysql权限配置
cat /root/.mysql_secret
//启动mysql
/etc/init.d/mysqld start
//客户端登录
./mysql -uroot -p
SET PASSWORD = PASSWORD('root');
use mysql
update user set host = '%' where user = 'root';