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