Linux centos7 安装MySQL8

宁宁可可

已于 2023-04-04 10:35:57 修改

阅读量608

点赞数

分类专栏：环境部署数据库(MysqloracleMongo等) # MySQL数据库文章标签： linux mysql 服务器

于 2020-03-22 15:44:00 首次发布

本文链接：https://blog.csdn.net/fen_fen/article/details/105029090

版权

数据库(MysqloracleMongo等) 同时被 3 个专栏收录

73 篇文章 3 订阅

订阅专栏

MySQL数据库

26 篇文章 1 订阅

订阅专栏

环境部署

22 篇文章 0 订阅

订阅专栏

最近重新安装了下操作系统和虚拟机，需要在Linux centos安装mysql，记录下安装过程。

Linux centos7安装MySQL8

第一步下载安装包

直接下载或者在线下载

1.1直接下载

Mysql官网：MySQL :: Download MySQL Yum Repository

选择Red Hat Enterprise Linux 7 / Oracle Linux 7，点击Download下载

mysql80-community-release-el7-3.noarch.rpm

1.2在线下载rpm包

wget http://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

---------------------------------------------------------------

[root@linuxprobe devTools]# wget http://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

--2020-03-20 12:14:53-- http://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

Resolving repo.mysql.com (repo.mysql.com)... 72.246.33.49

Connecting to repo.mysql.com (repo.mysql.com)|72.246.33.49|:80... connected.

HTTP request sent, awaiting response... 302 Found

Location: http://103.238.48.8/repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm [following]

--2020-03-20 12:14:53-- http://103.238.48.8/repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

Connecting to 103.238.48.8:80... connected.

HTTP request sent, awaiting response... 200 OK

Length: 26024 (25K) [application/x-redhat-package-manager]

Saving to: ‘mysql80-community-release-el7-3.noarch.rpm’

100%[========================================================================================================================>] 26,024 --.-K/s in 0.1s

2020-03-20 12:14:54 (259 KB/s) - ‘mysql80-community-release-el7-3.noarch.rpm’ saved [26024/26024]

---------------------------------------------------------------

第二步：安装rpm包

sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm

-----------------------------------------

[root@linuxprobe devTools]# sudo rpm -Uvh mysql80-community-release-el7-3.noarch.rpm

warning: mysql80-community-release-el7-3.noarch.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... ################################# [100%]

Updating / installing...

1:mysql80-community-release-el7-3 ################################# [100%]

------------------------------------------

第三步： yum安装mysql

yum install mysql-community-server -y

------------------------

[root@linuxprobe devTools]# yum install -y mysql-community-server

base | 3.6 kB 00:00:00

extras | 2.9 kB 00:00:00

mysql-connectors-community | 2.5 kB 00:00:00

mysql-tools-community | 2.5 kB 00:00:00

mysql80-community | 2.5 kB 00:00:00

updates | 2.9 kB 00:00:00

Resolving Dependencies

-------------------------------

Installed:

mysql-community-libs.x86_64 0:8.0.19-1.el7 mysql-community-libs-compat.x86_64 0:8.0.19-1.el7

mysql-community-server.x86_64 0:8.0.19-1.el7

Dependency Installed:

mysql-community-client.x86_64 0:8.0.19-1.el7 mysql-community-common.x86_64 0:8.0.19-1.el7

Dependency Updated:

postfix.x86_64 2:2.10.1-7.el7

Replaced:

mariadb-libs.x86_64 1:5.5.56-2.el7

Complete!

第四步：查看mysql安装后的文件

[root@linuxprobe devTools]# rpm -qa | grep mysql

mysql80-community-release-el7-3.noarch

mysql-community-libs-compat-8.0.19-1.el7.x86_64

mysql-community-client-8.0.19-1.el7.x86_64

mysql-community-common-8.0.19-1.el7.x86_64

mysql-community-server-8.0.19-1.el7.x86_64

mysql-community-libs-8.0.19-1.el7.x86_64

第五步：启动mysql：

[root@linuxprobe devTools]# service mysqld start

Redirecting to /bin/systemctl start mysqld.service

