linux mysql url_Linux安装Mysql

最新推荐文章于 2022-03-22 09:49:09 发布
最新推荐文章于 2022-03-22 09:49:09 发布
阅读量156 收藏
点赞数
文章标签： linux mysql url
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_32724679/article/details/114725262
版权

查看是否已经安装了mysql

rpm -qa|grep mysql #无输出说明没有安装

aa4b8908bbc8

图片.png

aa4b8908bbc8

图片.png

复制下载文件的全名：mysql80-community-release-el7-3.noarch.rpm

下载和安装mysql源

[root@iZbp117qjre4vusjrgw7ftZ /]# wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

--2021-01-05 08:56:39-- https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

Resolving dev.mysql.com (dev.mysql.com)... 137.254.60.11

Connecting to dev.mysql.com (dev.mysql.com)|137.254.60.11|:443... connected.

HTTP request sent, awaiting response... 302 Found

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

--2021-01-05 08:56:41-- https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm

Resolving repo.mysql.com (repo.mysql.com)... 104.91.72.230

Connecting to repo.mysql.com (repo.mysql.com)|104.91.72.230|:443... 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.1’

100%[====================================================================================================================================================================================================================================>] 26,024 62.3KB/s in 0.4s

2021-01-05 08:56:43 (62.3 KB/s) - ‘mysql80-community-release-el7-3.noarch.rpm.1’ saved [26024/26024]

安装mysql源

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

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

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

Updating / installing...

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

查看mysql相关资源

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

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

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

Updating / installing...

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

[root@iZbp117qjre4vusjrgw7ftZ /]# yum repolist enabled | grep "mysql.*-community.*"

mysql-connectors-community/x86_64 MySQL Connectors Community 175

mysql-tools-community/x86_64 MySQL Tools Community 120

mysql80-community/x86_64 MySQL 8.0 Community Server 211

选择masql版本

yum repolist all | grep mysql

使用MySQL Yum Repository安装MySQL，默认会选择当前最新的稳定版本

使用命令：yum repolist all | grep mysql，查看当前yum repolist的所有版本

[root@iZbp117qjre4vusjrgw7ftZ /]# yum repolist all | grep mysql

mysql-cluster-7.5-community/x86_64 MySQL Cluster 7.5 Community disabled

mysql-cluster-7.5-community-source MySQL Cluster 7.5 Community - disabled

mysql-cluster-7.6-community/x86_64 MySQL Cluster 7.6 Community disabled

mysql-cluster-7.6-community-source MySQL Cluster 7.6 Community - disabled

mysql-cluster-8.0-community/x86_64 MySQL Cluster 8.0 Community disabled

mysql-cluster-8.0-community-source MySQL Cluster 8.0 Community - disabled

mysql-connectors-community/x86_64 MySQL Connectors Community enabled: 175

mysql-connectors-community-source MySQL Connectors Community - disabled

mysql-tools-community/x86_64 MySQL Tools Community enabled: 120

mysql-tools-community-source MySQL Tools Community - Sourc disabled

mysql-tools-preview/x86_64 MySQL Tools Preview disabled

mysql-tools-preview-source MySQL Tools Preview - Source disabled

mysql55-community/x86_64 MySQL 5.5 Community Server disabled

mysql55-community-source MySQL 5.5 Community Server - disabled

mysql56-community/x86_64 MySQL 5.6 Community Server disabled

mysql56-community-source MySQL 5.6 Community Server - disabled

mysql57-community/x86_64 MySQL 5.7 Community Server disabled

mysql57-community-source MySQL 5.7 Community Server - disabled

mysql80-community/x86_64 MySQL 8.0 Community Server enabled: 211

mysql80-community-source MySQL 8.0 Community Server - disabled

切换版本

sudo yum-config-manager --disable mysql80-community

sudo yum-config-manager --enable mysql57-community

[root@iZbp117qjre4vusjrgw7ftZ /]# sudo yum-config-manager --disable mysql80-community

