CentOS 7安装MySQL

centOS7基于Hadoop安装Mysql 一、下载MYSQL: 1.查看是否安装wget:wget http://www.baidu.com 2.如果没有安装,执行安装:yum install wget 3.再次执行wget测试是否安装成功:wget http://www.baidu.com 二、下载MYSQL:wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm 注:在哪个目录下执行,下载就在哪个目录 三、进行repo的安装:rpm -ivh mysq 阅读详情

CentOS 7安装MySQL

该部分所有的操作都要在root用户下:

1、 查看并卸载系统自带的mariadb-lib数据库

[root@master ~]# rpm -qa|grep mariadb

[root@master ~]# yum -y remove mariadb-libs-5.5.52-1.el7.x86_64

2、 解压mysql的安装包

将mysql文件上传到指定文件夹

[root@master ~]# cd /home/zkpk/resources/software/mysql/

[root@master ~]# unzip mysql-5.7.18-1.el7.x86_64.rpm-bundle.zip-C /root

3、 进入解压目录
[root@master ~]# cd mysql-5.7.18-1.el7.x86_64.rpm-bundle
4、 安装mysql组件,在Shell命令行依次执行以下四个命令。

[root@master mysql-5.7.18-1.el7.x86_64.rpm-bundle]# rpm -ivh mysql-community-common-5.7.18-1.el7.x86_64.rpm

[root@master mysql-5.7.18-1.el7.x86_64.rpm-bundle]# rpm -ivh mysql-community-libs-5.7.18-1.el7.x86_64.rpm

[root@master mysql-5.7.18-1.el7.x86_64.rpm-bundle]# rpm -ivh  mysql-community-client-5.7.18-1.el7.x86_64.rpm

[root@master mysql-5.7.18-1.el7.x86_64.rpm-bundle]# rpm -ivh  mysql-community-server-5.7.18-1.el7.x86_64.rpm

注意:

(1)如 果 遇 到 类 似 “ libnuma.so.1()(64bit)   isneeded by mysql-­‐community-­‐server-­‐5.7.18-­‐1.el7.x86_64”错误,请输入以下命令安装缺失包:

[root@master ~]#   yum install  -y numactl 

(2)如果遇到类似爆冲突,请清除多余 mysql 包,如清除 mysql---libs 包:

[root@master ~]#  rpm ­e ­--nodeps     mysql---libs

5、 启动mysql服务,并设置开机自启动
[root@master mysql-5.7.18-1.el7.x86_64.rpm-bundle]# systemctl start mysqld
[root@master mysql-5.7.18-1.el7.x86_64.rpm-bundle]# systemctl enable mysqld
[root@master mysql-5.7.18-1.el7.x86_64.rpm-bundle]# systemctl daemon-reload
6、 查看mysql自动生成的root密码
[root@master mysql-5.7.18-1.el7.x86_64.rpm-bundle]# grep 'temporary password' /var/log/mysqld.log
2018-02-25T21:07:58.009956Z 1 [Note] A temporary password is generated for root@localhost: w0hoN/tulY*V
7、 登录mysql(密码为上一步骤中查看的密码)
[root@master mysql-5.7.18-1.el7.x86_64.rpm-bundle]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.18
Copyright (c) 2000, 2017, 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>
8、 修改自己的root密码为“MyNewPass4!”

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';


9、 修改mysql的密码策略
1).查看Mysql密码策略相关信息
mysql> show variables like '%password%';

2)关闭密码策略(向my.cnf文件中添加如下配置(/etc/my.cnf):)

[root@master ~]# vim /etc/my.cnf

validate_password = off

3)重启mysql服务使得服务配置生效

[root@master ~]# systemctl restart mysqld

10、 修改mysql密码为lyu
[root@master ~]# mysql -uroot -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'lyu';

11、添加lyu用户并赋予远程登录权限

mysql>grant all on *.* to lyu@'%' identified by 'lyu';

mysql>grant all on *.* to lyu@'localhost' identified by 'lyu';

mysql>grant all on *.* to lyu@'master' identified by 'lyu';

mysql>flush privileges;

mysql>exit;

12、  配置mysql默认编码为utf-8
说明:修改/etc/my.cnf配置文件,在[mysqld]下添加编码配置

[root@master ~]# vim /etc/my.cnf

[mysqld]

character_set_server=utf8

init_connect='SET NAMES utf8'