查看mysql状态

[root@linuxprobe devTools]# 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 Fri 2020-03-20 22:09:20 CST; 2min 0s ago

Docs: man:mysqld(8)

http://dev.mysql.com/doc/refman/en/using-systemd.html

Process: 7435 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Main PID: 7524 (mysqld)

Status: "Server is operational"

Tasks: 38

CGroup: /system.slice/mysqld.service

└─7524 /usr/sbin/mysqld

Mar 20 22:08:55 linuxprobe.com systemd[1]: Starting MySQL Server...

Mar 20 22:09:20 linuxprobe.com systemd[1]: Started MySQL Server.

找初始密码：

[root@linuxprobe devTools]# grep 'temporary password' /var/log/mysqld.log

2020-03-20T14:09:15.495095Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: sGk(EQ0Chgbg

登陆并修改密码：

[root@linuxprobe devTools]# mysql -uroot -p sGk(EQ0Chgbg

bash: syntax error near unexpected token `('

---->linux5.0之后，是不能带有括号的，这个时候就需要转译.

#mysql -uroot -psGk\(EQ0Chgbg

或者#mysql -uroot -p"sGk(EQ0Chgbg"

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 15

Server version: 8.0.19

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> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Hu12345@';

Query OK, 0 rows affected (0.04 sec)

备注：密码规则：8位以上，大小写字母、数字和特殊字母。

创建数据库例子：

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

+--------------------+

4 rows in set (0.03 sec)

mysql> create database mysqltest;

Query OK, 1 row affected (0.01 sec)

mysql> use mysqltest;

Database changed

mysql> show tables ;

Empty set (0.00 sec)

重启mysql使用新密码登陆

#service mysqld restart

[root@linuxprobe devTools]# service mysqld restart

Redirecting to /bin/systemctl restart mysqld.service

其他操作：

1.如已经安装过，需要卸载，并且删除卸载残留

查找mysql

#rpm -qa | grep mysql

#find / -name mysql

[root@linuxprobe devTools]# find / -name mysql

find: ‘/run/user/1000/gvfs’: Permission denied

/etc/selinux/targeted/active/modules/100/mysql

/usr/share/mysql

看到还有的，需要用rm -rf删除掉，配置文件/etc/my.cnf也需要删除。

2.遇到问题：

问题1：使用yum install -y mysql-community-server命令时，提示Loaded plugins: fastestmirror, langpacks

[root@linuxprobe /]# yum install -y mysql-community-server

Loaded plugins: fastestmirror, langpacks

解决方法：

[root@linuxprobe /]# vim /etc/yum/pluginconf.d/fastestmirror.conf

--->enabled = 0//由1改为0，禁用该插件

[root@linuxprobe /]# vim /etc/yum.conf

--->plugins= 0//改为0，不使用插件

编辑保存操作：键盘输入i，修改后，键盘点击esc，:wq保存退出；:q退出。

问题2：Linux centos7安装MySQL8.0出现[Errno 256] No more mirrors to try

Error downloading packages:

mysql-community-server-8.0.19-1.el7.x86_64: [Errno 256] No more mirrors to try.

解决办法如下：

1.yum clean all #清除仓库缓存

2.yum makecache #将服务器包信息缓存到本地

mysql-connectors-community/x86_64/other_db | 14 kB 00:00:00

Metadata Cache Created

然后再执行yum install mysql-community-server -y

3.其他mysql命令

1.需要重装mysql时，删除mysql数据库

#yum安装的mysql,需要删除，使用命令:
#yum -y remove mysql*
# 需要将/var/lib/mysql文件夹下的所有文件都删除干净
# 然后在重新执行上面的安装步骤

2.其他查看安装包命令

2.1.查看有没有安装包:
  yum list mysql*
  #移除已经安装的mysql
  yum remove mysql mysql-server
rm -rf /var/lib/mysql
  rm -rf /etc/my.cnf
2.2. 查看是否还有mysql软件:
  rpm -qa|grep mysql
  #如果有的话,继续删除
2.3.安装mysql
yum install mysql-server