Loaded plugins: fastestmirror, langpacks

========================================================================================================================== repo: mysql80-community ===========================================================================================================================

[mysql80-community]

async = True

bandwidth = 0

base_persistdir = /var/lib/yum/repos/x86_64/2.1903

baseurl = http://repo.mysql.com/yum/mysql-8.0-community/el/7/x86_64/

cache = 0

cachedir = /var/cache/yum/x86_64/2.1903/mysql80-community

check_config_file_age = True

compare_providers_priority = 80

cost = 1000

deltarpm_metadata_percentage = 100

deltarpm_percentage =

enabled = 0

enablegroups = True

exclude =

failovermethod = priority

ftp_disable_epsv = False

gpgcadir = /var/lib/yum/repos/x86_64/2.1903/mysql80-community/gpgcadir

gpgcakey =

gpgcheck = True

gpgdir = /var/lib/yum/repos/x86_64/2.1903/mysql80-community/gpgdir

gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

hdrdir = /var/cache/yum/x86_64/2.1903/mysql80-community/headers

http_caching = all

includepkgs =

ip_resolve =

keepalive = True

keepcache = False

mddownloadpolicy = sqlite

mdpolicy = group:small

mediaid =

metadata_expire = 21600

metadata_expire_filter = read-only:present

metalink =

minrate = 0

mirrorlist =

mirrorlist_expire = 86400

name = MySQL 8.0 Community Server

old_base_cache_dir =

password =

persistdir = /var/lib/yum/repos/x86_64/2.1903/mysql80-community

pkgdir = /var/cache/yum/x86_64/2.1903/mysql80-community/packages

proxy = False

proxy_dict =

proxy_password =

proxy_username =

repo_gpgcheck = False

retries = 10

skip_if_unavailable = False

ssl_check_cert_permissions = True

sslcacert =

sslclientcert =

sslclientkey =

sslverify = True

throttle = 0

timeout = 30.0

ui_id = mysql80-community/x86_64

ui_repoid_vars = releasever,

basearch

username =

[root@iZbp117qjre4vusjrgw7ftZ /]# sudo yum-config-manager --enable mysql57-community

Loaded plugins: fastestmirror, langpacks

========================================================================================================================== repo: mysql57-community ===========================================================================================================================

[mysql57-community]

async = True

bandwidth = 0

base_persistdir = /var/lib/yum/repos/x86_64/2.1903

baseurl = http://repo.mysql.com/yum/mysql-5.7-community/el/7/x86_64/

cache = 0

cachedir = /var/cache/yum/x86_64/2.1903/mysql57-community

check_config_file_age = True

compare_providers_priority = 80

cost = 1000

deltarpm_metadata_percentage = 100

deltarpm_percentage =

enabled = 1

enablegroups = True

exclude =

failovermethod = priority

ftp_disable_epsv = False

gpgcadir = /var/lib/yum/repos/x86_64/2.1903/mysql57-community/gpgcadir

gpgcakey =

gpgcheck = True

gpgdir = /var/lib/yum/repos/x86_64/2.1903/mysql57-community/gpgdir

gpgkey = file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

hdrdir = /var/cache/yum/x86_64/2.1903/mysql57-community/headers

http_caching = all

includepkgs =

ip_resolve =

keepalive = True

keepcache = False

mddownloadpolicy = sqlite

mdpolicy = group:small

mediaid =

metadata_expire = 21600

metadata_expire_filter = read-only:present

metalink =

minrate = 0

mirrorlist =

mirrorlist_expire = 86400

name = MySQL 5.7 Community Server

old_base_cache_dir =

password =

persistdir = /var/lib/yum/repos/x86_64/2.1903/mysql57-community

pkgdir = /var/cache/yum/x86_64/2.1903/mysql57-community/packages

proxy = False

proxy_dict =

proxy_password =

proxy_username =

repo_gpgcheck = False

retries = 10

skip_if_unavailable = False

ssl_check_cert_permissions = True

sslcacert =

sslclientcert =

sslclientkey =

sslverify = True

throttle = 0

timeout = 30.0

ui_id = mysql57-community/x86_64

ui_repoid_vars = releasever,

basearch

username =

安装mysql

sudo yum install mysql-community-server

该命令会安装MySQL服务器 (mysql-community-server) 及其所需的依赖、相关组件，包括mysql-community-client、mysql-community-common、mysql-community-libs等。安装时间会比较长

[root@iZbp117qjre4vusjrgw7ftZ /]# sudo yum install mysql-community-server

Loaded plugins: fastestmirror, langpacks

Loading mirror speeds from cached hostfile

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

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

mysql57-community | 2.6 kB 00:00:00

mysql57-community/x86_64/primary_db | 247 kB 00:00:04

Resolving Dependencies

--> Running transaction check

---> Package mysql-community-server.x86_64 0:5.7.32-1.el7 will be installed

--> Processing Dependency: mysql-community-common(x86-64) = 5.7.32-1.el7 for package: mysql-community-server-5.7.32-1.el7.x86_64

--> Processing Dependency: mysql-community-client(x86-64) >= 5.7.9 for package: mysql-community-server-5.7.32-1.el7.x86_64

--> Running transaction check

---> Package mysql-community-client.x86_64 0:5.7.32-1.el7 will be installed

--> Processing Dependency: mysql-community-libs(x86-64) >= 5.7.9 for package: mysql-community-client-5.7.32-1.el7.x86_64

---> Package mysql-community-common.x86_64 0:5.7.32-1.el7 will be installed

--> Running transaction check

---> Package mysql-community-libs.x86_64 0:5.7.32-1.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

==============================================================================================================================================================================================================================================================================

Package Arch Version Repository Size

==============================================================================================================================================================================================================================================================================

Installing:

mysql-community-server x86_64 5.7.32-1.el7 mysql57-community 173 M

Installing for dependencies:

mysql-community-client x86_64 5.7.32-1.el7 mysql57-community 25 M

mysql-community-common x86_64 5.7.32-1.el7 mysql57-community 308 k

mysql-community-libs x86_64 5.7.32-1.el7 mysql57-community 2.3 M

Transaction Summary

==============================================================================================================================================================================================================================================================================

Install 1 Package (+3 Dependent packages)

Total download size: 201 M

Installed size: 875 M

Is this ok [y/d/N]: y

Downloading packages:

(1/4): mysql-community-common-5.7.32-1.el7.x86_64.rpm | 308 kB 00:00:05

(2/4): mysql-community-libs-5.7.32-1.el7.x86_64.rpm | 2.3 MB 00:00:02

(3/4): mysql-community-client-5.7.32-1.el7.x86_64.rpm | 25 MB 00:00:14

(4/4): mysql-community-server-5.7.32-1.el7.x86_64.rpm | 173 MB 00:01:34

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

Total 2.0 MB/s | 201 MB 00:01:41

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Warning: RPMDB altered outside of yum.

Installing : mysql-community-common-5.7.32-1.el7.x86_64 1/4

Installing : mysql-community-libs-5.7.32-1.el7.x86_64 2/4

Installing : mysql-community-client-5.7.32-1.el7.x86_64 3/4

Installing : mysql-community-server-5.7.32-1.el7.x86_64 4/4

Verifying : mysql-community-server-5.7.32-1.el7.x86_64 1/4

Verifying : mysql-community-common-5.7.32-1.el7.x86_64 2/4

Verifying : mysql-community-libs-5.7.32-1.el7.x86_64 3/4

Verifying : mysql-community-client-5.7.32-1.el7.x86_64 4/4

Installed:

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

Dependency Installed:

mysql-community-client.x86_64 0:5.7.32-1.el7 mysql-community-common.x86_64 0:5.7.32-1.el7 mysql-community-libs.x86_64 0:5.7.32-1.el7

Complete!

启动Mysql

systemctl start mysqld.service