1)    重新启动mysql服务

[root@master ~]# systemctl restart mysqld

2)   查看数据库默认编码

[root@master ~]# mysql -uroot -p

mysql> show variables like '%character%';


CentOS7安装MySql CentOS7 安装Mysql5.7目前MySQL数据库按用户群分为社区版(Community Server)和企业版(Enterprise/commercial)。–commercial授权版本社区版是免费下载的,GA(General Availability):官方推荐使用的版本。 阅读详情

相关推荐

基于FPGA的DDR学习——1.基础知识

⚪DDR2(Double Data Rate2)SDRAM是由JEDEC(电子设备工程联合委员会)开发的第三代SDRAM内存技术标准,1.8V工作电压,240线接口,提供了相较于DDR SDRAM更高的运行效能与更低的电压,同样采用在时钟的上升/下降沿同时进行数据传输的基本方式,但拥有两倍于上一代DDR内存预读取能力(即4bit数据预取能力),其常见的频率规范有DDR2 400\533\667\800\1066\1333等,总线频率553MHZ的DDR2内存只需133MHZ的工作频率。

qq_44932488的博客 2070

mysql 5.7安装文档

  1)     下载安装包 #wget https://cdn.mysql.com//archives/mysql-5.7/mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar  2)      解压安装包 # tar -xvf mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar//解压后文件列表:mysql-community-emb...

wyqwilliam的博客 1683

⭐⭐⭐全网最详细YOLOv8教程,从环境配置到自己训练,再到数据集的制作,包的各位⭐⭐⭐

问题原因:当你“pip install ultralytics” 时,torch和torchvision会作为它的依赖一起安装了,当执行“pip install torch torchvision torchaudio --index-url。”时,会卸载torch,然后再安装torch+cuda版本,但是不会自动卸载torchvision已有版本,然后再安装torchvision+cuda版本。🎉🎉🎉恭喜各位道友,已经可以训练模型了,现在就是制作自己的数据集,所谓申神通秘境,随心所欲,万物皆可识别也

weixin_74840239的博客 7492

Centos7 远程无法连接mysql数据库

以下方法就是我在碰到远程连接不到Mysql数据库后试过的方法,最终也是解决掉了问题。所以总结一下。有两种原因 数据库没有授权 服务器防火墙没有开放3306端口 数据库没有授权对于mysql数据库没有授权,只需要用一条命令就可以了。mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPT

兜兜的博客 3097

grpc安装与简单demo测试

grpc安装: 由于工作需要,最近在学google的rpc开源框架;由于本人菜鸟一枚,而且是从Windows开发转到Linux;由于之前版本控制使用的是svn,没有使用过git,所以从GitHub上下载代码是通过浏览器下载zip格式的压缩文件,折腾了好几天了,发现了各种坑,各种缺少库,各种不知道怎么把这个库给装机器上。对于一个不熟悉Linux的人来说,这个体验简直糟糕透了。没办法了又在机器上装了...

old__captain的博客 4833

从零到一:龙芯杯参赛全攻略(含北理工学长经验PDF、B站培训视频与开源代码合集)

本文详细介绍了龙芯杯全国大学生计算机系统能力大赛的参赛全攻略,包括资源整合、技能树构建、团队协作和避坑指南。提供北理工学长经验PDF、B站培训视频与开源代码合集,帮助参赛者从零基础到站上领奖台。重点解析如何高效获取优质资源、避开新手常见陷阱及构建可落地的学习路径,助力普通学生系统学习CPU设计。

weixin_26802933的博客 542

【MySQL】MySQL在Centos7环境下安装

关于配置mysql环境以及如何登录。

须知少日拏云志,曾许人间第一流。 1万+

Redhawk:什么是timing window?

STA timing file中timing window的作用和计算方式

m0_61544122的博客 1万+

【MySQL】在 Centos7 环境安装 MySQL -- 详细完整教程

mariadb 其实就是 mysql,只不过是 mysql 的另一种拉出来的开源分支,也可以正常使用,如果不想卸载也是可以的。一开始的时候我们安装的 yum,在安装完之后是可以选择删除的,因为每次 yum 操作都会更新一次,耗费时间。使用临时密码登录后,不能进行其他的操作,否则会报错,这时候我们进行修改密码操作。这时候我们就可以自己设置想要的密码了。

Elena's Blog 5万+

详解Pytorch求导

