安装条件
#卸载系统默认自带数据库
[root@localhost ~]# rpm -qa |grep mariadb
mariadb-libs-5.5.64-1.el7.x86_64
[root@localhost ~]# rpm -ef mariadb-libs-5.5.64-1.el7.x86_64 --nodeps
[root@localhost ~]# rpm -qa |grep mariadb
MySQL部署
[root@localhost ~]# cd /opt/
[root@localhost opt]# wget https://mirrors.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
[root@localhost opt]# ls
mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
[root@localhost opt]# tar xf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
[root@localhost opt]# mv /usr/local/mysql-5.7.28-linux-glibc2.12-x86_64 /usr/local/mysql
[root@localhost opt]# echo 'export PATH=/usr/local/mysql/bin:$PATH' >> /etc/profile
[root@localhost opt]# source /etc/profile
创建MySQL用户
[root@localhost opt]# useradd -s /sbin/nologin mysql -M
初始化数据
[root@localhost opt]# mkdir /usr/local/mysql/data
#--initialize是开启临时密码、安全策略
[root@localhost opt]# mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
[root@localhost opt]# chown -R mysql.mysql /usr/local/mysql/
配置文件
[root@localhost opt]# vim /etc/my.cnf
[mysqld]
user=mysql
bind-address=0.0.0.0
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
server_id=1
[mysql]
socket=/tmp/mysql.sock
添加systemd管理启动
[root@localhost opt]# vim /etc/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
[root@localhost opt]# systemctl start mysqld.service
[root@localhost opt]# systemctl enable mysqld.service
设置root登录密码
[root@localhost ~]# mysqladmin password '000000'
[root@localhost ~]# mysql -uroot -p000000
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.7.28 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, 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>