Centos7 安装 Mysql5.7 步骤 (一)、使用yum源方式安装1、卸载系统自带 mariadb2、下载并安装MySQL官方的 Yum2.1 下载mysql的yum源配置2.2 安装mysql的yum源2.3 使用yum方
之前一直是在window上安装mysql,但是实际应用mysql都是安装在服务器上,所以记录一下
本文记录了两种方式来安装mysql
一、使用yum源方式安装
二、使用本地tar文件方式安装
MariaDB Server 是最流行的开源关系型数据库之一。它由 MySQL 的原始开发者制作,并保证保持开源。
在 CentOS 7 中默认安装有 MariaDB
可忽略,安装完成之后可以直接覆盖掉MariaDB。
[root@localhost /]# rpm -qa|grep mariadbmariadb-libs-5.5.68-1.el7.x86_64[root@localhost /]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64[root@localhost /]# rpm -qa|grep mariadb
由于CentOS 的yum源中没有mysql,需要到mysql的官网下载yum repo配置文件
[root@localhost ~]# wget http://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm--2023-02-25 06:24:11-- https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm正在解析主机 repo.mysql.com (repo.mysql.com)... 23.212.157.5......100%[=========================================================================>] 25,680 --.-K/s 用时 0s 2023-02-25 06:24:19 (180 MB/s) - 已保存 “mysql57-commUnity-release-el7-11.noarch.rpm” [25680/25680])[root@localhost ~]# lsanaconda-ks.cfg mysql57-community-release-el7-11.noarch.rpm 模板 图片 下载 桌面initial-setup-ks.cfg 公共 视频 文档 音乐
命令执行完成后会在 /etc/yum.repos.d/ 目录下生成两个repo文件
mysql-community.repo
mysql-community-source.repo
[root@localhost ~]# yum -y install mysql57-community-release-el7-11.noarch.rpm已加载插件:fastestmirror, langpacks正在检查 mysql57-community-release-el7-11.noarch.rpm: mysql57-community-release-el7-11.noarchmysql57-community-release-el7-11.noarch.rpm 将被安装......已安装: mysql57-community-release.noarch 0:el7-11 完毕![root@localhost ~]# ls /etc/yum.repos.d/CentOS-Base.repo CentOS-fasttrack.repo CentOS-Vault.repo mysql-community-source.repoCentOS-CR.repo CentOS-Media.repo CentOS-x86_64-kernel.repoCentOS-Debuginfo.repo CentOS-Sources.repo mysql-community.repo
[root@localhost ~]# yum -y install mysql-server
如果没有提示错误可忽略
警告:/var/cache/yum/x86_64/7/mysql57-community/packages/mysql-community-common-5.7.41-1.el7.x86_64.rpm: 头V4 RSA/SHA256 Signature, 密钥 ID 3a79bd29: NOKEYmysql-community-common-5.7.41-1.el7.x86_64.rpm 的公钥尚未安装mysql-community-libs-compat-5.7.41-1.el7.x86_64.rpm 的公钥尚未安装 失败的软件包是:mysql-community-libs-compat-5.7.41-1.el7.x86_64 GPG 密钥配置为:file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
运行命令[root@localhost ~]# rpm --import Https://repo.mysql.com/RPM-GPG-KEY-mysql-2022重新安装[root@localhost ~]# yum -y install mysql-server
[root@localhost ~]# systemctl start mysqld.service[root@localhost ~]# systemctl status mysqld.service
在第一次登录时需要,登录后可修改密码
[root@localhost ~]# cat /var/log/mysqld.log | grep passWord2023-02-25T12:00:58.723624Z 1 [Note] A temporary password is generated for root@localhost: 1!L#qo3?d6i=
密码为刚才获取的临时密码,即
1!L#qo3?d6i=
[root@localhost ~]# mysql -u root -pEnter password:
如果密码设置太简单,会提示错误:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Wxq3012@';Query OK, 0 rows affected (0.00 sec)
在mysql命令行中输入
命令中的用%代表所有IP,如有需要,可换成指定IP
mysql> grant all privileges on *.* to 'root'@'%' identified by 'Wxq3012@' with grant option;Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)
[root@localhost ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanentsuccess重启配置[root@localhost ~]# firewall-cmd --reloadsuccess
完结,撒花
可以通过XFTP软件将安装包上传到服务器
[root@localhost /]# cd /[root@localhost /]# mkdir tools[root@localhost /]# mkdir az
[root@localhost /]# ls /tools/mysql-5.7.41-linux-glibc2.12-x86_64.tar
MariaDB Server 是最流行的开源关系型数据库之一。它由 MySQL 的原始开发者制作,并保证保持开源。
在 CentOS 7 中默认安装有 MariaDB
[root@localhost /]# rpm -qa|grep mariadbmariadb-libs-5.5.68-1.el7.x86_64[root@localhost /]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64[root@localhost /]# rpm -qa|grep mariadb
[root@localhost /]# rpm -qa | grep mysql
[root@localhost /]# whereis mysql [root@localhost /]# find / -name mysql
检查有无 MySQL 用户组,没有则创建
[root@localhost /]# cat /etc/group | grep mysql[root@localhost /]# cat /etc/passwd | grep mysql
[root@localhost /]# groupadd mysql[root@localhost /]# useradd -r -g mysql mysql
[root@localhost /]# mysql-5.7.41-linux-glibc2.12-x86_64.tar.gz
[root@localhost az]# mv mysql-5.7.41-linux-glibc2.12-x86_64/ mysql5.7[root@localhost az]# lsmysql5.7
[root@localhost az]# chown -R mysql:mysql /az/mysql5.7/[root@localhost az]# chmod -R 755 /az/mysql5.7/
[root@localhost bin]# ./mysqld --initialize --user=mysql --datadir=/az/mysql5.7/data --basedir=/az/mysql5.72023-02-23T22:43:52.131986Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).......2023-02-23T22:43:52.554378Z 1 [Note] A temporary password is generated for root@localhost: Pyq#VB8mieDS
[root@localhost bin]# vim /etc/my.cnf[mysqld]datadir=/az/mysql5.7/dataport = 3306sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLESsymbolic-links=0max_connections=400innodb_file_per_table=1表名存储在磁盘是小写的,但是比较的时候是不区分大小写lower_case_table_names=1
[root@localhost bin]# chmod -R 755 /etc/my.cnf
因为没有安装下/usr/local/mysq目录下,所以需要修改成安装的/az/mysql5.7目录。
[root@localhost bin]# vim /az/mysql5.7/support-files/mysql.server
[root@localhost ~]# ps -ef | grep mysqlroot 2031 1778 0 06:27 pts/0 00:00:00 tar -x mysql-5.7.41-linux-glibc2.12-x86_64.tarroot 2396 1778 0 06:55 pts/0 00:00:00 grep --color=auto mysql[root@localhost ~]# ps -ef | grep mysqldroot 2398 1778 0 06:55 pts/0 00:00:00 grep --color=auto mysqld
[root@localhost ~]# /az/mysql5.7/support-files/mysql.server startStarting MySQL.Logging to '/az/mysql5.7/data/localhost.localdomain.err'. SUCCESS!
[root@localhost ~]# ln -s /az/mysql5.7/support-files/mysql.server /etc/init.d/mysql[root@localhost ~]# ln -s /az/mysql5.7/bin/mysql /usr/bin/mysql[root@localhost ~]# service mysql restartShutting down MySQL.. SUCCESS! Starting MySQL. SUCCESS! [root@localhost ~]#
密码就是初始化时生成的临时密码
[root@localhost ~]# mysql -u root -pEnter password:
mysql> set password for root@localhost = password('root');Query OK, 0 rows affected, 1 warning (0.00 sec)mysql>
mysql> use mysql;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> update user set user.Host='%' where user.User='root';Query OK, 1 row affected (0.00 sec)Rows matched: 1 Changed: 1 Warnings: 0mysql> flush privileges;Query OK, 0 rows affected (0.00 sec)
将服务文件拷贝到init.d下,并重命名为mysql[root@localhost ~]# cp /az/mysql5.7/support-files/mysql.server /etc/init.d/mysqld赋予可执行权限[root@localhost ~]# chmod +x /etc/init.d/mysqld添加服务[root@localhost ~]# chkconfig --add mysqld显示服务列表[root@localhost ~]# chkconfig --list
开放3306端口命令[root@localhost ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanentsuccess重启防火墙[root@localhost ~]# firewall-cmd --reloadsuccess
完结,撒花
来源地址:https://blog.csdn.net/polaris3012/article/details/129216638
--结束END--
本文标题: Centos7 安装 MySQL5.7 步骤
本文链接: https://www.lsjlt.com/news/371523.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0