CentOS7版本安装Mysql8.0.20版本数据库的详细教程相关阅读：
CentOS7安装Mysql8.0.20步骤：
官⽹下载有时速度⽐较慢，直接点击链接也可以下载：
官⽹下载8.0.20Mysql包（bundle版本）
1.创建mysql⽂件夹：
[root@localhost ~]# mkdir /usr/local/mysql
[root@localhost ~]# cd /usr/local/mysql/
将下载的mysql包放在创建的MySQL⽂件夹内：
[root@localhost mysql]# ll
总⽤量 815000
-rw-r--r--. 1 root root 834560000 5⽉ 13 10:44 mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar
mysql的安装版MD5码查看是否和官⽹上的相对应：
[root@localhost mysql]# md5sum mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar
c8d062c1f74d9aab7dbdd5300b202b6e mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar
将mysql的包解压得到⼏个内安装包：
[root@localhost mysql]# tar -xvf mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar
mysql-community-libs-8.0.20-1.el7.x86_64.rpm
mysql-community-embedded-compat-8.0.20-1.el7.x86_64.rpm
mysql-community-test-8.0.20-1.el7.x86_64.rpm
mysql-community-common-8.0.20-1.el7.x86_64.rpm
mysql-community-devel-8.0.20-1.el7.x86_64.rpm
mysql-community-client-8.0.20-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.20-1.el7.x86_64.rpm
mysql-community-server-8.0.20-1.el7.x86_64.rpm
[root@localhost mysql]# ll
总⽤量 1630004
-rw-r--r--. 1 root root 834560000 5⽉ 13 10:44 mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar
-rw-r--r--. 1 7155 31415 48822048 3⽉ 27 20:14 mysql-community-client-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 623508 3⽉ 27 20:14 mysql-community-common-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 8129988 3⽉ 27 20:14 mysql-community-devel-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 23599996 3⽉ 27 20:14 mysql-community-embedded-compat-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 4667884 3⽉ 27 20:14 mysql-community-libs-8.0.20-1.el7.x86_64.rpm
-
rw-r--r--. 1 7155 31415 1277128 3⽉ 27 20:14 mysql-community-libs-compat-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 512057468 3⽉ 27 20:15 mysql-community-server-8.0.20-1.el7.x86_64.rpm
-rw-r--r--. 1 7155 31415 235369940 3⽉ 27 20:16 mysql-community-test-8.0.20-1.el7.x86_64.rpm
依次安装顺序时common，libs，libs-compat，client，server：
警告：mysql-community-common-8.0.20-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID ********: NOKEY
准备中... >>>>>>### [100%]
正在升级/安装...
1:mysql-community-common-8.0.20-1.e>>>>>>### [100%]
警告：mysql-community-libs-8.0.20-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID ********: NOKEY
准备中... >>>>>>### [100%]
正在升级/安装...
1:mysql-community-libs-8.0.20-1.el7>>>>>>### [100%]
警告：mysql-community-libs-compat-8.0.20-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID ********: NOKEY
准备中... >>>>>>### [100%]
正在升级/安装...
1:mysql-community-libs-compat-8.0.2>>>>>>### [100%]
警告：mysql-community-client-8.0.20-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID ********: NOKEY
准备中... >>>>>>### [100%]
正在升级/安装...
1:mysql-community-client-8.0.20-1.e>>>>>>### [100%]
警告：mysql-community-server-8.0.20-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID ********: NOKEY
准备中... >>>>>>### [100%]
正在升级/安装...
1:mysql-community-server-8.0.20-1.e>>>>>>### [100%]
编辑⼀下/etc/myf⽂件：
在最下⾯增加⼀⾏：
lower_case_table_names=1
initialize初始化：
[root@localhost mysql]# mysqld --initialize
[root@localhost mysql]#
更改⼀下权限：
[root@localhost mysql]# chown -R mysql:mysql /var/lib/mysql
[root@localhost mysql]# ll /var/lib/
总⽤量 8
drwxr-xr-x. 4 root root 32 5⽉ 13 10:07 AccountsService
drwxr-xr-x. 2 root root 6 8⽉ 3 2017 alsa
drwxr-xr-x. 2 root root 274 5⽉ 13 10:14 alternatives
drwx------. 3 root root 18 5⽉ 13 10:17 authconfig
drwxr-xr-x. 2 root root 6 8⽉ 3 2017 bluetooth
drwxr-xr-x. 2 chrony chrony 6 8⽉ 4 2017 chrony
drwxr-xr-x. 3 root root 17 5⽉ 13 10:06 color
drwxr-xr-x. 4 colord colord 67 5⽉ 13 10:23 colord
drwxr-xr-x. 2 root root 6 11⽉ 7 2016 dbus
drwxr-xr-x. 2 root root 6 8⽉ 4 2017 dhclient
drwxr-xr-x. 2 root root 6 8⽉ 3 2017 dnsmasq
drwxr-xr-x. 3 root root 34 5⽉ 13 10:24 flatpak
drwxr-xr-x. 2 root root 6 6⽉ 24 2014 fprint
drwxr-xr-x. 2 root root 6 11⽉ 5 2016 games
drwxrwx--T. 5 gdm gdm 70 5⽉ 13 10:23 gdm
drwxr-xr-x. 2 geoclue geoclue 6 8⽉ 2 2017 geoclue
drwxr-xr-x. 4 root root 55 5⽉ 13 02:22 gssproxy
drwxr-xr-x. 2 root root 6 8⽉ 2 2017 hyperv
drwxr-xr-x. 2 root root 6 8⽉ 5 2017 initramfs
drwxr-xr-x. 8 root root 90 5⽉ 13 10:07 iscsi
drwxr-xr-x. 8 root root 93 5⽉ 13 10:08 libvirt
drwxr-xr-x. 2 root root 6 11⽉ 6 2016 lldpad
drwxr-xr-x. 2 root root 6 8⽉ 2 2017 logrotate
drwx------. 2 root root 6 5⽉ 13 10:06 machines
drwxr-xr-x. 2 root root 37 5⽉ 13 02:22 misc
drwxr-x---. 2 root slocate 6 11⽉ 5 2016 mlocate
drwxr-x--x. 6 mysql mysql 4096 5⽉ 13 11:05 mysql
启动mysql服务看⼀下服务状态，看Active这⼀⾏的状态：
[root@localhost mysql]# systemctl start mysqld.service
[root@localhost mysql]# systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since 三 2020-05-13 11:09:35 CST; 8s ago
Docs: man:mysqld(8)
sql/doc/refman/en/using-systemd.html
Process: 16795 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS) Main PID: 16829 (mysqld)
Status: "Server is operational"
CGroup: /system.slice/mysqld.service
└─16829 /usr/sbin/mysqld
5⽉ 13 11:09:24 localhost.localdomain systemd[1]: Starting
5⽉ 13 11:09:35 localhost.localdomain systemd[1]: Started MySQL Server.
[root@localhost mysql]#
查看数据库初始的密码：
[root@localhost mysql]# cat /var/log/mysqld.log | grep password
2020-05-13T03:05:16.041238Z 6 [Note] [MY-010454]
[Server] A temporary password is generated for root@localhost: n_t#tk.Z?7)f
使⽤初始密码登陆数据库：后更改密码：
[root@localhost mysql]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.20
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
mysql下载starting the serveraffiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql> ALTER user 'root'@'localhost' identified with mysql_native_password by '123456';
Query OK, 0 rows affected (0.04 sec)
mysql> exit
Bye
[root@localhost mysql]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.20 MySQL Community Server - GPL
Copyright (c) 2000, 2020, 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> SELECT VERSION;
ERROR 1054 (42S22): Unknown column 'VERSION' in 'field list'
mysql> SELECT VERSION();
+-----------+
| VERSION() |
+-----------+
| 8.0.20 |
+-----------+
1 row in set (0.00 sec)
mysql>
到此可以正常登陆数据库了，可以⾃⾏查开启远程⽅式。
总结
到此这篇关于CentOS7版本安装Mysql8.0.20版本数据库的详细教程的⽂章就介绍到这了，更多相关CentOS7安装Mysql8.0数据库内容请搜索以前的⽂章或继续浏览下⾯的相关⽂章希望⼤家以后多多⽀持！
版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。
关于MySQL8.0数据库表名大小写的问题
« 上一篇
Centos7下Mysql5.7详细安装步骤
下一篇 »
推荐文章
热门文章
-
m函数数字提取
2025-01-07 -
jest断言方法大全
2025-01-07 -
中兴ZXSEC US 管理员手册
2025-01-07 -
keras系列(一):参数设置
2025-01-07 -
Qt从QString中提取出数字
2025-01-07 -
element input 金额千分位格式化
2025-01-07 -
freemaker 参数解析正则
2025-01-07 -
C#正则验证数字
2025-01-07 -
form表单验证正则
2025-01-07 -
scanf正则表达式用法
2025-01-07 -
grafana value的正则表达式
2025-01-07 -
Android平台浮点数运算应用
2025-01-07 -
js-(JS正则表达式验证数字)
2025-01-07 -
判断Python输入是否是整数,字符,或浮点数
2025-01-07 -
c语言 sscanf 正则规则
2025-01-07 -
从文本中提取数值技巧
2025-01-07 -
js将整数转换成两位浮点数的方法
2025-01-07 -
vue正则限制浮点数
2025-01-07 -
8到20的结尾的正则
2025-01-07 -
shell 正则表达式 最后一行
2025-01-07
最新文章
-
应用程序的安全检测方法、装置、电子设备和存储介质
2025-01-07 -
VBA之正则表达式(1)--基础篇
2025-01-07 -
代码编辑的辅助方法、装置及电子设备
2025-01-07 -
SHELL查字符串中包含字符的命令
2025-01-07 -
String方法中replace和replaceAll的区别详解(源码分析)
2025-01-07 -
双字节符号正则
2025-01-07
发表评论