mysql的安装教程

mysql一定要解压到纯英文路径

C:\Windows\system32>cd C:\Develop\mysql\bin

一定要以管理员身份运行cmd在运行

C:\Develop\mysql\bin> mysqld --initialize --user=mysql --console 2017-10-2

//在初始化mysql的时候，一定要将密码保存下来

C:\Develop\mysql\bin> mysqld --install MySQL Service successfully installed.

C:\Develop\mysql\bin> net start MySQL MySQ L 服务正在启动 .MySQL 服务已经启动成功。

C:\Develop\mysql\bin> mysql -u root -p Enter password: **** Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 3Server version: 5.7.19

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

设置密码

mysql> set password for root@localhost = password('123456') ;Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql>show databases; //一定要加；否则会执行不玩，注意细节

mysql> exit;Bye

C:\Develop\mysql\bin>mysql -u root -pEnter password: ** Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 4Server version: 5.7.19 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.

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.00 sec)

mysql> exit;Bye

C:\Develop\mysql\bin>

mysql的卸载

在sevice中打开，停止服务

以管理员身份运行cmd

$ sc delete MySQL 这里指的是服务名称

然后按F5刷新

回到安装路径，将解压包进行删除