内容简介:说 MySQL 8 的性能比 MySQL 5.7 性能提高了 2 倍,又,自己很久没用过 MySQL 了,于是想着试试首先需要解决 CentOS 6 上安装的问题,看到这个文章,这里介绍的是通过 yum 源的方式来安装的,但是这个方式不太行,内网的网络限制了,于是只能走预先下载 rpm 包的方式来了
说 MySQL 8 的性能比 MySQL 5.7 性能提高了 2 倍,又,自己很久没用过 MySQL 了,于是想着试试
首先需要解决 CentOS 6 上安装的问题,看到这个文章, https://www.tecmint.com/instal…
这里介绍的是通过 yum 源的方式来安装的,但是这个方式不太行,内网的网络限制了,于是只能走预先下载 rpm 包的方式来了
一共需要这几个包:
mysql-community-server-8.0.13-1.el6.x86_64.rpm
mysql-community-client-8.0.13-1.el6.x86_64.rpm
mysql-community-common-8.0.13-1.el6.x86_64.rpm
mysql-community-libs-8.0.13-1.el6.x86_64.rpm
通过 rpm -ivh 来安装
rpm -ivh mysql-community-common-8.0.13-1.el6.x86_64.rpm rpm -ivh mysql-community-libs-8.0.13-1.el6.x86_64.rpm rpm -ivh mysql-community-client-8.0.13-1.el6.x86_64.rpm
安装到 client 的时候报错,说
Preparing... ########################################### [100%] file /usr/bin/mysql from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/bin/mysqladmin from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/bin/mysqlbinlog from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/bin/mysqlcheck from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/bin/mysqldump from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/bin/mysqlimport from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/bin/mysqlshow from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/bin/mysqlslap from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/share/man/man1/mysql.1.gz from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/share/man/man1/mysqladmin.1.gz from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/share/man/man1/mysqldump.1.gz from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/share/man/man1/mysqlshow.1.gz from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/share/man/man1/mysqlslap.1.gz from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-5.1.71-1.el6.x86_64 file /usr/share/man/man1/mysqlbinlog.1.gz from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-server-5.1.71-1.el6.x86_64 file /usr/share/man/man1/mysqlcheck.1.gz from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-server-5.1.71-1.el6.x86_64 file /usr/share/man/man1/mysqlimport.1.gz from install of mysql-community-client-8.0.13-1.el6.x86_64 conflicts with file from package mysql-server-5.1.71-1.el6.x86_64
感觉是要卸载掉机上旧的 MySQL 版本才行
yum -y remove mysql-5.1.71* yum -y remove mysql-server-5.1.71* yum -y remove mysql-libs-5.1.71*
又,每次执行 yum 总是试着连 aliyun 的源,但是又 Timeout,于是得把这个源干掉才行
[root@localhost etc]# mkdir yum-bak [root@localhost etc]# mv yum.repos.d/* yum-bak/
最后安装 server
rpm -ivh mysql-community-server-8.0.13-1.el6.x86_64.rpm
装好了,就得启动起来
[root@localhost ~]# service mysqld start Initializing MySQL database: [FAILED]
发现挂了。。。但是再试一次,就好了。。
[root@localhost ~]# service mysqld start Starting mysqld: [ OK ]
然后要看下自动生成的临时密码
[root@localhost ~]# grep 'temporary password' /var/log/mysqld.log 2018-12-28T12:51:28.990464Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: drC&dCOp0tep
然后用 mysql_secure_installation 来进行一些安全的初始化,在这个过程中会要求你重置自己的 MySQL 密码
最终,终于能连上了
[root@localhost ~]# mysql -u root -p mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.13 | +-----------+ 1 row in set (0.00 sec)
然后新建用户
CREATE USER 'testuser'@'%' IDENTIFIED BY '123456@Test'; GRANT ALL ON *.* TO 'testuser'@'%';
但是连接的时候报错,需要重新指定一个简单的密码加密方式:
ALTER USER 'testuser'@'%' IDENTIFIED WITH mysql_native_password BY '123456@Test';
压测使用的是 sysbench-1.0.9-2.el6.x86_64.rpm
以上就是本文的全部内容,希望本文的内容对大家的学习或者工作能带来一定的帮助,也希望大家多多支持 码农网
猜你喜欢:- Flutter 学习之路 - 测试(单元测试,Widget 测试,集成测试)
- itest(爱测试)接口测试&敏捷测试管理 7.7.7 发布,接口测试重大升级
- 性能测试vs压力测试vs负载测试
- SpringBoot | 第十三章:测试相关(单元测试、性能测试)
- 敏捷测试VS传统测试对比,6招玩转敏捷测试!
- itest(爱测试)接口测试&敏捷测试管理平台 8.1.0 发布
本站部分资源来源于网络,本站转载出于传递更多信息之目的,版权归原作者或者来源机构所有,如转载稿涉及版权问题,请联系我们。