本文主要详解Pytorch求导,希望能对学习Pytorch的同学有所帮助。 文章目录 1. pytorch求导问题 2. pytorch三大类求导代码示例 2.1 标量求导 2.2 向量求导&矩阵求导

weixin_43178406的博客 3076

用 MVC 框架把 ABAP 报表写成可扩展的应用(2)

本文介绍了一个基于MVC架构的SAP报表模板,解决了传统ABAP报表开发中的三个核心痛点: 选择屏幕校验逻辑分散问题 - 通过统一的选择屏幕控制器集中管理校验逻辑 在线与后台输出不一致问题 - 共享同一数据模型,通过不同控制器实现多样化展示 屏幕流转管理混乱问题 - 主控制器统一管理所有屏幕流程和事件 该模板采用分层架构: Model层专注数据获取和业务规则 Controller层管理流程和交互 View层负责展示逻辑 特别适用于需要同时支持交互式ALV展示和后台批处理输出的报表场景,通过标准化的扩展点设计

2007 年 ~ 2025 年,深耕 SAP 技术 18 年 78

Linux王者CentOS7极简入门:7小时让你从凡人进阶筑基强者!

本套课程设计为零基础快速入门Linux操作系统系列课程,课程以讲解CentOS7版本为蓝本,讲解Linux常用的知识点。主打帮助同学快速上手Linux,能在工作中快速使用。课程内容包括:1>linux历史2>linux系统安装3>linux常用命令4>linux中vi编辑器5>linux权限管理6>linux系统服务管理7>linux网路管理8>linux软件安装9>war类型项目部署10>SpringBoot项目部署

【异常】Warp终端AI功能403封禁报错I‘m sorry, I couldn‘t complete that request.Request failed with error: ErrorSta

本文针对Warp终端出现的AI功能定向封禁报错,完整还原脱敏后的报错信息、深度解读报错本质,并提供分优先级的全流程可落地解决方案,可直接用于技术排查、内部知识库归档。

奶爸的编程之路,也就一周冷个三天 267

Centos7下安装MySQL详细步骤

Centos7下安装MySQL详细步骤

lyouhuan的博客 4万+

深度学习工具包 DeepLearningToolbox

