mysql解压缩版安装

最新推荐文章于 2024-09-20 21:26:51 发布

大熊猫今天吃什么

最新推荐文章于 2024-09-20 21:26:51 发布

阅读量296

点赞数

分类专栏： mysql 文章标签： mysql 解压缩版安装

本文链接：https://blog.csdn.net/plotu_charon/article/details/52065182

版权

mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

1.在bin文件夹下，按住shift+右键，选中“在此处打开命令窗口”

2.进入CMD

E:\work\mysql\mysql-5.7.13-win32\bin><span style="background-color: rgb(255, 153, 102);">mysqld --install</span>
Service successfully installed.

E:\work\mysql\mysql-5.7.13-win32\bin><span style="background-color: rgb(255, 153, 102);">mysqld --initialize --console</span>
2016-07-29T06:55:20.874178Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is
 deprecated. Please use --explicit_defaults_for_timestamp server option (see doc
umentation for more details).
2016-07-29T06:55:22.399265Z 0 [Warning] InnoDB: New log files created, LSN=45790

2016-07-29T06:55:22.810289Z 0 [Warning] InnoDB: Creating foreign key constraint
system tables.
2016-07-29T06:55:22.964298Z 0 [Warning] No existing UUID has been found, so we a
ssume that this is the first time that this server has been started. Generating
a new UUID: 6bc10191-5559-11e6-a847-1c6f65823dd6.
2016-07-29T06:55:23.017301Z 0 [Warning] Gtid table is not ready to be used. Tabl
e 'mysql.gtid_executed' cannot be opened.
2016-07-29T06:55:23.030301Z 1 [Note] A temporary password is generated for root@
localhost: <span style="background-color: rgb(255, 153, 102);">f*yII;Fiw5v& //这是本来的随机密码，标记，复制下来</span>

E:\work\mysql\mysql-5.7.13-win32\bin><span style="background-color: rgb(255, 153, 102);">net start mysql</span>
MySQL 服务正在启动 .
MySQL 服务已经启动成功。


E:\work\mysql\mysql-5.7.13-win32\bin><span style="background-color: rgb(255, 153, 102);">mysql -u root -p</span>
Enter password:<span style="background-color: rgb(255, 153, 102);"> ************ //这里用到上面的随机密码，黏贴</span>
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.13

Copyright (c) 2000, 2016, 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.
<span style="background-color: rgb(255, 153, 102);">//成功进入Mysql</span>
mysql><span style="background-color: rgb(255, 153, 102);"> set password for root@localhost = password('123456');//把密码改成“123456”</span>
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql>