redhat6.5安装mysql8.0

一、到mysql官网下载mysql-8.0.11-1.el6.x86_64.rpm-bundle.tar

redhat6.5安装mysql8.0

使用rz -be (如果没安装，使用 yum install lrzsz安装)传到linux，tar -xvf mysql-8.0.11-1.el6.x86_64.rpm-bundle.tar解压

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

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

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

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

-rw-r--r-- 1 root root 1902676 Apr 9 01:06 mysql-community-libs-compat-8.0.11-1.el6.x86_64.rpm

-rw-r--r-- 1 root root 395918848 Apr 9 01:07 mysql-community-server-8.0.11-1.el6.x86_64.rpm

-rw-r--r-- 1 root root 49092596 Apr 9 01:07 mysql-community-test-8.0.11-1.el6.x86_64.rpm

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

[[email protected] ~]# rpm -ivh mysql-community-common-8.0.11-1.el6.x86_64.rpm

[[email protected] ~]# rpm -ivh mysql-community-libs-8.0.11-1.el6.x86_64.rpm

[[email protected] ~]# rpm -ivh mysql-community-libs-compat-8.0.11-1.el6.x86_64.rpm

[[email protected] ~]# rpm -e --nodeps mysql-libs-5.1.73-8.0.1.el6_8.x86_64

[[email protected] ~]# rpm -ivh mysql-community-libs-compat-8.0.11-1.el6.x86_64.rpm

[[email protected] ~]# rpm -ivh mysql-community-client-8.0.11-1.el6.x86_64.rpm

[[email protected] ~]# rpm -ivh mysql-community-server-8.0.11-1.el6.x86_64.rpm

[[email protected] ~]# rpm -ivh mysql-community-devel-8.0.11-1.el6.x86_64.rpm

[[email protected] ~]# rpm -ivh mysql-community-test-8.0.11-1.el6.x86_64.rpm

如果有如下错误，使用yum安装

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

类似perl(JSON) 使用yum install perl-JSON格式安装

[[email protected] ~]#yum install perl-JSON

三、安装完毕后相关信息如下：

[[email protected] ~]# mysql -V

mysql Ver 8.0.11 for Linux on x86_64 (MySQL Community Server - GPL)

[[email protected] ~]# ll /etc/init.d/mysqld

-rwxr-xr-x 1 root root 7166 Apr 8 16:21 /etc/init.d/mysqld

[[email protected] ~]# ll /etc/my.cnf --配置文件位置

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

默认的datadir是在/var/lib/mysql/，可以通过修改my.cnf修改，启动命令如下：[[email protected] ~]# service mysqld start

Initializing MySQL database: [ OK ]

Starting mysqld: [ OK ]

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

mysql> alter user [email protected]'localhost' identified by 'mysql';

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

这个时候我们只需要flush privileges 一下，在添加用户就OK了，

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)

mysql> alter user [email protected]'localhost' identified by 'mysql';

Query OK, 0 rows affected (0.00 sec)

终于改完密码了...去掉参数文件的skip-grant-tables参数，service mysqld restart重启服务。

##添加远程特账号

mysql> create user leo identified by '123456';

Query OK, 0 rows affected (0.08 sec)

mysql> grant all privileges on *.* to leo';

Query OK, 0 rows affected (0.04 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)

开放Linux端口

cd /sbin

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

/etc/rc.d/init.d/iptables save #保存配置

/etc/rc.d/init.d/iptables restart #重启服务

然后就可以远程连接了

redhat6.5安装mysql8.0

相关推荐