深度学习工具包Deprecation notice.-----This toolbox is outdated and no longer maintained.There are much better tools available for deep learning than this toolbox, e.g. [Theano](http://deeplearning.net/software/theano/), [torch](http://torch.ch/) or [tensorflow](http://www.tensorflow.org/)I would suggest you use one of the tools mentioned above rather than use this toolbox.Best, Rasmus.DeepLearnToolbox================A Matlab toolbox for Deep Learning.Deep Learning is a new subfield of machine learning that focuses on learning deep hierarchical models of data.It is inspired by the human brain's apparent deep (layered, hierarchical) architecture.A good overview of the theory of Deep Learning theory is[Learning Deep Architectures for AI](http://www.iro.umontreal.ca/~bengioy/papers/ftml_book.pdf)For a more informal introduction, see the following videos by Geoffrey Hinton and Andrew Ng.* [The Next Generation of Neural Networks](http://www.youtube.com/watch?v=AyzOUbkUf3M) (Hinton, 2007)* [Recent Developments in Deep Learning](http://www.youtube.com/watch?v=VdIURAu1-aU) (Hinton, 2010)* [Unsupervised Feature Learning and Deep Learning](http://www.youtube.com/watch?v=ZmNOAtZIgIk) (Ng, 2011)If you use this toolbox in your research please cite [Prediction as a candidate for learning deep hierarchical models of data](http://www2.imm.dtu.dk/pubdb/views/publication_details.php?id=6284)```@MASTERSTHESIS\{IMM2012-06284, author = "R. B. Palm", title = "Prediction as a candidate for learning deep hierarchical models of data", year = "2012",}```Contact: rasmusbergpalm at gmail dot comDirectories included in the toolbox-----------------------------------`NN/` - A library for Feedforward Backpropagation Neural Networks`CNN/` - A library for Convolutional Neural Networks`DBN/` - A library for Deep Belief Networks`SAE/` - A library for Stacked Auto-Encoders`CAE/` - A library for Convolutional Auto-Encoders`util/` - Utility functions used by the libraries`data/` - Data used by the examples`tests/` - unit tests to verify toolbox is workingFor references on each library check REFS.mdSetup-----1. Download.2. addpath(genpath('DeepLearnToolbox'));Example: Deep Belief Network---------------------```matlabfunction test_example_DBNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit RBM and visualize its weightsrand('state',0)dbn.sizes = [100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);figure; visualize(dbn.rbm{1}.W'); % Visualize the RBM weights%% ex2 train a 100-100 hidden unit DBN and use its weights to initialize a NNrand('state',0)%train dbndbn.sizes = [100 100];opts.numepochs = 1;opts.batchsize = 100;opts.momentum = 0;opts.alpha = 1;dbn = dbnsetup(dbn, train_x, opts);dbn = dbntrain(dbn, train_x, opts);%unfold dbn to nnnn = dbnunfoldtonn(dbn, 10);nn.activation_function = 'sigm';%train nnopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.10, 'Too big error');```Example: Stacked Auto-Encoders---------------------```matlabfunction test_example_SAEload mnist_uint8;train_x = double(train_x)/255;test_x = double(test_x)/255;train_y = double(train_y);test_y = double(test_y);%% ex1 train a 100 hidden unit SDAE and use it to initialize a FFNN% Setup and train a stacked denoising autoencoder (SDAE)rand('state',0)sae = saesetup([784 100]);sae.ae{1}.activation_function = 'sigm';sae.ae{1}.learningRate = 1;sae.ae{1}.inputZeroMaskedFraction = 0.5;opts.numepochs = 1;opts.batchsize = 100;sae = saetrain(sae, train_x, opts);visualize(sae.ae{1}.W{1}(:,2:end)')% Use the SDAE to initialize a FFNNnn = nnsetup([784 100 10]);nn.activation_function = 'sigm';nn.learningRate = 1;nn.W{1} = sae.ae{1}.W{1};% Train the FFNNopts.numepochs = 1;opts.batchsize = 100;nn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.16, 'Too big error');```Example: Convolutional Neural Nets---------------------```matlabfunction test_example_CNNload mnist_uint8;train_x = double(reshape(train_x',28,28,60000))/255;test_x = double(reshape(test_x',28,28,10000))/255;train_y = double(train_y');test_y = double(test_y');%% ex1 Train a 6c-2s-12c-2s Convolutional neural network %will run 1 epoch in about 200 second and get around 11% error. %With 100 epochs you'll get around 1.2% errorrand('state',0)cnn.layers = { struct('type', 'i') %input layer struct('type', 'c', 'outputmaps', 6, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %sub sampling layer struct('type', 'c', 'outputmaps', 12, 'kernelsize', 5) %convolution layer struct('type', 's', 'scale', 2) %subsampling layer};cnn = cnnsetup(cnn, train_x, train_y);opts.alpha = 1;opts.batchsize = 50;opts.numepochs = 1;cnn = cnntrain(cnn, train_x, train_y, opts);[er, bad] = cnntest(cnn, test_x, test_y);%plot mean squared errorfigure; plot(cnn.rL);assert(er<0.12, 'Too big error');```Example: Neural Networks---------------------```matlabfunction test_example_NNload mnist_uint8;train_x = double(train_x) / 255;test_x = double(test_x) / 255;train_y = double(train_y);test_y = double(test_y);% normalize[train_x, mu, sigma] = zscore(train_x);test_x = normalize(test_x, mu, sigma);%% ex1 vanilla neural netrand('state',0)nn = nnsetup([784 100 10]);opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samples[nn, L] = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.08, 'Too big error');%% ex2 neural net with L2 weight decayrand('state',0)nn = nnsetup([784 100 10]);nn.weightPenaltyL2 = 1e-4; % L2 weight decayopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex3 neural net with dropoutrand('state',0)nn = nnsetup([784 100 10]);nn.dropoutFraction = 0.5; % Dropout fraction opts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex4 neural net with sigmoid activation functionrand('state',0)nn = nnsetup([784 100 10]);nn.activation_function = 'sigm'; % Sigmoid activation functionnn.learningRate = 1; % Sigm require a lower learning rateopts.numepochs = 1; % Number of full sweeps through dataopts.batchsize = 100; % Take a mean gradient step over this many samplesnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex5 plotting functionalityrand('state',0)nn = nnsetup([784 20 10]);opts.numepochs = 5; % Number of full sweeps through datann.output = 'softmax'; % use softmax outputopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, train_x, train_y, opts);[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');%% ex6 neural net with sigmoid activation and plotting of validation and training error% split training data into training and validation datavx = train_x(1:10000,:);tx = train_x(10001:end,:);vy = train_y(1:10000,:);ty = train_y(10001:end,:);rand('state',0)nn = nnsetup([784 20 10]); nn.output = 'softmax'; % use softmax outputopts.numepochs = 5; % Number of full sweeps through dataopts.batchsize = 1000; % Take a mean gradient step over this many samplesopts.plot = 1; % enable plottingnn = nntrain(nn, tx, ty, opts, vx, vy); % nntrain takes validation set as last two arguments (optionally)[er, bad] = nntest(nn, test_x, test_y);assert(er < 0.1, 'Too big error');```[![Bitdeli Badge](https://d2weczhvl823v0.cloudfront.net/rasmusbergpalm/deeplearntoolbox/trend.png)](https://bitdeli.com/free "Bitdeli Badge")

OV9734 DATASHEET,完整规格书

OV9734完整规格书,包括电气参数,尺寸规格,寄存器配置表等

CentOS7安装MySQL8

Centos7 安装 Mysql8

u014212540的博客 6388

Camera2Demo

在Camera2 的基础上进行封装,使得Camera2一堆初始化逻辑与Activity分离,降低耦合度,完成预览拍照并保存的操作

CentOS7 安装MySQL

1. 创建安装目录1.进入到目录 /usr/ 中:$ cd /usr/2.创建目录 /usr/software,如果有则忽略: $ mkdir -p software3.创建 /usr/software/mysql 目录,如果已存在则忽略:$ mkdir -p mysql4.进入到目录 /usr/software/中:$ cd /usr/software2.查看是否已安装1.查看系统中是否已安装 M

jeikerxiao 3346

Centos7安装MySQL

mysql安装

weixin_72036027的博客 1496

CentOS 7 安装 MySQL 5.7

在 CentOS 7 中默认安装有 MariaDB ,这个是 MySQL 的分支,但为了需要,还是要在系统中安装 MySQL ,而且安装完成之后可以直接覆盖掉 MariaDB。

Shockang的博客 4836

centos7离线安装mysql

centos7安装mysql5.7 1.安装之前准备工作: 下载对应的安装包https://pan.baidu.com/s/1rLuiACHh-zr-mUeHss6JOw提取码:x126 包下面有对应的一键安装脚本,但是如果可能需要改动下里面的脚本还有配置文件才能适用你自己的要求,最好先看看系统的挂载点再改配置。如果不知道可以怎么改,可以留言。 以下是在安装centos7后纯净的系统。 mysql对于权限的要求,会...

liujia_It的博客 5362

如何在centOS7中安装mysql

目录下载mysql解压mysql1、前期准备2、解压mysql安装包安装mysql修改密码 下载mysql https://dev.mysql.com/downloads/mysql/ 注:可自行选择版本 解压mysql 1、前期准备 [root@localhost ~]# rpm -qa |grep mysql //是否已经安装了mysql [root@localhost ~]# rpm -qa |grep -i mariadb //是否已经安装了mariadb数据库 mariadb-libs-5

weixin_45439090的博客 1016

Centos7安装Mysql详细步骤

本文主要介绍如何在Centos7下安装Mysql

drog79的专栏 6104

CentOS7 安装MySQL8

一、MySQL 安装包下载 二、MySQL安装(mysql安装的前置准备工作以及常规安装方式和 非常规安装方式)。

技术进阶从入门到放弃 1799

CentOS7 —— yum安装mysql

先自我介绍一下,小编13年上师交大毕业,曾经在小公司待过,去过华为OPPO等大厂,18年进入阿里,直到现在。深知大多数初中级java工程师,想要升技能,往往是需要自己摸索成长或是报班学习,但对于培训机构动则近万元的学费,着实压力不小。mysql默认安装了密码安全检查插件(validate_password),默认密码检查策略要求密码必须包含大小写字母、数字和特殊符号,并且长度不能少于8位。如果没安装wget工具,用yum-yinstallwget安装一下先。属于特殊字符,要加转义,写成!...

m0_67393619的博客 1787

【在centos7上安装mysql5.7】

在centos7里面安装mysql数据库

2203_75584759的博客 1415
上一篇: CentOS 7安装Hadoop
下一篇: 安装部署Hive
追梦小猿
博客等级 码龄10年 69粉丝 26原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明:

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

余额充值