安装环境:
CentOS版本:CentOS7.6.1810
MySQL版本:5.7.9
软件目录:/soft
cp /soft/mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz /usr/local/
解压mysql到/usr/local目录
解压:
tar -zxvf mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz
在/usr/local目录,重命名:
mv mysql-5.7.9-linux-glibc2.5-x86_64/ mysql-5.7.9
安装需要的依赖
yum install -y libaio
具体安装:
shell> groupadd mysql
shell> useradd -r -g mysql mysql
shell> cd /usr/local
shell> ln -s /usr/local/mysql-5.7.9 mysql
shell> cd mysql
shell> mkdir mysql-files
shell> chmod 770 mysql-files
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> bin/mysqld --initialize --user=mysql # MySQL 5.7.6 and up
shell> bin/mysql_ssl_rsa_setup # MySQL 5.7.6 and up
shell> chown -R root .
shell> chown -R mysql data mysql-files
shell> bin/mysqld_safe --user=mysql &
#此处官网文档有坑,需要创建data目录
shell> mkdir data
shell>cd /etc
shell>mv my.cnf my.cnf.bak
#重新从上面的行:bin/mysqld --initialize --user=mysql 开始执行,并记录密码
Next command is optional
shell> cp support-files/mysql.server /etc/init.d/mysql.server
配置环境变量:
vi /etc/profile
最后面添加变量:
export PATH=/usr/local/mysql/bin:$PATH
配置开启启动
chkconfig mysql.server on
chkconfig --list
连接MySQL(用刚才记录的密码):
shell>mysql -uroot -p ‘sdjik)g=D26m’
登陆,修改密码
set password = ‘root1234%’;
允许远程登陆
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘root1234%’ WITH GRANT OPTION;
flush privileges;
启动的时候可能会报错
这是因为mysql启动的时候需要配置文件,而在安装centos的时候,哪怕是mini版本都会有个默认的配置在/etc目录中
/usr/local/mysql/bin/mysqld --verbose --help |grep -A 1 ‘Default options’
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf
Mysql启动的时候会以上面所述的顺序加载配置文件
如果报错,先重命名my.cnf文件