CentOS 7.4 64位安装配置MySQL8.0的详细步骤

第一步:获取mysql YUM源

进入mysql官网获取RPM包下载地址

https://dev.mysql.com/downloads/repo/yum/

点击下载

获取到下载链接:

https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm

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

第二步:下载和安装mysql源

•进入mysql文件夹,没有的自行创建

[root@VM_0_10_centos /]# cd /usr/local/mysql/
[root@VM_0_10_centos mysql]#

•下载源安装包

[root@VM_0_10_centos mysql]# wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
--2018-08-04 10:29:39-- https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)... 23.219.33.198
Connecting to repo.mysql.com (repo.mysql.com)|23.219.33.198|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 25820 (25K) [application/x-redhat-package-manager]
Saving to: ‘mysql80-community-release-el7-1.noarch.rpm'
100%[==========================================================================>] 25,820 112KB/s in 0.2s
2018-08-04 10:29:40 (112 KB/s) - ‘mysql80-community-release-el7-1.noarch.rpm' saved [25820/25820]
[root@VM_0_10_centos mysql]# ll
total 28
-rw-r--r-- 1 root root 25820 Apr 18 13:24 mysql80-community-release-el7-1.noarch.rpm
[root@VM_0_10_centos mysql]#

•安装mysql源

[root@VM_0_10_centos mysql]# yum -y localinstall mysql80-community-release-el7-1.noarch.rpm

第三步:在线安装MySQL

[root@VM_0_10_centos mysql]# yum -y install mysql-community-server

下载东西比较多,等几分钟。

第四步:启动Mysql服务

[root@VM_0_10_centos mysql]# systemctl start mysqld

第五步:设置开机启动

[root@VM_0_10_centos mysql]# systemctl enable mysqld
[root@VM_0_10_centos mysql]# systemctl daemon-reload

第六步:修改root本地登录密码

mysql安装完成之后,在/var/log/mysqld.log文件中给root生成了一个临时的默认密码。用grep命令搜一下

[root@VM_0_10_centos mysql]# grep "A temporary password is generated for root@localhost" /var/log/mysqld.log
2018-08-02T02:19:55.829527Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: !J:KUwU9y0ZR
2018-08-02T04:49:34.979689Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: pw</s9,Wivm2
2018-08-04T02:40:46.781768Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: nNyK,Y)Wd0-G
[root@VM_0_10_centos mysql]#

这里有三条搜索结果,因为我重复装了3次MySQL,如果第一次安装是只会有一条的。

直接拿到临时默认密码 : nNyK,Y)Wd0-G

•登录MySQL

