CentOS6.9安装MySQL5.6

CentOS6.6系统下以RPM方式安装mysql-5.7.9 CentOS6.5系统下以RPM方式安装mysql-5.7.9 阅读详情

1 安装前执行以下命令,删除以前配置

rm -rf /etc/my.cnf

rm -rf /etc/init.d/mysqld

2 安装前执行以下命令,检查mysql依赖库是否存在,没有就安装

yum search libaio

yum install libaio

3 下载mysql5.6到 linux   /packages   目录下面

need-to-insert-img

下载链接   :https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.38-linux-glibc2.12-x86_64.tar.gz

4 创建mysql与用户组,-s /bin/false标识该用户不能登录

groupadd mysql

useradd -r -g mysql -s /bin/false mysql

5 解压mysql到 /usr/mysql

mkdir /usr/mysql

cd /packages

tar -zxvf mysql-5.6.38-linux-glibc2.12-x86_64.tar.gz  -C /usr/mysql/

6 进入mysql目录,并创建一个软链接  ,进入软连接

cd  /usr/mysql/mysql-5.6.38-linux-glibc2.12-x86_64

ln -s /usr/mysql/mysql-5.6.38-linux-glibc2.12-x86_64/ mysql

cd mysql

7 为mysql用户添加权限

chown -R mysql ./

chgrp -R mysql ./

8 在根目录添加data目录,并添加权限

mkdir -p /data/mysql

chown -R mysql:mysql /data/mysql

9 拷贝配置文件

cp support-files/my-default.cnf /etc/my.cnf

cp support-files/mysql.server /etc/init.d/mysql

10 初始化mysql数据库

vi /etc/init.d/mysql

配置下面两个

basedir=/usr/mysql/mysql-5.6.38-linux-glibc2.12-x86_64/mysql

datadir=/data/mysql

保存并退出,执行下面

./scripts/mysql_install_db --user=mysql --basedir=/usr/mysql/mysql-5.6.38-linux-glibc2.12-x86_64/mysql  --datadir=/data/mysql

11 添加环境变量

vi /etc/profile

#set mysql pathmunge

#PATH=/usr/mysql/mysql-5.6.38-linux-glibc2.12-x86_64/mysql/bin:$PATH

export PATH=/usr/mysql/mysql-5.6.38-linux-glibc2.12-x86_64/mysql/bin:$PATH

保存退出

让刚才修改生效

source /etc/profile

12 启动数据库

service mysql start

13 开机启动

chkconfig mysql on

14 初始化设置,如果此处报错commond not found 查一下是不是PATH配置错误。

mysql_secure_installation   

回车

出现如下

Enter current password for root (enter for none):

首次安装,因此没有密码,直接回车 ,出现如下:

OK, successfully used password, moving on...

Setting the root password ensures that nobody can log into the MySQL

root user without the proper authorisation.

Set root password? [Y/n]

直接输入y,回车,设置新的root用户密码

设置两次完成后,出现如下

By default, a MySQL installation has an anonymous user, allowing anyone

to log into MySQL without having to have a user account created for

them.  This is intended only for testing, and to make the installation

go a bit smoother.  You should remove them before moving into a

production environment.

Remove anonymous users? [Y/n]

这是提示删除安装时的mysql匿名用户,此时直接输入y,回车,然后出现如下

Normally, root should only be allowed to connect from 'localhost'.  This

ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n]

提示是否设置禁止远程登录root用户,输入y回车 ,然后出现如下

By default, MySQL comes with a database named 'test' that anyone can

access.  This is also intended only for testing, and should be removed

before moving into a production environment.

Remove test database and access to it? [Y/n]

这是提示mysql自带一个test的测试数据库,是否删除,直接输入y回车,然后出现如下

Reloading the privilege tables will ensure that all changes made so far

will take effect immediately.

Reload privilege tables now? [Y/n]

这是提示是否当前所有设置立即生效,直接输入y,回车,出现如下,表示完成!

