mysql安装

参考视频：【狂神说Java】MySQL最新教程通俗易懂

参考文章：Windows环境 安装mysql 5.7 解压缩版

下载解压

把包放在环境目录下

添加环境变量

​ 我的电脑属性，高级系统设置里面

点击进PATH

新建复制masql的bin目录进去

新建my.ini配置文件：

[mysqld]
# 目录一定要换成自己的
basedir=D:\Environment\mysql-5.7.19\
datadir=D:\Environment\mysql-5.7.19\data\
port=3306
skip-grant-tables

管理员模式运行powershell

首先cd /d D:\Environment\mysql-5.7.19\bin进入bin目录，然后mysqld -install

出现错误：”由于找不到 MSVCR120.d1无法继绩执行代码。重新安装程序可能会解决此问题“

这种错误是由于未安装 vcredist 引起的

点击链接 vcredist 地址

然后继续输入mysqld --initialize-insecure --user=mysql

进入MySQL，修改密码net start mysql

update mysql.user set authentication_string=password(‘123456’) where user=‘root’ and Host = ‘localhost’;

Microsoft Windows [版本 10.0.17763.1757]
(c) 2018 Microsoft Corporation。保留所有权利。

C:\Windows\system32>cd /d D:\Environment\mysql-5.7.19\bin

D:\Environment\mysql-5.7.19\bin>mysqld -install
Service successfully installed.

D:\Environment\mysql-5.7.19\bin>mysqld --initialize-insecure --user=mysql

D:\Environment\mysql-5.7.19\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。


D:\Environment\mysql-5.7.19\bin>mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.19 MySQL Community Server (GPL)

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> update mysql.user set authentication_string=password('123456') where user='root' and Host = 'localhost';
Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 1

mysql> exit
Bye

D:\Environment\mysql-5.7.19\bin>net stop mysql
MySQL 服务正在停止.
MySQL 服务已成功停止。


D:\Environment\mysql-5.7.19\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。


D:\Environment\mysql-5.7.19\bin>mysql -u root -p
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.19 MySQL Community Server (GPL)

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> exit
Bye

修改完密码记得注释掉ini文件中的最后一行

安装sqlyog

创建数据库

创建表