CentOS 7.3下安装MySQL 5.7
来源:互联网 发布:java yield join 编辑:程序博客网 时间:2024/06/08 04:02
1、 下载
下载地址:
https://dev.mysql.com/downloads/mysql/
选择你需要安装的版本,这里我的电脑是CentOS7.3 64位
然后下载 RPM Bundle,这个是几个程序的合集包。
然后开始下载。。。。
2、 解压安装包
解压mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar
#tar -xvf mysql-5.7.20-1.el7.x86_64.rpm-bundle.tarmysql-community-client-5.7.20-1.el7.x86_64.rpmmysql-community-common-5.7.20-1.el7.x86_64.rpmmysql-community-devel-5.7.20-1.el7.x86_64.rpmmysql-community-embedded-5.7.20-1.el7.x86_64.rpmmysql-community-embedded-compat-5.7.20-1.el7.x86_64.rpmmysql-community-embedded-devel-5.7.20-1.el7.x86_64.rpmmysql-community-libs-5.7.20-1.el7.x86_64.rpmmysql-community-libs-compat-5.7.20-1.el7.x86_64.rpmmysql-community-minimal-debuginfo-5.7.20-1.el7.x86_64.rpmmysql-community-server-5.7.20-1.el7.x86_64.rpmmysql-community-server-minimal-5.7.20-1.el7.x86_64.rpmmysql-community-test-5.7.20-1.el7.x86_64.rpm
#ls-rw-r--r-- 1 7155 31415 25090196 Sep 14 23:44 mysql-community-client-5.7.20-1.el7.x86_64.rpm-rw-r--r-- 1 7155 31415 278300 Sep 14 23:44 mysql-community-common-5.7.20-1.el7.x86_64.rpm-rw-r--r-- 1 7155 31415 3778120 Sep 14 23:44 mysql-community-devel-5.7.20-1.el7.x86_64.rpm-rw-r--r-- 1 7155 31415 46238924 Sep 14 23:44 mysql-community-embedded-5.7.20-1.el7.x86_64.rpm-rw-r--r-- 1 7155 31415 24077232 Sep 14 23:44 mysql-community-embedded-compat-5.7.20-1.el7.x86_64.rpm-rw-r--r-- 1 7155 31415 128440800 Sep 14 23:44 mysql-community-embedded-devel-5.7.20-1.el7.x86_64.rpm-rw-r--r-- 1 7155 31415 2238604 Sep 14 23:44 mysql-community-libs-5.7.20-1.el7.x86_64.rpm-rw-r--r-- 1 7155 31415 2115892 Sep 14 23:44 mysql-community-libs-compat-5.7.20-1.el7.x86_64.rpm-rw-r--r-- 1 7155 31415 55538708 Sep 14 23:44 mysql-community-minimal-debuginfo-5.7.20-1.el7.x86_64.rpm-rw-r--r-- 1 7155 31415 171597916 Sep 14 23:45 mysql-community-server-5.7.20-1.el7.x86_64.rpm-rw-r--r-- 1 7155 31415 15256460 Sep 14 23:45 mysql-community-server-minimal-5.7.20-1.el7.x86_64.rpm-rw-r--r-- 1 7155 31415 118609776 Sep 14 23:45 mysql-community-test-5.7.20-1.el7.x86_64.rpm
3、安装
卸载已安装的mysql-libs
# rpm -qa | grep -i mysqlmysql-libs-5.1.73-8.el6_8.x86_64#yum remove mysql-libs
安装
rpm -ivh mysql-community-common-5.7.20-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-5.7.20-1.el7.x86_64.rpm rpm -ivh mysql-community-libs-compat-5.7.20-1.el7.x86_64.rpm rpm -ivh mysql-community-client-5.7.20-1.el7.x86_64.rpm rpm -ivh mysql-community-server-5.7.20-1.el7.x86_64.rpm rpm -ivh mysql-community-devel-5.7.20-1.el7.x86_64.rpm
MySQL 的配置文件位于:/etc/my.cnf ,根据需求修改配置
默认的datadir=/var/lib/mysql
启动mysql
# systemctl start mysqld
4、初始化
这种方式安装好后,会在mysqld.log文件中自动生成一个密码,执行看一下吧:
# cat /var/log/mysqld.log | grep password 2017-05-13T05:39:44.497086Z 1 [Note] A temporary password is generated for root@localhost: pKsO:Jin<4f%
密码就是这么复杂,复制吧,不然手输还容易出错。
登陆:
#mysql -u root -pEnter password:pKsO:Jin<4f%mysql>
输入初始密码后,就可以登录了;
登录后需要重置密码,如果不重置,则不让操作
mysql> show databases;ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
这里可以直接使用命令修改root用户密码
SET PASSWORD = PASSWORD('passwd');
5、创建用户
登录
# mysql -u root -p Enter password: mysql>
创建数据库,指定编码utf-8:
mysql> CREATE DATABASE db182915 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
添加用户 test:
mysql> GRANT ALL PRIVILEGES ON db182915.* TO 'test'@'192.168.%' IDENTIFIED BY 'test123#' WITH GRANT OPTION;mysql> flush privileges;
阅读全文
0 0
- CentOS 7.3下安装MySQL 5.7
- CentOS下安装mysql
- CentOS下安装mysql
- centos下安装mysql
- Centos下安装mysql
- centos下mysql安装
- centos下安装mysql
- centos下 mysql 安装
- centos 下安装mysql
- centOS下安装mysql
- CentOS下安装mysql
- Centos下安装mysql
- centos下安装mysql
- CentOS下安装MySql
- centos 下安装mysql
- centOS下安装mysql
- centos下安装mysql
- CentOS下安装mysql
- ELK 日志分析系统
- Windows 启动 Eclipse启动出现:a java runtime environment(JRE) or java development kit(JDK) must be....
- java多线程基本知识体系
- 发表3308篇论文是一种怎样的体验?并非搬运自知乎
- fabric.js自定义字体的引入
- CentOS 7.3下安装MySQL 5.7
- Python的BeautifulSoup之find和find_all
- 小白的Python之路——初识Python
- MySQL多表查询
- Mybatis单个参数的if判断(针对异常:There is no getter for property..)
- 马里奥吃金币消失
- Unity Profiler 性能分析
- Kafka Java 牛刀小试
- C语言实现直方图统计和直方图均衡化