[root@VM_0_10_centos 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.12
Copyright (c) 2000, 2018, 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>

•更改root账户临时密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pwd123@easyoh.net';
Query OK, 0 rows affected (0.03 sec)
mysql>

Pwd123@easyoh.net 请替换成你自己的密码。

(备注 mysql8.0默认密码策略要求密码必须是大小写字母数字特殊字母的组合,至少8位)

第七步:创建新用户、授权、远程登录(不要直接使用root账户登录)

•创建easyoh-mp用户并且授权远程登录

mysql> CREATE USER 'easyoh-mp'@'%' IDENTIFIED BY 'Pwd123@easyoh.net';
Query OK, 0 rows affected (0.04 sec)
mysql> GRANT ALL ON *.* TO 'easyoh-mp'@'%';
Query OK, 0 rows affected (0.03 sec)
mysql>

•在sqlyog客户端用easyoh-mp账户登录(其他客户端也可以,随意)

发现会报plugin caching_sha2_password错误。这是因为MySQL8.0密码策略默认为caching_sha2_password。与5.7有所不同。

•进入MySQL数据库查询user表信息

mysql> use mysql;
Database changed
mysql> select user,host,plugin from user;
+------------------+-----------+-----------------------+
| user  | host | plugin  |
+------------------+-----------+-----------------------+
| easyoh-mp | %  | caching_sha2_password |
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session | localhost | caching_sha2_password |
| mysql.sys | localhost | caching_sha2_password |
| root  | localhost | caching_sha2_password |
+------------------+-----------+-----------------------+
5 rows in set (0.00 sec)
mysql>

发现确实是caching_sha2_password

•依次执行下面语句

mysql> ALTER USER 'easyoh-mp'@'%' IDENTIFIED BY 'Pwd123@easyoh.net' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.04 sec)
mysql> ALTER USER 'easyoh-mp'@'%' IDENTIFIED WITH mysql_native_password BY 'Pwd123@easyoh.net';
Query OK, 0 rows affected (0.05 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
mysql>

再次登录就可以登录成功了。

第8步:编码

mysql> show variables like '%character%';
+--------------------------+--------------------------------+
| Variable_name  | Value    |
+--------------------------+--------------------------------+
| character_set_client | utf8mb4   |
| character_set_connection | utf8mb4   |
| character_set_database | utf8mb4   |
| character_set_filesystem | binary    |
| character_set_results | utf8mb4   |
| character_set_server | utf8mb4   |
| character_set_system | utf8    |
| character_sets_dir | /usr/share/mysql-8.0/charsets/ |
+--------------------------+--------------------------------+
8 rows in set (0.01 sec)
mysql>

MySQL8.0默认就是utf8mb4编码,无需更改。

OK 至此 Mysql安装配置完毕;

全流程操作记录

[root@VM_0_10_centos ~]#
[root@VM_0_10_centos /]# cd /usr/local/mysql/
[root@VM_0_10_centos mysql]# wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
--2018-08-04 10:29:39-- https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
Resolving repo.mysql.com (repo.mysql.com)... 23.219.33.198
Connecting to repo.mysql.com (repo.mysql.com)|23.219.33.198|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 25820 (25K) [application/x-redhat-package-manager]
Saving to: ‘mysql80-community-release-el7-1.noarch.rpm'
100%[==========================================================================>] 25,820 112KB/s in 0.2s
2018-08-04 10:29:40 (112 KB/s) - ‘mysql80-community-release-el7-1.noarch.rpm' saved [25820/25820]
[root@VM_0_10_centos mysql]# ll
total 28
-rw-r--r-- 1 root root 25820 Apr 18 13:24 mysql80-community-release-el7-1.noarch.rpm
[root@VM_0_10_centos mysql]# yum -y localinstall mysql80-community-release-el7-1.noarch.rpm
Loaded plugins: fastestmirror, langpacks
Examining mysql80-community-release-el7-1.noarch.rpm: mysql80-community-release-el7-1.noarch
Marking mysql80-community-release-el7-1.noarch.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql80-community-release.noarch 0:el7-1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=================================================================================================================================================================================================================
 Package       Arch     Version    Repository        Size
=================================================================================================================================================================================================================
Installing:
 mysql80-community-release    noarch    el7-1     /mysql80-community-release-el7-1.noarch    31 k
Transaction Summary
=================================================================================================================================================================================================================
Install 1 Package
Total size: 31 k
Installed size: 31 k
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
 Installing : mysql80-community-release-el7-1.noarch                   1/1
 Verifying : mysql80-community-release-el7-1.noarch                   1/1
Installed:
 mysql80-community-release.noarch 0:el7-1
Complete!
[root@VM_0_10_centos mysql]# yum -y install mysql-community-server
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
epel                         12641/12641
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.12-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.12-1.el7 for package: mysql-community-server-8.0.12-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.0 for package: mysql-community-server-8.0.12-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.12-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.0 for package: mysql-community-client-8.0.12-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.12-1.el7 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:8.0.12-1.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
=================================================================================================================================================================================================================
 Package       Arch     Version      Repository      Size
=================================================================================================================================================================================================================
Installing:
 mysql-community-server     x86_64     8.0.12-1.el7     mysql80-community     349 M
Installing for dependencies:
 mysql-community-client     x86_64     8.0.12-1.el7     mysql80-community     26 M
 mysql-community-common     x86_64     8.0.12-1.el7     mysql80-community     541 k
 mysql-community-libs     x86_64     8.0.12-1.el7     mysql80-community     2.2 M
Transaction Summary
=================================================================================================================================================================================================================
Install 1 Package (+3 Dependent packages)
Total download size: 377 M
Installed size: 1.7 G
Downloading packages:
(1/4): mysql-community-common-8.0.12-1.el7.x86_64.rpm                 | 541 kB 00:00:05
(2/4): mysql-community-client-8.0.12-1.el7.x86_64.rpm                 | 26 MB 00:00:12
(3/4): mysql-community-server-8.0.12-1.el7.x86_64.rpm                 | 349 MB 00:02:26
(4/4): mysql-community-libs-8.0.12-1.el7.x86_64.rpm                 | 2.2 MB 00:03:37
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                      1.7 MB/s | 377 MB 00:03:43
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
 Installing : mysql-community-common-8.0.12-1.el7.x86_64                   1/4
 Installing : mysql-community-libs-8.0.12-1.el7.x86_64                   2/4
 Installing : mysql-community-client-8.0.12-1.el7.x86_64                   3/4
 Installing : mysql-community-server-8.0.12-1.el7.x86_64                   4/4
 Verifying : mysql-community-common-8.0.12-1.el7.x86_64                   1/4
 Verifying : mysql-community-libs-8.0.12-1.el7.x86_64                   2/4
 Verifying : mysql-community-client-8.0.12-1.el7.x86_64                   3/4
 Verifying : mysql-community-server-8.0.12-1.el7.x86_64                   4/4
Installed:
 mysql-community-server.x86_64 0:8.0.12-1.el7
Dependency Installed:
 mysql-community-client.x86_64 0:8.0.12-1.el7    mysql-community-common.x86_64 0:8.0.12-1.el7    mysql-community-libs.x86_64 0:8.0.12-1.el7
Complete!
[root@VM_0_10_centos mysql]# systemctl start mysqld
[root@VM_0_10_centos mysql]# systemctl enable mysqld
[root@VM_0_10_centos mysql]# systemctl daemon-reload
[root@VM_0_10_centos mysql]# grep "A temporary password is generated for root@localhost" /var/log/mysqld.log
2018-08-02T02:19:55.829527Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: !J:KUwU9y0ZR
2018-08-02T04:49:34.979689Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: pw</s9,Wivm2
2018-08-04T02:40:46.781768Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: nNyK,Y)Wd0-G
[root@VM_0_10_centos 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.12
Copyright (c) 2000, 2018, 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> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Pwd123@easyoh.net';
Query OK, 0 rows affected (0.03 sec)
mysql> CREATE USER 'easyoh-mp'@'%' IDENTIFIED BY 'Pwd123@easyoh.net';
Query OK, 0 rows affected (0.04 sec)
mysql> GRANT ALL ON *.* TO 'easyoh-mp'@'%';
Query OK, 0 rows affected (0.03 sec)
mysql> use mysql;
Database changed
mysql> select user,host,plugin from user;
+------------------+-----------+-----------------------+
| user  | host | plugin  |
+------------------+-----------+-----------------------+
| easyoh-mp | %  | caching_sha2_password |
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session | localhost | caching_sha2_password |
| mysql.sys | localhost | caching_sha2_password |
| root  | localhost | caching_sha2_password |
+------------------+-----------+-----------------------+
5 rows in set (0.00 sec)
mysql> ALTER USER 'easyoh-mp'@'%' IDENTIFIED BY 'Pwd123@easyoh.net' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.04 sec)
mysql> ALTER USER 'easyoh-mp'@'%' IDENTIFIED WITH mysql_native_password BY 'Pwd123@easyoh.net';
Query OK, 0 rows affected (0.05 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)
mysql> show variables like '%character%';
+--------------------------+--------------------------------+
| Variable_name  | Value    |
+--------------------------+--------------------------------+
| character_set_client | utf8mb4   |
| character_set_connection | utf8mb4   |
| character_set_database | utf8mb4   |
| character_set_filesystem | binary    |
| character_set_results | utf8mb4   |
| character_set_server | utf8mb4   |
| character_set_system | utf8    |
| character_sets_dir | /usr/share/mysql-8.0/charsets/ |
+--------------------------+--------------------------------+
8 rows in set (0.01 sec)

