博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
win7安装mysql-8.0.13-winx64
阅读量:6983 次
发布时间:2019-06-27

本文共 2731 字,大约阅读时间需要 9 分钟。

这里展示一下,由于需要安装一个版本测试一下数据,其实就是超简单的啦。

下包

注:https://dev.mysql.com/downloads/mysql/

解压与配置

[mysqld]basedir=C:\\Users\\hp\\Downloads\\mysql-8.0.13-winx64datadir=C:\\Users\\hp\\Downloads\\mysql-8.0.13-winx64\\dataport=3306

 初始化、安装、与启动

 

C:\Users\hp\Downloads\mysql-8.0.13-winx64\bin>mysqld.exe --initializeC:\Users\hp\Downloads\mysql-8.0.13-winx64\bin>mysqld.exe -installService successfully installed.C:\Users\hp\Downloads\mysql-8.0.13-winx64\bin>net start mysqlMySQL 服务正在启动 ...MySQL 服务已经启动成功。 

修改初始密码

注:在data目录下.err后缀名的就是日志, 日志里面记录了初始化的信息

登录与修改密码

C:\Users\hp\Downloads\mysql-8.0.13-winx64\bin>mysql -u root -p3Xp_sz/(u:glmysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 11Server version: 8.0.13Copyright (c) 2000, 2018, 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> ALTER USER 'root'@'localhost' IDENTIFIED BY 'lizhenghua';Query OK, 0 rows affected (0.15 sec)mysql> exitByeC:\Users\hp\Downloads\mysql-8.0.13-winx64\bin>C:\Users\hp\Downloads\mysql-8.0.13-winx64\bin>mysql -u root -plizhenghuamysql: [Warning] Using a password on the command line interface can be insecure.Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 12Server version: 8.0.13 MySQL Community Server - GPLCopyright (c) 2000, 2018, 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> show databases;+--------------------+| Database           |+--------------------+| information_schema || mysql              || performance_schema || sys                |+--------------------+4 rows in set (0.06 sec)mysql> exitBye

重启服务

C:\Users\hp\Downloads\mysql-8.0.13-winx64\bin>net stop mysqlMySQL 服务正在停止.MySQL 服务已成功停止。C:\Users\hp\Downloads\mysql-8.0.13-winx64\bin>net start mysqlMySQL 服务正在启动 ..MySQL 服务已经启动成功。

查看进程与端口 

C:\Users\hp>netstat -ano | findStr 3306  TCP    0.0.0.0:3306           0.0.0.0:0              LISTENING       14144  TCP    0.0.0.0:33060          0.0.0.0:0              LISTENING       14144  TCP    [::]:3306              [::]:0                 LISTENING       14144  TCP    [::]:33060             [::]:0                 LISTENING       14144C:\Users\hp>wmic process get name | findStr mysqlmysqld.exemysqld.exeC:\Users\hp>

 

转载于:https://www.cnblogs.com/chenglee/p/10156406.html

你可能感兴趣的文章
Spring Cloud微服务分布式云架构—集成项目简介
查看>>
盒马鲜生颠覆传统生鲜市场的胜算几何?
查看>>
【Node】常用基础 API 整理
查看>>
传神成进博会唯一指定智能翻译硬件提供商 力助无障碍沟通
查看>>
微信小程序实现slideUp、slideDown滑动效果及点击空白隐藏功能示例
查看>>
Java程序员须知:分布式微服务为什么很难?
查看>>
SQLServer之创建唯一聚集索引
查看>>
好程序员web前端技术之CSS3过渡
查看>>
java B2B2C源码电子商务平台 - Zuul回退机制
查看>>
记录Docker in Docker 安装(CentOS7)
查看>>
简单的写一个发布订阅器
查看>>
重学前端-js的类型问题
查看>>
Function类型
查看>>
Python学习
查看>>
ES6之let和const
查看>>
关于跨域
查看>>
一个半路出家的前端工程师的2018 | 掘金年度征文
查看>>
Fork/Join 框架介绍
查看>>
5.6 前端开发日报
查看>>
面试官:聊一下你对MySQL索引实现原理?
查看>>