Window下zip压缩包的MySQL的启动与停止

Windows下的MySQL下载分安装包的下载和zip压缩包的下载。
下面是针对zip压缩包的MySQL的启动和停止。

将MySQL作为服务安装

C:> “C:\bin\mysql5.6\bin\mysqld” –install {服务器名称} –defaults-file=主配置文件
{服务器名称} ： 默认为 MySQL

服务的卸载

C:> “C:\bin\mysql5.6\bin\mysqld” –remove

MySQL服务器的启动与停止

启动 : net start mysql
停止 : net stop mysql

不安装服务的情况下，MySQL的启动与停止

MySQL服务器启动

C:> “C:\bin\mysql5.6\bin\mysqld”

MySQL服务器停止

C:> “C:\bin\mysql5.6\bin\mysqladmin” -u root shutdown

服务器的登录，默认是没有密码的

C:\bin\mysql5.6\bin>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.25 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, 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>

参考：http://mysql.stu.edu.tw/doc/refman/5.1-olh/ja/windows-start-command-line.html