这里有个问题,新密码设置的时候如果设置的过于简单会报错:

原因是因为MySQL有密码设置的规范,具体是与validate_password_policy的值有关:

MySQL完整的初始密码规则可以通过如下命令查看:

mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+-------+
| Variable_name   | Value |
+--------------------------------------+-------+
| validate_password_check_user_name | OFF |
| validate_password_dictionary_file | |
| validate_password_length  | 4 |
| validate_password_mixed_case_count | 1 |
| validate_password_number_count | 1 |
| validate_password_policy  | LOW |
| validate_password_special_char_count | 1 |
+--------------------------------------+-------+
7 rows in set (0.01 sec)

密码的长度是由validate_password_length决定的,而validate_password_length的计算公式是:

validate_password_length = validate_password_number_count + validate_password_special_char_count + (2 * validate_password_mixed_case_count)

我的是已经修改过的,初始情况下第一个的值是ON,validate_password_length是8。可以通过如下命令修改:

mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;

总结

以上所述是小编给大家介绍的CentOS 7.4 64位安装配置MySQL8.0的详细步骤,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对我们网站的支持!

时间: 2018-10-15

在阿里云的CentOS环境中安装配置MySQL的教程

1 常规错误的yum安装方法: 在前文中记述了CentOS 6.5系统中通过yum方式快速地搭建了LNMP环境,那么是否也能在CentOS 7或CentOS 7.1系统中依葫芦画瓢安装MySql5.6.24呢?答案是否定的. [root@typecodes ~]# yum -y install mysql mysql-server mysql-devel ...................... ....省略部分安装过程.... ...................... Installe

