win764安装mysql8_win7安装mysql8.0.13winx64

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

下包

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

解压与配置

[mysqld]

basedir=C:\Users\hp\Downloads\mysql-8.0.13-winx64

datadir=C:\Users\hp\Downloads\mysql-8.0.13-winx64\data

port=3306

初始化、安装、与启动

C:UsershpDownloadsmysql-8.0.13-winx64in>mysqld.exe --initialize

C:UsershpDownloadsmysql-8.0.13-winx64in>mysqld.exe -install

Service successfully installed.

C:UsershpDownloadsmysql-8.0.13-winx64in>net start mysql

MySQL 服务正在启动 ...

MySQL 服务已经启动成功。

修改初始密码

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

登录与修改密码

C:UsershpDownloadsmysql-8.0.13-winx64in>mysql -u root -p3Xp_sz/(u:gl

mysql: [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 11

Server version: 8.0.13

Copyright (c) 2000, 2018, 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> ALTER USER 'root'@'localhost' IDENTIFIED BY 'lizhenghua';

Query OK, 0 rows affected (0.15 sec)

mysql> exit

Bye

C:UsershpDownloadsmysql-8.0.13-winx64in>

C:UsershpDownloadsmysql-8.0.13-winx64in>mysql -u root -plizhenghua

mysql: [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 12

Server version: 8.0.13 MySQL Community Server - GPL

Copyright (c) 2000, 2018, 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> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

+--------------------+

4 rows in set (0.06 sec)

mysql> exit

Bye

重启服务

C:UsershpDownloadsmysql-8.0.13-winx64in>net stop mysql

MySQL 服务正在停止.

MySQL 服务已成功停止。

C:UsershpDownloadsmysql-8.0.13-winx64in>net start mysql

MySQL 服务正在启动 ..

MySQL 服务已经启动成功。

查看进程与端口

C:Usershp>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 14144

C:Usershp>wmic process get name | findStr mysql

mysqld.exe

mysqld.exe

C:Usershp>