windows 安装 Mysql

1.https://downloads.mysql.com/archives/community/ 下载压缩包

 

 2.解压缩

 

 3.设置环境变量

4.创建数据目录及配置文件

5.初始化

A:\mysql-win\mysql-5.7.23-winx64\bin>mysqld --initialize-insecure    //初始化

A:\mysql-win\mysql-5.7.23-winx64\bin>mysqld -install      //注册服务
Service successfully installed.

A:\mysql-win\mysql-5.7.23-winx64\bin>netstat -ano |findstr  "3306"  //查看
  TCP    0.0.0.0:3306           0.0.0.0:0              LISTENING       24484
  TCP    127.0.0.1:3306         127.0.0.1:62620        ESTABLISHED     24484
  TCP    127.0.0.1:62620        127.0.0.1:3306         ESTABLISHED     16452
  TCP    [::]:3306              [::]:0                 LISTENING       24484

A:\mysql-win\mysql-5.7.23-winx64\bin>net start mysql    //启动  
MySQL 服务正在启动 ..
MySQL 服务已经启动成功。

A:\mysql-win\mysql-5.7.23-winx64\bin>mysql -u root -p
Enter password:   //空密码

 

//修改用户权限能够允许远程访问

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'default_zy' WITH GRANT OPTION;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>