All done!  If you've completed all of the above steps, your MySQL

installation should now be secure.

Thanks for using MySQL!

Cleaning up...

15 创建远程用户

mysql -u root -p

然后输入密码 ,进入mysql

切换数据库

use mysql

创建用户blues,密码为123456,可以在任意远程登录

CREATE USER 'blues'@'%' IDENTIFIED BY '123456';

授权给用户

GRANT ALL ON *.* TO 'blues'@'%';

刷新mysql系统用户权限

flush privileges;

注意:如果远程连接不上,有可能是服务器3306端口防火墙没有开放,执行以下命令

iptables -I  INPUT -p tcp --dport 3306 -j ACCEPT

此时远程Navicat可以连接刚刚安装的数据库了。



作者:郭艺宾
链接:https://www.jianshu.com/p/e6bfe6afb16a
来源:简书
著作权归作者所有。商业转载请联系作者获得授权,非商业转载请注明出处。

CentOS 6.9 上安装Mysql 5.6.39 同系列文章链接 CentOS 6.9 上安装JDK 8 CentOS 6.9 上安装Tomcat 8 CentOS 6.9 上安装Nginx 1.12.2 CentOS 6.9 上安装Redis 4.0.8 CentOS 6.9 上安装Mysql 5.6.39 一、准备工作 mysql 5.6.39(官网下载) CentOS 6.9 环境(可以参考我的上一篇博客) 二、正式开始 ... 阅读详情

相关推荐

centos6.9安装mysql详细步骤

在centos6.9版本上用yum命令安装mysql详细步骤,以及注意事项。

centos 6.9 mysql 5.6_CentOS 6.9上安装MySQL 5.6.37

记录下在CentOS 6.9环境安装MySQL 5.6.37的过程,供大家参考。1、准备数据存放的文件系统新建一个逻辑卷,并将其挂载至特定目录即可。这里不再给出过程。这里假设其逻辑卷的挂载目录为/data,而后需要创建/data/mysqldata目录做为mysql数据的存放目录。[root@001 /]# mkdir -p /data/mysqldata2、新建用户以安全方式运行进程:[root...

weixin_30290131的博客 157

【项目立项管理、项目整合管理】30天通过软考高项-第二天

①项目或阶段的概述;②范围目标、范围的评估标准,证明达到完⼯标准的证据;③质量目标、项目和产品质量的评估标准、相关核实信息和实际里程碑交付日期以及偏差原因;④成本目标,包括可接受的成本区间、实际成本,产⽣任何偏差的原因等;⑤最终产品、服务或成果的确认信息的总结;⑥进度计划目标,包括成果是否实现项目预期效益:如果在项目结束时未能实现效益,则指出效益实现程度并预计未来实现情况;

weixin_42520723的博客 1003

mysql5.6在centos6.9上安装

下载 目前官网的版本到了5.7,但是5.7的安装和5.6及之前有较大的变动,所以,这里还是选用5.6的mysql安装。下载的版本是mysql-5.6.37-linux-glibc2.12-x86_64.tar.gz,即5.6mysql版本,服务器操作系统选linux-generic,64位版本。我的操作系统是centos6.9 64位版 安装 //复制安装包到指定位置,解压,准备安装 cd /u...

征途无悔 384

clock-gating整理

文章目录clock gating 理解1、latch双稳态器件常见锁存器结构SR锁存器D锁存器2、clock gating(clock low-active) latch + AND gating 电路(clock high-active)latch + OR gating 电路 clock gating 理解 1、latch 参考:https://www.cnblogs.com/IClearner/p/6443539.html 双稳态器件 稳定状态为0或1两种 举例:交叉耦合反相器 假设初始Q为1,则可

d_b_的博客 1万+

现代密码学5.3--Hash and MAC