centos6.4下mysql5.7.18安装配置方法图文教程

centos6.4下安装mysql5.7.18的具体步骤,分享给大家. 1.首先检查是否已经安装过mysql,查找mysql相关软件rpm包 #rpm -qa | grep mysql 2.将所有与mysql相关的东西删除 #yum -y remove mysql-libs-5.1.66-2.el6_3.x86_64 3.安装依赖包 #yum -y install make gcc-c++ cmake bison-devel ncurses-devellibaio libaio-devel 4.

CentOS 7.2下MySQL的安装与相关配置

一.相关配置如下 操作系统: CentOS 7.2 MySQL版本: 5.7.x 二.下载安装 2.1 下载rpm包 选择相应的版本:系统版本和包版本. 系统版本可以通过 uname -a 来查看: wget http://repo.mysql.com//mysql57-community-release-el7-9.noarch.rpm 2.2 下载安装软件源 sudo yum localinstall platform-and-version-specific-package-name.rp

Centos中安装多个mysql数据的配置实例

注:本文档做了两个MYSQL实例,多个实例方法以此类推 LINUX操作系统:centOS6.3 64bit(安装了系统默认开发包)数据库一:MYSQL版本:mysql-5.0.56PORT:3306系统目录:/usr/local/mysql3306数据库二:MYSQL版本:mysql-5.1.72PORT:3307系统目录:/usr/local/mysql3307 一.安装开发包(使用默认CENTOS更新源): 复制代码 代码如下: # yum -y install wget gcc-c++ n

CentOS 5.4 服务器配置 yum安装Apache+php+Mysql

中国官方镜像网站: http://centos.ustc.edu.cn/ /* 使用说明 */ cd /etc/yum.repos.d[进入yum.repos.d目录] mv CentOS-Base.repo CentOS-Base.repo.save[修改源文件名称备份] wget http://centos.ustc.edu.cn/CentOS-Base.repo.5[下载] mv CentOS-Base.repo.5 CentOS-Base.repo[下载后的文件更名] 1. 更新系统内核

CentOS 6.4安装配置LNMP服务器(Nginx+PHP+MySQL)

准备篇 1.配置防火墙,开启80端口.3306端口vi /etc/sysconfig/iptables-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT #允许80端口通过防火墙-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT #允许3306端口通过防火墙 备注:很多网友把这两条规则添加到防火墙配置的最后一行,导致防火墙启动失败, 正确

在CentOS 7下使用yum配置MySQL源并安装MySQL

CentOS7默认数据库是mariadb,配置等用着不习惯,因此决定改成mysql,但是CentOS7的yum源中默认好像是没有mysql的.为了解决这个问题,我们要先下载mysql的repo源. 1.由于CentOS 的yum源中没有mysql,需要到mysql的官网下载yum repo配置文件. wget http://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm 2.安装yum repo文件 rpm -ivh my

CentOS6.5 上部署 MySQL5.7.17 二进制安装以及多实例配置

1.建用户.下载.解压 groupadd mysql useradd -r -g mysql mysql wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz tar xvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz -C /usr/local/ ln -sv /usr/local/mysql-5.7.17-linux-gli

CentOS 6.4安装配置LAMP服务器(Apache+PHP5+MySQL)

准备篇: 1.配置防火墙,开启80端口.3306端口vi /etc/sysconfig/iptables-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT #允许80端口通过防火墙-A INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT #允许3306端口通过防火墙 备注:很多网友把这两条规则添加到防火墙配置的最后一行,导致防火墙启动失败, 正

mysql 5.7.17 安装配置方法图文教程(CentOS7)

CentOS7安装mysql笔记 1 CentOS7默认安装mariadb数据库,卸载mariadb. rpm -qa|grep mariadb yum remove mariadb-libs.x86_64 2 配置YUM源 1)下载mysql源安装包 wget http://xiazai.jb51.net/201612/yuanma/mysql57YUM(jb51.net).rar 2)安装mysql源 yum localinstall mysql57-community-release-el

mysql 5.7.17 安装配置方法图文教程(windows10)

mysql 5.7.17 安装配置方法整理 第一步 到MySQL官网下载mysql-5.7.17-winx64.zip 第二步 解压缩 mysql-5.7.17-winx64.zip 第三步 新建一个my.ini文件,然后用记事本打开输入mysql的基本配置: [mysql] ; 设置mysql客户端默认字符集 default-character-set=utf8 [mysqld] ;设置3306端口 port = 3306 ; 设置mysql的安装目录 basedir=E:\mysql5.7

