本文提供了一套详细的步骤，教你如何在Linux环境下快速安装MySQL5.7版本，包括安装必备命令、配置服务启动、设置远程登录及防火墙端口等关键环节。
你还为记不住安装mysql的命令烦恼吗
你还为安装mysql准备的资料去东拼西凑烦恼吗
你还为............
总之就是平时安装好麻烦啦
我分享内容如下， 如有雷同我也是借鉴过来的啦
- 命令安装
安装过程中需要使用到的命令，如果在你在后续安装步骤中被系统提示不存在命令，则来此查找对应的命令并先安装。
wget:
| [root@localhost mysql]# yum -y install wget |
yum-config-manager:
| [root@localhost mysql]# yum -y install yum-utils |
- 查找并删除系统自带的mariadb
| [root@localhost ~]# rpm -qa | grep mariadb mariadb-libs-5.5.64-1.el7.x86_64 [root@localhost ~]# rpm -e --nodeps mariadb-libs |
- 从mysql官方网站上下载yum源并安装
Mysql官网: https://www.mysql.com/
Download
进入社区版下载
选择Yum源的仓库
选择下载与系统版本一致的YUM源
不需要注册登录，直接下载
复制下载链接地址
进入linux创建目录并下载刚才复制的东东，并安装yum源
(注:mysql所有大版本的最新版都在这个源)
| [root@localhost ~]# mkdir ~/mysql [root@localhost mysql]# wget -P ~/mysql https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm [root@localhost mysql]# cd ~/mysql/ [root@localhost mysql]# rpm -Uvh mysql80-community-release-el7-3.noarch.rpm |
查看源中默认的安装版本。
| [root@localhost mysql]# yum repolist all | grep mysql mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community 禁用 mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - So 禁用 mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community 禁用 mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community - So 禁用 mysql-cluster-8.0-community/x86_64 MySQL Cluster 8.0 Community 禁用 mysql-cluster-8.0-community-source MySQL Cluster 8.0 Community - So 禁用 mysql-connectors-community/x86_64 MySQL Connectors Community 启用: 131 mysql-connectors-community-source MySQL Connectors Community - Sou 禁用 mysql-tools-community/x86_64 MySQL Tools Community 启用: 100 mysql-tools-community-source MySQL Tools Community - Source 禁用 mysql-tools-preview/x86_64 MySQL Tools Preview 禁用 mysql-tools-preview-source MySQL Tools Preview - Source 禁用 mysql55-community/x86_64 MySQL 5.5 Community Server 禁用 mysql55-community-source MySQL 5.5 Community Server - Sou 禁用 mysql56-community/x86_64 MySQL 5.6 Community Server 禁用 mysql56-community-source MySQL 5.6 Community Server - Sou 禁用 mysql57-community/x86_64 MySQL 5.7 Community Server 禁用 mysql57-community-source MySQL 5.7 Community Server - Sou 禁用 mysql80-community/x86_64 MySQL 8.0 Community Server 启用: 145 mysql80-community-source MySQL 8.0 Community Server - Sou 禁用 [root@localhost mysql]# |
启用mysql57版本，禁用默认的80版本
| [root@localhost mysql]# yum-config-manager --disable mysql80-community [root@localhost mysql]# yum-config-manager --enable mysql57-community |
检查确认一下
- 安装mysql5.7
| [root@localhost mysql]# yum install -y mysql-community-server |
上边这个过程耗时可能较长，耐心等待执行完成。
安装后配置
启动mysql服务
| [root@localhost mysql]# systemctl start mysqld |
将mysql服务设置为随开机启动
| [root@localhost mysql]# systemctl enable mysqld [root@localhost mysql]# systemctl daemon-reload |
在以下文件中找到root账号的初始密码
| [root@localhost mysql]# cat /var/log/mysqld.log | grep password 2019-12-04T02:37:17.305435Z 1 [Note] A temporary password is generated for root@localhost: B2:fKmqm!dcn |
使用此密码登录mysql,并修改密码
#注:mysql的用户密码要求必须同时有大小写字母、数字和特殊符号，至少8位。
| [root@localhost mysql]# mysql -u root -p Enter password:
mysql> alter user 'root'@'localhost' identified by 'TSmysql@20'; |
设置允许远程登录后退出
| mysql> grant all privileges on *.* to 'root'@'%' identified by 'TSmysql@20' with grant option; Query OK, 0 rows affected, 1 warning (0.01 sec)
mysql> exit Bye |
开放防火墙的3306端口
| [root@localhost mysql]# firewall-cmd --zone=public --add-port=3306/tcp --permanent success [root@localhost mysql]# firewall-cmd --reload success [root@localhost mysql]# |
配置mysql默认的编码为utf-8
| [root@localhost mysql]# vi /etc/my.cnf |
在[mysqld]节点下增加以下两项配置，:wq保存退出
| [mysqld] character_set_server=utf8 init_connect='SET NAMES utf8' |
重启mysql
| [root@localhost mysql]# systemctl restart mysqld |
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
