window 10下 MySql5.7压缩包安装
安装 10 window mysql5.7 压缩包
2023-09-11 14:19:27 时间
步骤如下:
1、
解压缩到某位置,
在其根目录下 新建data空目录,
新建my.ini,内容如下:
[mysql] default-character-set=utf8 [mysqld] port = 3306 basedir=D:\mysql-5.7.18-winx64 datadir=D:\mysql-5.7.18-winx64\data max_connections=200 character-set-server=utf8 default-storage-engine=INNODB
结构如图:
2、
配置环境变量,key为MYSQL_HOME,值为D:\mysql-5.7.18-winx64;path下新增字符串:%MYSQL_HOME%\bin
如图:
3、
管理员身份打开cmd,进入
D:\mysql-5.7.18-winx64\bin
目录下,
执行以下命令
D:\mysql-5.7.18-winx64\bin>mysqld install Service successfully installed. D:\mysql-5.7.18-winx64\bin>mysqld --initialize --user=mysql --console 2017-07-03T13:29:47.992396Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2017-07-03T13:29:49.186574Z 0 [Warning] InnoDB: New log files created, LSN=45790 2017-07-03T13:29:49.586778Z 0 [Warning] InnoDB: Creating foreign key constraint system tables. 2017-07-03T13:29:49.805224Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: b053a390-5ff3-11e7-8f93-408d5cc8a659. 2017-07-03T13:29:49.865407Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2017-07-03T13:29:50.048867Z 1 [Note] A temporary password is generated for root@localhost: ,Qhlh:z7?dQ5
//上边这句会在data下创建很多东西,并且给你创建一个root密码,从 逗号 到 5 这个字符串复制下来,这个就是你的密码,下边马上用到
D:\mysql-5.7.18-winx64\bin>net start mysql MySQL 服务正在启动 . MySQL 服务已经启动成功。 D:\mysql-5.7.18-winx64\bin>mysql -uroot -p Enter password: ************ Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.7.18 Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('qw12.,mn'); Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> exit Bye
相关文章
- mac安装sublime text 3,含注册码
- 【华为云技术分享】【昇腾】【玩转Atlas200DK系列】Atlas 200 DK安装python的hiai库以及opencv
- Django安装以及介绍
- 安装apache2.4.10
- Windows 10、Windows 2012 安装 Oracle 11g 报错:[INS-13001]环境不满足最低要求。
- centos8上安装ImageMagick6.9.10并压缩图片生成webp缩略图
- Samba 简介及安装
- Windows 10、Windows 2012 安装 Oracle 11g 报错:[INS-13001]环境不满足最低要求。
- macos:安装homebrew( Homebrew 4.0.10-119 / macos 12.4)
- Nginx 1.5.2 + PHP 5.5.1 + MySQL 5.6.10 在 CentOS 下的编译安装
- Windows 10 安装 choco 和 neovim
- Android 10 静默安装与卸载
- Python安装
- 安装gcc-arm-none-eabi-10-2020-q4-major-win32工具(NRF52编译ECC加密文件用)
- 2022年最新最详细的IntelliJ idea高效插件的介绍安装,让你的工作效率提升10倍
- Windows 10下安装配置Caffe并支持GPU加速(修改版)
- ubuntu 20一条命令安装NVIDIA Geforce Now 驱动
- 深度学习工具caffe具体安装指南
- 笔记:在 Windows 10 WSL Ubuntu 18.04 安装 Odoo12 (2019-06-09)
- BeautifulSoup4的安装和简单使用
- Linux安装httpd2.4.10
- 在windows 10 64位系统下安装TensorFlow
- centos7和centos6通过yum安装JDK1.8
- 101_Hadoop安装部署
- SonarQube 02 插件安装以及配置scanner