设为首页 加入收藏

TOP

RHEL6.6下MySQL8.0安装配置初体验(一)
2018-11-20 22:09:07 】 浏览:224
Tags:RHEL6.6 MySQL8.0 安装 配置 体验

MySQL8.0的官方社区开源版出来有段时间了,而percona的8.0版本还没有正式对外发布(已发布测试版),一直以来也没安装体验下这个号称质的飞跃的版本,今天正好有些时间就下了安装体验体验。


一、MySQL8.0下载


下载地址:https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz


二、安装环境


三、MySQL8.0安装


官方参考:https://dev.mysql.com/doc/refman/8.0/en/binary-installation.html


1.软件下载


[root@node tools]# wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz


2.依赖包安装


[root@node mysql]# yum search libaio
[root@node mysql]# yum install libaio
3.用户创建
[root@node mysql]# groupadd mysql
[root@node mysql]# useradd -r -g mysql -s /bin/false mysql


4.解压缩安装包


[root@node mysql]# cd /usr/local
[root@node mysql]# tar -xvf mysql-8.0.13-linux-glibc2.12-x86_64.tar.xz


5.规划软件和数据文件目录
[root@node tools]# mv mysql-8.0.13-linux-glibc2.12-x86_64 /usr/local/mysql
[root@node mysql]# cd /usr/local/mysql
[root@node mysql]# mkdir -p /data/mysql/data


6.修改属主权限
[root@node mysql]# chown -R mysql:mysql /data/mysql/data
[root@node mysql]# chmod -R 750 /data/mysql/data


7.数据库初始化
[root@node mysql]# bin/mysqld --initialize --user=mysql  --datadir=/data/mysql/data
2018-11-12T02:49:23.293863Z 0 [System] [MY-013169] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) initializing of server in progress as process 24839
2018-11-12T02:49:26.840424Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Vxxx1n%Mj7uZ
2018-11-12T02:49:29.671663Z 0 [System] [MY-013170] [Server] /usr/local/mysql/bin/mysqld (mysqld 8.0.13) initializing of server has completed


8.ssl部署
[root@node mysql]# bin/mysql_ssl_rsa_setup
Generating a 2048 bit RSA private key
.......+++
............................+++
writing new private key to 'ca-key.pem'
-----
Generating a 2048 bit RSA private key
...........................................+++
..+++
writing new private key to 'server-key.pem'
-----
Generating a 2048 bit RSA private key
..................................................................+++
...................+++
writing new private key to 'client-key.pem'
-----


9.启动数据库
[root@node mysql]# bin/mysqld_safe --user=mysql --datadir=/data/mysql/data &
[1] 25195
[root@node mysql]# Logging to '/data/mysql/data/node.err'.
2018-11-12T02:51:59.390239Z mysqld_safe Starting mysqld daemon with databases from /data/mysql/data


10.连接数据库
[root@node mysql]# mysql -uroot -p'Vjk01n%Mj7uZ'  -hlocalhost

mysql> select user,host from mysql.user;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.


11.修改数据库初始密码


mysql> alter user root@'localhost' identified by 'xxxx';
Query OK, 0 rows affected (0.07 sec)


12.数据库查询
mysql> select user,host from mysql.user;   
+------------------+-----------+
| user            | host      |
+------------------+-----------+
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root            | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)


13.MySQL启动服务配置
[root@node mysql]# cp -rp support-files/mysql.server  /etc/init.d/mysqld


[root@node data]# chkconfig  --add mysqld
[root@node mysql]# vi /etc/my.cnf


[root@node ~]# vi /root/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/

首页 上一页 1 2 下一页 尾页 1/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇SQL优化指南 下一篇Last_IO_Error: Got fatal error ..

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目