CentOS7版本安装Mysql8.0.20版本数据库的详细教程
相关阅读:
MySQL8.0.20安装教程及其安装问题详细教程 https://www.nhooo.com/article/186202.htm
mysql8.0.20下载安装及遇到的问题(图文详解) https://www.nhooo.com/article/186208.htm
CentOS7安装Mysql8.0.20步骤:
https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-20.html
官网下载有时速度比较慢,直接点击链接也可以下载:mysql8.0.20
官网下载8.0.20Mysql包(bundle版本)
1.创建mysql文件夹:
[root@localhost~]#mkdir/usr/local/mysql [root@localhost~]#cd/usr/local/mysql/
将下载的mysql包放在创建的MySQL文件夹内:
[root@localhostmysql]#ll 总用量815000 -rw-r--r--.1rootroot8345600005月1310:44mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar
mysql的安装版MD5码查看是否和官网上的相对应:
[root@localhostmysql]#md5summysql-8.0.20-1.el7.x86_64.rpm-bundle.tar c8d062c1f74d9aab7dbdd5300b202b6emysql-8.0.20-1.el7.x86_64.rpm-bundle.tar
将mysql的包解压得到几个内安装包:
[root@localhostmysql]#tar-xvfmysql-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@localhostmysql]#ll 总用量1630004 -rw-r--r--.1rootroot8345600005月1310:44mysql-8.0.20-1.el7.x86_64.rpm-bundle.tar -rw-r--r--.1715531415488220483月2720:14mysql-community-client-8.0.20-1.el7.x86_64.rpm -rw-r--r--.17155314156235083月2720:14mysql-community-common-8.0.20-1.el7.x86_64.rpm -rw-r--r--.171553141581299883月2720:14mysql-community-devel-8.0.20-1.el7.x86_64.rpm -rw-r--r--.1715531415235999963月2720:14mysql-community-embedded-compat-8.0.20-1.el7.x86_64.rpm -rw-r--r--.171553141546678843月2720:14mysql-community-libs-8.0.20-1.el7.x86_64.rpm -rw-r--r--.171553141512771283月2720:14mysql-community-libs-compat-8.0.20-1.el7.x86_64.rpm -rw-r--r--.17155314155120574683月2720:15mysql-community-server-8.0.20-1.el7.x86_64.rpm -rw-r--r--.17155314152353699403月2720:16mysql-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:头V3DSA/SHA1Signature,密钥ID********:NOKEY 准备中...#################################[100%] 正在升级/安装... 1:mysql-community-common-8.0.20-1.e#################################[100%] 警告:mysql-community-libs-8.0.20-1.el7.x86_64.rpm:头V3DSA/SHA1Signature,密钥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:头V3DSA/SHA1Signature,密钥ID********:NOKEY 准备中...#################################[100%] 正在升级/安装... 1:mysql-community-libs-compat-8.0.2#################################[100%] 警告:mysql-community-client-8.0.20-1.el7.x86_64.rpm:头V3DSA/SHA1Signature,密钥ID********:NOKEY 准备中...#################################[100%] 正在升级/安装... 1:mysql-community-client-8.0.20-1.e#################################[100%] 警告:mysql-community-server-8.0.20-1.el7.x86_64.rpm:头V3DSA/SHA1Signature,密钥ID********:NOKEY 准备中...#################################[100%] 正在升级/安装... 1:mysql-community-server-8.0.20-1.e#################################[100%]
编辑一下/etc/my.cnf文件:
在最下面增加一行:
lower_case_table_names=1
initialize初始化:
[root@localhostmysql]#mysqld--initialize [root@localhostmysql]#
更改一下权限:
[root@localhostmysql]#chown-Rmysql:mysql/var/lib/mysql [root@localhostmysql]#ll/var/lib/ 总用量8 drwxr-xr-x.4rootroot325月1310:07AccountsService drwxr-xr-x.2rootroot68月32017alsa drwxr-xr-x.2rootroot2745月1310:14alternatives drwx------.3rootroot185月1310:17authconfig drwxr-xr-x.2rootroot68月32017bluetooth drwxr-xr-x.2chronychrony68月42017chrony drwxr-xr-x.3rootroot175月1310:06color drwxr-xr-x.4colordcolord675月1310:23colord drwxr-xr-x.2rootroot611月72016dbus drwxr-xr-x.2rootroot68月42017dhclient drwxr-xr-x.2rootroot68月32017dnsmasq drwxr-xr-x.3rootroot345月1310:24flatpak drwxr-xr-x.2rootroot66月242014fprint drwxr-xr-x.2rootroot611月52016games drwxrwx--T.5gdmgdm705月1310:23gdm drwxr-xr-x.2geocluegeoclue68月22017geoclue drwxr-xr-x.4rootroot555月1302:22gssproxy drwxr-xr-x.2rootroot68月22017hyperv drwxr-xr-x.2rootroot68月52017initramfs drwxr-xr-x.8rootroot905月1310:07iscsi drwxr-xr-x.8rootroot935月1310:08libvirt drwxr-xr-x.2rootroot611月62016lldpad drwxr-xr-x.2rootroot68月22017logrotate drwx------.2rootroot65月1310:06machines drwxr-xr-x.2rootroot375月1302:22misc drwxr-x---.2rootslocate611月52016mlocate drwxr-x--x.6mysqlmysql40965月1311:05mysql
启动mysql服务看一下服务状态,看Active这一行的状态:
[root@localhostmysql]#systemctlstartmysqld.service [root@localhostmysql]#systemctlstatusmysqld.service ●mysqld.service-MySQLServer Loaded:loaded(/usr/lib/systemd/system/mysqld.service;enabled;vendorpreset:disabled) Active:active(running)since三2020-05-1311:09:35CST;8sago Docs:man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process:16795ExecStartPre=/usr/bin/mysqld_pre_systemd(code=exited,status=0/SUCCESS) MainPID:16829(mysqld) Status:"Serverisoperational" CGroup:/system.slice/mysqld.service └─16829/usr/sbin/mysqld 5月1311:09:24localhost.localdomainsystemd[1]:StartingMySQLServer... 5月1311:09:35localhost.localdomainsystemd[1]:StartedMySQLServer. [root@localhostmysql]#
查看数据库初始的密码:
[root@localhostmysql]#cat/var/log/mysqld.log|greppassword 2020-05-13T03:05:16.041238Z6[Note][MY-010454] [Server]Atemporarypasswordisgeneratedforroot@localhost:n_t#tk.Z?7)f
使用初始密码登陆数据库:后更改密码:
[root@localhostmysql]#mysql-uroot-p Enterpassword: WelcometotheMySQLmonitor.Commandsendwith;or\g. YourMySQLconnectionidis8 Serverversion:8.0.20 Copyright(c)2000,2020,Oracleand/oritsaffiliates.Allrightsreserved. OracleisaregisteredtrademarkofOracleCorporationand/orits affiliates.Othernamesmaybetrademarksoftheirrespective owners. Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement. mysql> mysql>ALTERuser'root'@'localhost'identifiedwithmysql_native_passwordby'123456'; QueryOK,0rowsaffected(0.04sec) mysql>exit Bye [root@localhostmysql]#mysql-uroot-p Enterpassword: WelcometotheMySQLmonitor.Commandsendwith;or\g. YourMySQLconnectionidis9 Serverversion:8.0.20MySQLCommunityServer-GPL Copyright(c)2000,2020,Oracleand/oritsaffiliates.Allrightsreserved. OracleisaregisteredtrademarkofOracleCorporationand/orits affiliates.Othernamesmaybetrademarksoftheirrespective owners. Type'help;'or'\h'forhelp.Type'\c'toclearthecurrentinputstatement. mysql>SELECTVERSION; ERROR1054(42S22):Unknowncolumn'VERSION'in'fieldlist' mysql>SELECTVERSION(); +-----------+ |VERSION()| +-----------+ |8.0.20| +-----------+ 1rowinset(0.00sec) mysql>
到此可以正常登陆数据库了,可以自行查找开启远程方式。
总结
到此这篇关于CentOS7版本安装Mysql8.0.20版本数据库的详细教程的文章就介绍到这了,更多相关CentOS7安装Mysql8.0数据库内容请搜索毛票票以前的文章或继续浏览下面的相关文章希望大家以后多多支持毛票票!