现代密码学5.3--Hash and MAC 博主正在学习INTRODUCTION TO MODERN CRYPTOGRAPHY (Second Edition) --Jonathan Katz, Yehuda Lindell,做一些笔记供自己回忆,如有错误请指正。整理成一个系列现代密码学,方便检索。 第二章定义了完美安全及其对应的密码方案“一次一密”, 第三章介绍了多种安全定义 3.1-3.3 计算安全,PRG和基于PRG构造的满足计算安全的密码方案; 3.4-3.5 CPA安全,PRF和基于PRF构

qq_41545715的博客 687

Linux使用MariaDB数据库管理系统

使用MariaDB数据库管理系统 1、初始化 MariaDB 服务 安装 安装 mariaDB 数据库主程序及服务端程序: [root@centos-7-master /]# yum install mariadb mariadb-server -y 启动 安装完后,启动服务程序,并将其加入到开机启动项中: [root@centos-7-master /]# systemctl start m...

贺磊的博客 628

基于单片机红外线遥控Proteus仿真电路发射接收

*单片机设计介绍,基于单片机红外线遥控Proteus仿真电路发射接收。

2201_75940997的博客 3943

Linux 系统管理高级教程(六)

在本章中,我们向您展示了如何使用您的 Linux 主机作为具有 SQL 支持的灵活的 web 服务器,以及如何通过安装 web 服务来利用这一点。创建和管理虚拟网站通过模块向 Apache 添加功能基于主机名或用户名和密码控制对站点的访问创建和管理 MariaDB 数据库和用户安装和配置第三方 web 应用程序配置 web 代理以节省带宽成本并提高速度在下一章,我们将看看如何设置我们的邮件服务器。见。

龙哥盟 1264

工作笔记05:imu、底盘车轮、单激光雷达外参校准(基于hdl_graph_slam建图和定位)

目录1. imu 校准1.1 IMU型号1.2 坐标定义1.2.1 大地坐标系(WGS84)1.2.2 当地地理坐标系(ENU)1.2.3 传感器坐标轴定义1.3 传感器校准2. 底盘车辆参数配置3. 单激光雷达校准参考文献 1. imu 校准 1.1 IMU型号 阅读IMU产品说明书,获得如下信息: Yesense YIS300 系列惯性传感系统 YIS300 系列包含: YIS300-U 惯性测量单元(IMU):输出经过校准的加速度和角速度值,同时也能够输出磁场强度信息。 YIS300-V 垂直参考系

穿林需独行的博客 4203

Greenplum基础

CREATE DATABASE 是 SQL 命令,用于创建一个新的数据库。name 是你要创建的数据库的名称。这个名称是必须的,并且在同一个数据库服务器上必须是唯一的。可选项,OWNER 指定了新数据库的所有者,如果未指定,新数据库的所有者默认是执行该命令的用户。dbowner 是数据库所有者的用户名。可选项,TEMPLATE 指定了用于创建新数据库的模板。在 PostgreSQL 和 GreenPlum 中,通常有一个名为 template1 的默认模板。如果不指定,就会使用这个默认模板。

m0_57697768的博客 1207

Ubuntu中安装mysql

Ubuntu中安装mysql

苏凯的博客 2681

MIT6.824-lab2D-2022(日志压缩详细讲解)

从paper中去讲解,并实现关于lab2D的代码。

幸平的博客 6038

CentOS 6.9 安装MySQL5.6 详细教程

最近项目需求要centos6.9安装mysql5.6网上找了下发现这哥们做的没毛病 1. 移除CentOS默认的mysql-libs [root@localhost etc]# whereis mysql mysql: /usr/lib64/mysql /usr/share/mysql [root@localhost etc]# yum remove mysql-libs 在此过程中如果出现 ...

会飞的程序猿的博客 1295

ADS基础教程22 - 有限元电磁仿真(FEM)

一、引言二、FEM操作过程1.新建Layout1.新建Layout2.EM设置3.设置Frequency plan4.设置Output plan5.设置Options6.设置网格频率7.仿真结果三、总结介绍了在ADS中如何进行FEM仿真过程。END!}}END!