mysql 8.0.17 安装配置方法图文教程

本文为大家分享了mysql 8.0.17 安装配置方法,供大家参考,具体内容如下 安装程序下载: 首先是登录MySQL的官网,下载MySQL 8.0.17的安装包.官网地址:https://www.mysql.com/ 打开MySQL官网后,在出现的页面上,点击DOWNLOADS按钮: 在跳出的页面中,再点击Community,如下图所示: 接下来,我们来到 MySQL Community下载页面,我们找到MySQL Community Server,并点击下载按钮,如下图所示: 点击完DOWN

mysql 5.7.17 安装配置方法图文教程

本文为大家分享了mysql5.7.17安装配置方法,供大家参考,具体内容如下 1.下载 MySQL 数据库的安装包:mysql-5.7.17.msi.下载完成之后,双击打开此msi文件,进入如下界面: 标注1:安装所有 MySQL 数据库需要的产品:标注2:仅仅使用 MySQL 数据库的服务器:标注3:仅仅使用 MySQL 数据库的客户端:标注4:安装所有包含 MySQL 数据库的产品:标注5:手动选择需要安装的 MySQL 数据库的产品.在此,咱们只需要选择 标注2 所示的Server onl

mysql 5.7.17 安装配置方法图文教程(ubuntu 16.04)

在MySQL官网上下载最新版的Ubuntu Linux专用的MySQL.我这里下载的是: mysql-server_5.7.17-1ubuntu16.04_amd64.deb-bundle.tar 也可从以下mirrors下载: http://mirrors.sohu.com/mysql/MySQL-5.7/ 解压文件 命令为: 复制代码 代码如下: root@ubuntu:/fly/mysql# tar -xvf ../mysql-server_5.7.17-1ubuntu16.04_amd6

Windows10下mysql 5.7.17 安装配置方法图文教程

在此文中,我将详细讲解如何在Windows10平台中安装MySQL数据库的最新版本,即MySQL5.7.17压缩版数据库. 关于MySQL5.7.17数据库压缩版的下载,我就不在此多言了.有人不会,请自己动手,丰衣足食! 解压并安装 由于我们下载的MySQL5.7.17数据库是ZIP Archive版的,也即压缩版,所以只要解压就可以了,和安装版的没什么不同,但就是不需要安装.我们只需找到下载好的mysql-5.7.17-winx64.zip文件,然后右键选择,解压到你想安装的地方,喜欢放C盘的

mysql 5.7.17 安装配置方法图文教程(windows)

一.下载软件 1. 进入mysql官网,登陆自己的Oracle账号(没有账号的自己注册一个),下载Mysql-5.7.17,下载地址:http://dev.mysql.com/downloads/mysql/ 2.将下载好的文件解压到指定目录,解压在E:/mysql-5.7.17-winx64 二.安装过程  1.首先配置环境变量path,将E:/mysql-5.7.17-winx64/bin配置到自己的path中 环境变量 MySql_HOME===================E:/mys

CentOS6.9下mysql 5.7.17安装配置方法图文教程

CentOS6.9安装Mysql5.7,供大家参考,具体内容如下 一.上传安装包 二.建立用户以及mysql的目录 1.建立一个mysql的组 输入命令: groupadd mysql 2.建立mysql用户,并放到mysql组 输入命令:useradd -r -g mysql mysql 3.给mysql用户设置密码 输入命令:passwd mysql 三.解压Mysql 1.把tar包复制一份到/usr/local/mysql 目录下 2.解压 tar -zxvf mysql.tar 3.把

Mac下mysql 5.7.17 安装配置方法图文教程

一.下载MySQL 官网下载页面点击后进入如下页面 按图操作即可,接下来: 二.安装和配置 安装按照步骤来即可.但是要记住最后的初始密码. 最后我们在电脑的系统偏好设置里面可以看见安装的MySQL   默认MySQL是启动的. 在打开之前我们需要在终端中配置一下. PATH="$PATH":/usr/local/mysql/bin mysql -u root -p #输入密码 #Terminal显示 #Welcome to the MySQL monitor. Commands end

mysql 5.7.18 安装配置方法图文教程(CentOS7)

介绍如何在Linux下安装MySQL 5.7.18 1.下载MySQL:官网https://www.mysql.com/,点击Downlosas,翻到网页底部,下载社区版,一路点下去,选择通用Linux,下载64位那个,注意检查MD5 值. 2.安装关键步骤,直接贴出命令 [cpp] view plain copy 在CODE上查看代码片派生到我的代码片 [root@CentOS MySQL]# tar -xzvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.g