Windows安装mysql个人踩坑记录

1、安装路径问题。路径中包含software。

报错：mysqld: Can’t create directory ‘D: oftware\mysql-5.7.25-winx64\data’

解决：是因为使用了\soft ,使用/soft 没问题。

2、记得打开黑窗口用管理员身份！

3、具体安装过程点进去 https://www.cnblogs.com/yahengwang/p/9865858.html

4、修改密码命令：

配置文件修改后可以免密登录MySQL，然后修改密码：

mysql> update mysql.user set authentication_string=password('密码') where user='root' and Host = 'localhost';
Query OK, 1 row affected, 1 warning (0.32 sec)
Rows matched: 1  Changed: 1  Warnings: 1

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> quit;
Bye

再去把配置文件改回来，重启mysql，用新改的密码登陆进去以后，不管运行任何命令，总是提示这个：
You must reset your password using ALTER USER statement before executing this statement.

mysql> SET PASSWORD = PASSWORD('密码');
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

完成以上三步就行了！