XZ_ZC的博客 2584

android 蓝牙通讯demo

android 下蓝牙通讯demo,实现了发现蓝牙,使能蓝牙,通过蓝牙发送消息。

centos 6.9 mysql5.7_centos6.9安装mysql5.7

在centos 6.9 上rpm安装mysql环境:Linux:CentOS release 6.9 64bitMySQL: mysq-5.7.18安装前准备yum search libaio # 检索相关信息yum install libaio # 安装依赖包检查 MySQL 是否已安装yum list installed | grep mysql如果有,就先全部卸载,命令如下:yum -y ...

weixin_35784267的博客 168

文档:亲测可用解决vnc灰屏,黑屏,鼠标大黑叉情况

主要解决vnc-viewer灰屏,黑屏,鼠标大黑叉等现象,详细见文档。

centos6.9安装mysql_CentOS 6.9安装MySQL 5.1.73

分享在CentOS 6.9环境中安装MySQL 5.1.73 数据库,希望对大家有所帮助。1、确认mysql是否已安装,有下面的代码可知[root@cdh1 linuxidc]# yum list installed mysql*Loaded plugins: fastestmirror, refresh-packagekit, securityLoading mirror speeds from...

weixin_39669769的博客 276

OV9734 DATASHEET,完整规格书

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

深度学习工具包 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&#39;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(&#39;DeepLearnToolbox&#39;));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(&#39;state&#39;,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&#39;); % Visualize the RBM weights%% ex2 train a 100-100 hidden unit DBN and use its weights to initialize a NNrand(&#39;state&#39;,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 = &#39;sigm&#39;;%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, &#39;Too big error&#39;);```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(&#39;state&#39;,0)sae = saesetup([784 100]);sae.ae{1}.activation_function = &#39;sigm&#39;;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)&#39;)% Use the SDAE to initialize a FFNNnn = nnsetup([784 100 10]);nn.activation_function = &#39;sigm&#39;;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, &#39;Too big error&#39;);```Example: Convolutional Neural Nets---------------------```matlabfunction test_example_CNNload mnist_uint8;train_x = double(reshape(train_x&#39;,28,28,60000))/255;test_x = double(reshape(test_x&#39;,28,28,10000))/255;train_y = double(train_y&#39;);test_y = double(test_y&#39;);%% 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&#39;ll get around 1.2% errorrand(&#39;state&#39;,0)cnn.layers = { struct(&#39;type&#39;, &#39;i&#39;) %input layer struct(&#39;type&#39;, &#39;c&#39;, &#39;outputmaps&#39;, 6, &#39;kernelsize&#39;, 5) %convolution layer struct(&#39;type&#39;, &#39;s&#39;, &#39;scale&#39;, 2) %sub sampling layer struct(&#39;type&#39;, &#39;c&#39;, &#39;outputmaps&#39;, 12, &#39;kernelsize&#39;, 5) %convolution layer struct(&#39;type&#39;, &#39;s&#39;, &#39;scale&#39;, 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, &#39;Too big error&#39;);```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(&#39;state&#39;,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, &#39;Too big error&#39;);%% ex2 neural net with L2 weight decayrand(&#39;state&#39;,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, &#39;Too big error&#39;);%% ex3 neural net with dropoutrand(&#39;state&#39;,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, &#39;Too big error&#39;);%% ex4 neural net with sigmoid activation functionrand(&#39;state&#39;,0)nn = nnsetup([784 100 10]);nn.activation_function = &#39;sigm&#39;; % 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, &#39;Too big error&#39;);%% ex5 plotting functionalityrand(&#39;state&#39;,0)nn = nnsetup([784 20 10]);opts.numepochs = 5; % Number of full sweeps through datann.output = &#39;softmax&#39;; % 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, &#39;Too big error&#39;);%% 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(&#39;state&#39;,0)nn = nnsetup([784 20 10]); nn.output = &#39;softmax&#39;; % 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, &#39;Too big error&#39;);```[![Bitdeli Badge](https://d2weczhvl823v0.cloudfront.net/rasmusbergpalm/deeplearntoolbox/trend.png)](https://bitdeli.com/free "Bitdeli Badge")

