200—-mysql的zip格式的安装教程

200—-mysql的zip格式的安装教程

1.先从官网上下载mysql的zip格式的安装包
2.进行环境变量的配置
3.打开管理员界面的命令行
4.进入MySQL安装目录中的bin文件夹里面
5.输入mysqld —initialize —console，会显示下面这些信息，
2019-01-22T08:36:24.773473Z 0 [System] [MY-013169] [Server] D:\coding\MySQL\mysql-8.0.14-winx64\bin\mysqld.exe (mysqld 8.0.14) initializing of server in progress as process 10440
2019-01-22T08:36:24.776024Z 0 [Warning] [MY-013242] [Server] —character-set-server: ‘utf8’ is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2019-01-22T08:37:05.565080Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: olhQc%IEq0vP
2019-01-22T08:37:43.423177Z 0 [System] [MY-013170] [Server] D:\coding\MySQL\mysql-8.0.14-winx64\bin\mysqld.exe (mysqld 8.0.14) initializing of server has completed
后面的olhQc%IEq0vP是你的初始密码。
2019-01-22T08:37:05.565080Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: olhQc%IEq0vP
6.然后输入
net start mysql//启动mysql的服务
200---mysql的zip格式的安装教程 - 图1
7.修改密码
在bin目录下输入mysql -u root -p，会让你输入密码，把你的初始密码填上，进入mysql里面
然后输入下面的命令，修改你的密码
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘新密码’;
8.然后就可以进行你的MySQL之旅了.
show databases;
use mysql;
show tables;
**

参考与https://www.cnblogs.com/laumians-notes/p/9069498.html