CentOS7.2下安装MySQL-5.7.18RPM Bundle版(适用于最新版5.7.20)
来源:互联网 发布:csgo数据互换器永久 编辑:程序博客网 时间:2024/06/10 04:19
一、环境
1、操作系统:CentOS Linux release 7.2.1511 (Core) 最小化安装版
2、MySQL版本:MySQL-5.7.18(mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar)
二、安装过程
1、安装wget。
[root@Geeklp-MySQL ~]# yum -y install wget
2、下载安装包。
wget -c http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.18-1.el5.i686.rpm-bundle.tar
3、解包。
[root@Geeklp-MySQL ~]# tar -xf mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar
4、按照以下脚本顺序安装各rpm包及其他依赖包。
#!/bin/bashyum -y install net-toolstar -xf mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar &yum -y remove mariadb-libsrpm -ivh mysql-community-common-5.7.18-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-5.7.18-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-5.7.18-1.el7.x86_64.rpmrpm -ivh mysql-community-client-5.7.18-1.el7.x86_64.rpmyum -y install perl-Getopt-Longrpm -ivh mysql-community-server-5.7.18-1.el7.x86_64.rpm yum -y install perl-Data-Dumperyum -y install perl-JSONrpm -ivh mysql-community-test-5.7.18-1.el7.x86_64.rpm rpm -ivh mysql-community-devel-5.7.18-1.el7.x86_64.rpm
5、启动MySQL服务,记录初始密码。
[root@Geeklp-MySQL ~]# systemctl start mysqld[root@Geeklp-MySQL ~]# cat /var/log/mysqld.log |grep password2017-12-13T10:50:44.960028Z 1 [Note] A temporary password is generated for root@localhost: =mWoe;zkj4M3
至此,安装过程完成。
三、配置过程
1、初次登录,修改登录密码。
[root@Geeklp-MySQL ~]# # mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.7.18Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> SET PASSWORD = PASSWORD('xwumpmysql,./');ERROR 1819 (HY000): Your password does not satisfy the current policy requirementsmysql> SET PASSWORD = PASSWORD('Geeklp.0/7');Query OK, 0 rows affected, 1 warning (0.00 sec)mysql> quit;Bye
2、创建数据目录,修改my.cfn配置文件。
[root@Geeklp-MySQL ~]# mkdir /home/data[root@Geeklp-MySQL ~]# mv /var/lib/mysql /home/data/[root@Geeklp-MySQL ~]# vi /etc/my.cnfdefault-storage-engine=INNODB lower_case_table_names = 1
其他更详配置尽介绍请参阅:https://dev.mysql.com/doc/refman/5.7/en/mysqld-option-tables.html
权限重置敬请参阅:https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
阅读全文
0 0
- CentOS7.2下安装MySQL-5.7.18RPM Bundle版(适用于最新版5.7.20)
- (一) CentOS7下RPM安装MYSQL-5.7.18
- centos7安装mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar
- Centos7安装mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar
- centos7安装mysql-5.7.18-1.el7.x86_64.rpm-bundle.tar
- CentOS7安装最新版的MySQL(5.7)
- CentOS 7.2 安装mysql 5.7.18-*.rpm-bundle.tar
- Linux下安装MySQL RPM-Bundle.tar
- centos7 64 rpm 安装 mysql 5.7.10
- linux 下安装mysql-5.7.16-1.el6.x86_64.rpm-bundle
- linux 下安装mysql-5.7.16-1.el6.x86_64.rpm-bundle
- centos7下rpm方式安装mysql
- CentOS6.5安装mysql-5.7.18-1.el6.x86_64.rpm-bundle.tar
- CentOS7 安装 Mysql rpm
- CentOS7.3 安装 MySQL5.7.18 RPM Bundle
- MySQL windows10下安装最新版5.7.16
- Linux下基于RPM BUNDLE包安装MySQL
- Linux下基于RPM BUNDLE包安装MySQL
- 主角面朝方向一定区域内对象角度计算(点是否在扇形区域检测)
- NSData 接受数据不正确
- ExtJS5 实现树形菜单
- Java开发大型互联网-架构师必须掌握的分布式技术
- 对MySql数据库插入数据操作
- CentOS7.2下安装MySQL-5.7.18RPM Bundle版(适用于最新版5.7.20)
- Hadoop3.0安装配置
- 人工智能越来越“能”
- Tractica:2022年全球企业机器人市场将达到679亿美元
- 多家银行APP存致命漏洞 汇丰和国民西敏寺均在列
- RethinkX:2020-2030交通运输业反思报告
- Python3之变量单下划线和双下划线的区别
- 算法总结01-递归
- opencv之图像几何变换和放大