背景
服务器环境如下：
[root@ecs-c8ee-0008 ~]# cat /etc/os-release NAME="CentOS Linux" VERSION="7 (Core)" ID="centos" ID_LIKE="rhel fedora" VERSION_ID="7" PRETTY_NAME="CentOS Linux 7 (Core)" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:centos:centos:7" HOME_URL="https://www.centos.org/" BUG_REPORT_URL="https://bugs.centos.org/" CENTOS_MANTISBT_PROJECT="CentOS-7" CENTOS_MANTISBT_PROJECT_VERSION="7" REDHAT_SUPPORT_PRODUCT="centos" REDHAT_SUPPORT_PRODUCT_VERSION="7"
计划安装 MySQL5.7 ，直接执行命令： yum -y install mysql-community-server ，发现太慢了。。
安装加速
所谓的加速，就是让安装命令不要直接去 MySQL 官方去下载，那网络真是太慢啦；而是使用国内镜像将包下载下来再安装，会节省不少时间。
- 找到自己需要安装的版本，手动下载
- 下载好后，放到目录：
cd /var/cache/yum/x86_64/7/mysql57-community/packages/
- 再次执行安装服务命令：
yum -y install mysql-community-server
[root@ecs-c8ee-0008 ~]# cd /run/user/0/ [root@ecs-c8ee-0008 0]# yum -y install mysql-community-server 下载太慢。。 [root@ecs-c8ee-0008 0]# cd /var/cache/yum/x86_64/7/mysql57-community/packages/ [root@ecs-c8ee-0008 packages]# wget http://uni.mirrors.163.com/mysql/Downloads/MySQL-5.7/mysql-community-client-5.7.36-1.el7.x86_64.rpm [root@ecs-c8ee-0008 packages]# wget http://uni.mirrors.163.com/mysql/Downloads/MySQL-5.7/mysql-community-server-5.7.36-1.el7.x86_64.rpm [root@ecs-c8ee-0008 packages]# yum -y install mysql-community-server
启动服务
[root@ecs-c8ee-0008 packages]# service mysqld status Redirecting to /bin/systemctl status mysqld.service ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: inactive (dead) Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html [root@ecs-c8ee-0008 packages]# service mysqld start Redirecting to /bin/systemctl start mysqld.service [root@ecs-c8ee-0008 packages]# service mysqld status Redirecting to /bin/systemctl status mysqld.service ● mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since 三 2021-12-01 15:18:22 CST; 2s ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 7479 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS) Process: 7254 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) Main PID: 7483 (mysqld) Tasks: 27 Memory: 323.8M CGroup: /system.slice/mysqld.service └─7483 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid 12月 01 15:18:13 ecs-c8ee-0008 systemd[1]: Starting MySQL Server... 12月 01 15:18:22 ecs-c8ee-0008 systemd[1]: Started MySQL Server.
修改密码
# 先获取到初始化自动生成的密码 [root@ecs-c8ee-0008 packages]# grep "password" /var/log/mysqld.log # 输入初始密码，此时不能做任何事情，因为MYSQL默认必须修改密码才能正常使用 ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
Note: 设置密码时，可能遇到报错： Your password does not satisfy the current policy requirements 。
# 可通过修改MySQL的密码策略进行解决： SHOW VARIABLES LIKE 'validate_password%'; # 修改策略，及密码长度 set global validate_password_policy=0; set global validate_password_length=1;
创建开发者访问数据库的用户
# 实际开发过程中一般分为开发者用户，生产用户，DBA管理用户，运维用户等。 # 而对于开发者只需要具有增删改查的权限即可，如果有修改表字段等这些管理需求，使用管理账号操作 create user test identified by 'your-password'; grant select,insert,update,delete on `your-db-name`.* to test@'%' identified by 'your-password'; flush privileges;
开启远程访问
# 允许远程主机访问 GRANT ALL PRIVILEGES on *.* to test@'%' IDENTIFIED BY 'your-password'; flush privileges;
