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>