Centos7.5 mysql5.7.26二进制安装方式
1 yum安装所需相关依赖包。
yum -y install gcc-c++
yum -y install zlib zlib-devel pcre pcre-devel
yum -y install openssl-devel
yum -y install libaio-devel.x86_64
2搜索关键字:MySQL5.7 linux二进制安装
下载路径:
2.1#创建mysql的数据目录,该目录在初始化数据库的候会用到
mkdir -p /data/mysql/data
mkdir -p /data/mysql/log
2.2#移动mysql文件到/data/mysql/mysql
tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
cd /usr/local/
ln -s mysql-5.7.26-linux-glibc2.12-x86_64 mysql
2.3 #先创建mysql组
groupadd mysql
2.4#将MySQL用户加入mysql组
useradd -r -g mysql -s /bin/false mysql
2.5#修改目录权限
chown -R mysql:mysql /data/mysql/
chmod 750 /data/mysql
2.6#配置my.cnf
ls -l /etc/my.cnf ##查看是不是已经有my.cnf配置了,如果有可能是centos自带了Mysql数据库,我用的是7.5,自带mysql 的mariadb,下面我将把它卸载,避免受到干扰
rpm -e mariadb-libs --nodeps ##mariadb
vim /etc/my.cnf
[client]port = 3306socket = /data/mysql/mysql.sock[mysqld]server_id=10port = 3306user = mysqlcharacter-set-server = utf8mb4default_storage_engine = innodblog_timestamps = SYSTEMsocket = /data/mysql/mysql.sockbasedir =/usr/local/mysqldatadir = /data/mysql/datapid-file = /data/mysql/mysql.pidmax_connections = 1000max_connect_errors = 1000table_open_cache = 1024max_allowed_packet = 128Mopen_files_limit = 65535server-id=1gtid_mode=onenforce_gtid_consistency=onlog-slave-updates=1log-bin=master-binlog-bin-index = master-bin.indexrelay-log = relay-logrelay-log-index = relay-log.indexbinlog_format=rowlog_error = /data/mysql/log/mysql-error.logskip-name-resolvelog-slave-updates=1relay_log_purge = 0slow_query_log = 1long_query_time = 1slow_query_log_file = /data/mysql/log/mysql-slow.log
2.7#初始化数据库
/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --initialize --user=mysql --basedir=/data/mysql/mysql --datadir=/data/mysql/data --innodb_undo_tablespaces=3 --explicit_defaults_for_timestamp #初始化mysql
2.7#根据配置了my.cnf的error.log,查看初始密码
grep 'password' /data/mysql/log/mysql-error.log
2.8#创建ssl加密
/usr/local/mysql/bin/mysql_ssl_rsa_setup --datadir=/data/mysql/data
2.9#将里面的basedir和datadir改为和my.cnf一致
vi /usr/local/mysql/support-files/mysql.server
basedir=/usr/local/mysql
datadir=/data/mysql/data
2.10#拷贝和配置启动文件
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
2.11设置开机启动
chkconfig --add mysqld
chkconfig mysqld on
2.12配置环境变量
echo 'PATH=/usr/local/mysql/bin:$PATH'>>/etc/profile
tail -1 /etc/profile
source /etc/profile #让环境变量生效
echo $PATH #检查变量是否添加成功
2.13#启动mysql
service mysqld start
2.14#进入mysql
mysql -uroot -p #密码通过前面的2.2.7找到
2.15#修改初始密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
2.16#刷新权限
flush privileges;
2.17加入开机启动项
[root@Smile system]# vim /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 5000
chmod +x /usr/lib/systemd/system/mysqld.service ##给予执行权限
systemctl daemon-reload ###重新加载
systemctl enable mysqld.service
systemctl start mysqld.service