centos6.9 安装mysql_centos6.9安装mysql5.7

在centos 6.9 上rpm安装mysql环境:Linux:CentOS release 6.9 64bitMySQL: mysq-5.7.181、在/home创建mysql目录,下载如下四个软件包http://mirrors.sohu.com/mysql/MySQL-5.7/wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-communit...

weixin_35343788的博客 237

CentOS6.5安装MySQL5.7.9

背景这几天有时间连接到我的阿里云上看了下,以前好像也没在上面做什么东西,索性这几天决心要搞,就从头来过,然后详细的记录下来,以后还可以回头再来看看.开始直接就操作了”重新初始化磁盘”,一切都是新的了,删掉了以前的快照.然后登陆进去 yum update 安装MySQL看了下yum库里面只有MySql5.1,太老了,google了一下,找到了mysql的官网,跟着操作一下: 下载含有yum库的rp

PennJ的专栏 1294

centos 6.9 mysql5.7_CentOS6.9安装Mysql5.7

CentOS6.9安装Mysql5.7一、上传安装包二、建立用户以及mysql的目录1、建立一个mysql的组输入命令: groupadd mysql2、建立mysql用户,并放到mysql组输入命令:useradd -r -g mysql mysql3、给mysql用户设置密码输入命令:passwd mysql三、解压Mysql1、把tar包复制一份到/usr/local/mysql 目录下2、...

weixin_28972687的博客 201

centos 6.9 mysql5.7_CentOS 6.9上安装Mysql 5.7.18 安装

CentOS 6.9上安装Mysql 5.7.18安装下载地址:https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.18-linux-glibc2.5-x86_64.tar.gz1、新建mysql用户,组:[root@001 ~]# groupadd mysql[root@001 ~]# useradd -g mysql -r -s /s...

weixin_34684705的博客 170

centos6.9 mysql5.7_CentOS6.9安装Mysql5.7

原标题:CentOS6.9安装Mysql5.7CentOS6.9安装Mysql5.7一、上传安装包 二、建立用户以及mysql的目录1、建立一个mysql的组输入命令: groupadd mysql2、建立mysql用户,并放到mysql组输入命令:useradd -r -g mysql mysql3、给mysql用户设置密码输入命令:passwd mysql 三、解压Mysql1、把tar包复制...

weixin_34396144的博客 213

CentOS6.9下安装MySQL5.7

CentOS6.9下安装MySQL5.7Yum方式安装卸载CentOS自带MySQL下载rpm文件选择安装版本安装MySQLMySQL启动修改MySQL密码配置MySQL设置开启自启rpm包形式安装卸载CentOS自带MySQL获取与上传安装包安装MySQLMySQL启动修改MySQL密码配置MySQL设置开启自启 在本文中,我们将使用Yum方式和rpm包的两种方式进行MySQL的安装。 Yum方式安装 卸载CentOS自带MySQL service mysqld stop rpm -qa | grep -

但行好事,莫问前程 1226

centos 6.9 mysql 5.6_CentOS 6.9上安装mysql-5.6.37

1、准备数据存放的文件系统新建一个逻辑卷,并将其挂载至特定目录即可。这里不再给出过程。这里假设其逻辑卷的挂载目录为/data,而后需要创建/data/mysqldata目录做为mysql数据的存放目录。[root@001 /]# mkdir -p /data/mysqldata2、新建用户以安全方式运行进程:[root@001 ~]# useradd mysql -s /sbin/nologin ...

weixin_42302872的博客 134
上一篇: java多线程中注入Spring对象使用@Autowird失败的问题
下一篇: centOs6.9修改yum源为国内镜像
code_deliverer
博客等级 码龄9年 1粉丝 2原创
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明:

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

余额充值