systemctl status mysqld.service

[root@iZbp117qjre4vusjrgw7ftZ /]# systemctl start mysqld.service

[root@iZbp117qjre4vusjrgw7ftZ /]# systemctl status mysqld.service

● mysqld.service - MySQL Server

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)

Active: active (running) since Tue 2021-01-05 09:03:45 CST; 5s ago

Docs: man:mysqld(8)

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

Process: 9312 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)

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

Main PID: 9315 (mysqld)

CGroup: /system.slice/mysqld.service

└─9315 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

Jan 05 09:03:40 iZbp117qjre4vusjrgw7ftZ systemd[1]: Starting MySQL Server...

Jan 05 09:03:45 iZbp117qjre4vusjrgw7ftZ systemd[1]: Started MySQL Server.

停止Mysql

systemctl stop mysqld.service

重启Mysql

systemctl restart mysqld.service

初始密码

MySQL第一次启动后会创建超级管理员账号root@localhost，初始密码存储在日志文件中：

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

2021-01-05T01:03:43.082918Z 1 [Note] A temporary password is generated for root@localhost: 03X5g%iO6ul.

修改默认密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Su#2021Gjj';

Query OK, 0 rows affected (0.00 sec)

设置开机启动

[root@iZbp117qjre4vusjrgw7ftZ /]# systemctl enable mysqld

[root@iZbp117qjre4vusjrgw7ftZ /]# systemctl daemon-reload

开放远程连接

mysql>use mysql;

msyql>update user set user.Host='%' where user.User='root';

mysql>flush privileges;

