MySql 8.0.11安装配置教程

MySql 8.0.11安装配置教程安装配置教程

给大家介绍了MySql 8.0.11安装配置教程，本文给大家介绍的非常详细，具有一定的参考借鉴价值，感兴趣的朋友一起看看吧

官网地址：https://dev.mysql.com/downloads/mysql/

我这里是RHEL6.5的系统，因此选择RedHat 6 x86,64bit操作系统---下载第一个RPM Bundle即可--mysql-8.0.11-1.el6.x86_64.rpm-bundle.tar。

目前MySQL8.0.11社区版提供了多种多样的安装方式，但是并未发现针对Linux Generic安装包包含的mysql_secure_installation的安装说明。

因此这里使用推荐的RPM安装：

一、一、mysql-8.0.11-1.el6.x86_64.rpm-bundle.tar解压后有如下解压后有如下7个文件：个文件：

-rw-r--r-- 1 root root 28987588 Apr 9 01:06 mysql-community-client-8.0.11-1.el6.x86_64.rpm

然后创建mysql用户：

useradd mysql

passwd mysql

二、安装顺序为：（建议装之前先把之前的二、安装顺序为：（建议装之前先把之前的mysql相关包全部卸载，相关包全部卸载，rpm -e --nodeps <包名包名>即可）即可）

[root@python ~]# rpm -ivh mysql-community-common-8.0.11-1.el6.x86_64.rpm

warning: mysql-community-common-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

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

1:mysql-community-common ########################################### [100%]

[root@python ~]# rpm -ivh mysql-community-libs-8.0.11-1.el6.x86_64.rpm

warning: mysql-community-libs-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

file /usr/lib64/mysql/libmysqlclient_r.so.16.0.0 from install of mysql-community-libs-compat-8.0.11-1.el6.x86_64 conflicts with file from package mysql-libs-5.1.73-8.0.1.el6_8.x86_64

[root@python ~]# rpm -e --nodeps mysql-libs-5.1.73-8.0.1.el6_8.x86_64

[root@python ~]# rpm -ivh mysql-community-libs-compat-8.0.11-1.el6.x86_64.rpm

warning: mysql-community-libs-compat-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

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

1:mysql-community-libs-co########################################### [100%]

[root@python ~]# rpm -ivh mysql-community-server-8.0.11-1.el6.x86_64.rpm

warning: mysql-community-server-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

error: Failed dependencies:

mysql-community-client(x86-64) >= 8.0.0 is needed by mysql-community-server-8.0.11-1.el6.x86_64

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

1:mysql-community-server ########################################### [100%]

[root@python ~]# rpm -ivh mysql-community-devel-8.0.11-1.el6.x86_64.rpm

warning: mysql-community-devel-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

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

1:mysql-community-devel ########################################### [100%]

^[[A[root@python ~]# rpm -ivh mysql-community-test-8.0.11-1.el6.x86_64.rpm

warning: mysql-community-test-8.0.11-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

error: Failed dependencies:

perl(JSON) is needed by mysql-community-test-8.0.11-1.el6.x86_64

[root@python ~]# ll /etc/my.cnf --配置文件位置

-rw-r--r-- 1 root root 1188 Apr 8 16:21 /etc/my.cnf

默认的datadir是在/var/lib/mysql/，可以通过修改my.cnf修改，启动命令如下：

[root@python ~]# service mysqld start

Initializing MySQL database: [ OK ]

Starting mysqld:

[ OK ]

四、发现没密码不能登录，于是添加四、发现没密码不能登录，于是添加skip-grant-tables到到my.cnf，重启进去重置密码，重启进去重置密码

mysql> alter user root@'localhost' identified by 'mysql';

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

Query OK, 0 rows affected (0.00 sec)

mysql> create user root@'localhost' identified by 'mysql';