MooliHui
关注
Linux上mysql查看URL_linux 测试网络url命令
weixin_28847199的博客
01-28 1125
1.curl 地址 或者 wget url地址[hxxxx@iZ23vy2msooZ ~]$ curl www.baidu.com鐧惧害涓€涓嬶紝浣犲氨鐭ラ亾 鏂伴椈 hao123 鍦板浘 瑙嗛 璐村惂 鐧诲綍 document.write('鐧诲綍'); 鏇村浜у搧 鍏充簬鐧惧害 About Baidu ©2017Baidu浣跨敤...
python在linux下安装mysql_Linux下安装python,mysql,redis
weixin_36413546的博客
01-29 280
1.python下载请在终端输入如下命令：cd /homewget http://cdn.npm.taobao.org/dist/python/3.6.5/Python-3.6.5.tgz说明：这句话的作用主要是用wget软件(初学者请自行了解次软件，以后会经常用到)从一个指定的URL下载文件。其格式为:wget 空格 URL地址。而下载目录就是当前目录，所以需要cd到你需要放置下载文件的地方。2...
linux mysql url_Linux下mysql注意事项
weixin_33791941的博客
01-27 215
一、忘记原来的mysql的root密码；1、停止mysql服务/etc/init.d/mysqld stop2、进入安全模式mysqld_safe --skip-grant-tables &&3、进入mysqlmysql4、使用mysqluse mysql;5、更新密码UPDATEuserSETpassword=password("test123") WHEREuser='...
linux mysql url_linux mysql远程连接
weixin_42347629的博客
01-27 138
客户端服务器mysql连接其他服务器mysql的时候报以下错误：ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)输入命令查看#mysql --help|grep secure-authsecure-aut...
linux mysql url_linux 下连接mysql服务器
weixin_31926457的博客
01-21 584
mysql -h 服务器主机地址 -u 用户名 -p 用户密码其中，参数的意义:-h:指定所连接的数据库服务器位置，可以是IP地址，也可以是服务器域名。-u:指定连接数据库服务器使用的用户名，例如root为管理员用户具有所有权限。-p:连接数据库服务器使用的密码，但-p和其后的参数之间不要有空格。最后是在该参数后直接回车，然后以密文的形式输入密码。例：mysql -h 192.168.1.149 ...
linux mysql url_linux系统下js连接mysql
weixin_29492649的博客
01-21 145
//varid="0_707";varurl=location.href;varlen=url.length;//获取url的长度varoffset=url.indexOf("?");//设置参数字符串开始的位置varnewsidinfo=url.substr(offset,len)//取出参数字...//var id= "0_707";var url=location.href;var len=...
linux安装jdk_mysql_maven_nacos_rocketMQ.....docx
12-01
db.url.0=jdbc:mysql://127.0.0.1:3306/nacos_config?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&serverTimezone=Asia/Shanghai db.user=root db.password=zhangjianshan `...
audit-plugin-mysql-5.7-1.1.7-921-linux-x86_64.zip
04-25
"audit-plugin-mysql-5.7-1.1.7-921-linux-x86_64.zip" 文件是一个针对Linux 64位系统的特定版本审计插件，适用于MySQL 5.7版本。 审计插件的主要功能包括： 1. **活动记录**：审计插件能够详细记录所有SQL语句，...
linux一键安装mysql5.7和mysql8.0脚本
02-08
该包中包含一键安装mysql5.7和mysql8.0脚本，分为mysql二进制包安装和yum安装，并一起部署MySQL备份策略 用于快速部署mysql场景，适合多项目快速部署 备份工具为xtrabackup
在Linux上的MySQL
Xavier52的博客
03-22 158
service mysql start 打开数据库； mysql -u root 以root的权限进入数据库； create database xx; ...
linux下链接mysql数据库
InnerYgu的博客
04-11 547
一、进入mysql [root@localhost bin]# mysql -u root -p Enter password: 二、ip授权（此处授权为全部的本地ip可访问）  mysql> grant all privileges on *.* to root@'%' identified by 'ccedb' with grant option; 三、更新权限 mysql> fl
linux mysql url_Linux下MySQL的安装与配置
weixin_39963287的博客
01-27 140
# Linux下MySQL的安装与配置MySQL版本：5.7下载地址：https://www.mysql.com/downloads/#1.先查看主机是否已安装mysql(linux默认已安装mysql) ##`yum list mysql*``rpm -qa mysql*`#2.删除已安装的mysql ##`yum remove mysql*``rpm -e mysql*`#3.创建文件夹/us...
linux安装Mysql及使用详解(Centos 7.4)
geinvse_seg的博客
03-22 393
1.官网路径： （1）个人选择版本5.7.22 （2）因本地网速较慢，选择wget直接下载到linux服务器上。 （3）Mysql下载url为：https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz （4）开始下载，提示：-bash: wget: 未找到命令 解决方法：yum -y install wget （5）安装成功后，继续wget下载mysql。 （6）下载完成后，安装。 解
linux mysql查看安装信息
weixin_34262482的博客
11-24 432
ps -ef|grep mysql  root     17659     1  0  2011 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --log-error=/var/log/mysqld.log --pid-fil...
Linux mysql授权远程连接
苏公子的博客
08-04 3857
Linux MySQL授权远程连接 在安装mysql的机器上运行： 1、> mysql -uroot -p      >password 2、>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'WITH GRANT OPTION //任何主机访问数据的权限 例如，你想user使用password从任何主机连接到mysql
mysql 8.0安装条件_Mysql8.0安装
weixin_29547309的博客
02-17 493
Linux安装mysql8.0.13步骤(转)1.下载mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz的安装包2.解压mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz# tar -xvf mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz3.将解压的文件重命名mysql，并移动到/usr/lo...
Linux下jdbc连接mysql
热门推荐
学习日记
01-04 1万+
    经过一天时间的摸索终于搞定了java服务器小程序连接mysql的问题。当然过程是郁闷的，还好最后做出来了。完成过程中参阅了网上一位朋友的经验，在此表示一下感谢。下面简单地总结一下：一，安装jdbc驱动   探索并下载jdbc驱动，解压出一个文件夹。一般里面有它的源码和打包文件。直接把那个jar文件copy到你的jdk下的lib中，并修改一下classpath，把这个jar文件包括到clas
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值