Mysql免安装配置教程（图文版)

墨蓝 2021-09-30 18:04 495阅读 0赞

# Mysql免安装版配置教程 #

## 图文版 ##

![640?wx\_fmt=png][640_wx_fmt_png]

[mysqld]    basedir=C:\\software\Mysql\mysql-5.7.14-winx64    datadir=C:\\software\Mysql\mysql-5.7.14-winx64\data    port=3306
        basedir=C:\\software\Mysql\mysql-5.7.14-winx64
        datadir=C:\\software\Mysql\mysql-5.7.14-winx64\data
        port=3306

![640?wx\_fmt=png][640_wx_fmt_png 1]![640?wx\_fmt=png][640_wx_fmt_png 2]

mysqld --initialize --user=mysql --console

![640?wx\_fmt=png][640_wx_fmt_png 3]

mysqld --install MySQL

![640?wx\_fmt=png][640_wx_fmt_png 4]

net start mysql

![640?wx\_fmt=png][640_wx_fmt_png 5]

mysqld --remove

mysql -u root -p

![640?wx\_fmt=png][640_wx_fmt_png 6]![640?wx\_fmt=png][640_wx_fmt_png 7]![640?wx\_fmt=png][640_wx_fmt_png 8]![640?wx\_fmt=png][640_wx_fmt_png 9]

update user set authentication_string = password("root") where user="root";user set authentication_string = password("root") where user="root";

进到到mysql数据库，**在使用sql指令的时候，如果出现以下的错误**：

mysql> show databases;ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

![640?wx\_fmt=png][640_wx_fmt_png 10] 这里写图片描述

**增加三句指令：**

**step 1:** `SET PASSWORD = PASSWORD('your new password');`

**step 2:** `ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;`

**step 3:**`flush privileges;`

在step1 时，**your new password是随便你自己写的**！

--------------------

## 文字版 ##

这是文字版：

![640?wx\_fmt=png][640_wx_fmt_png 11] 这里写图片描述

**下面是成功的图！**

![640?wx\_fmt=png][640_wx_fmt_png 12]

# Mysql常用命令图 #

![640?wx\_fmt=png][640_wx_fmt_png 13]

--------------------

> 如果文章有错的地方欢迎指正，大家互相交流。习惯在微信看技术文章，想要获取更多的Java资源的同学，可以**关注微信公众号:Java3y**

[640_wx_fmt_png]: /images/20210827/6b3d93c0cfb54a798bb1a766786adf20.png?wx_fmt=png
[640_wx_fmt_png 1]: https://ss.csdn.net/p?https://mmbiz.qpic.cn/mmbiz_png/2BGWl1qPxib2SSMibdXtsswuJhaib0lHkU9SUZjp1Xdr7pQglKuBIsgBwywsBWg1TrJZNYFL5HFgwJZEkP6r9mAtA/640?wx_fmt=png
[640_wx_fmt_png 2]: /images/20210827/539678b576864e17873056a756061a19.png?wx_fmt=png
[640_wx_fmt_png 3]: /images/20210827/812af0d1bf774c74a67378594b58c600.png?wx_fmt=png
[640_wx_fmt_png 4]: /images/20210827/50a992dbea49450cb1f935f8e84aa446.png?wx_fmt=png
[640_wx_fmt_png 5]: /images/20210827/c741f321b89d48358bc76986c1172754.png?wx_fmt=png
[640_wx_fmt_png 6]: https://ss.csdn.net/p?https://mmbiz.qpic.cn/mmbiz_png/2BGWl1qPxib2SSMibdXtsswuJhaib0lHkU9gdVWbnpkMd6yLdr81vZ7Xnv935tEpNa5y0piaboJwWXkvytoL3FQHJA/640?wx_fmt=png
[640_wx_fmt_png 7]: https://ss.csdn.net/p?https://mmbiz.qpic.cn/mmbiz_png/2BGWl1qPxib2SSMibdXtsswuJhaib0lHkU9WH3GvRHQosUXGGb3VOTjzJs9h3YqkHxNQHQHjYxBK5lYoqDPDmBaug/640?wx_fmt=png
[640_wx_fmt_png 8]: https://ss.csdn.net/p?https://mmbiz.qpic.cn/mmbiz_png/2BGWl1qPxib2SSMibdXtsswuJhaib0lHkU9r78pANGnZyD8xKwfcOD0nAON0I13WicxZCWNAuEJyQnTTSqXBCM6hDw/640?wx_fmt=png
[640_wx_fmt_png 9]: /images/20210827/e4656521bb674b2fa54a3fa530660781.png?wx_fmt=png
[640_wx_fmt_png 10]: /images/20210827/13b0c90014fb4e1890b70ea6833f9747.png?wx_fmt=png
[640_wx_fmt_png 11]: /images/20210827/4e60c8acea7847cb9e28a0fd16b92097.png?wx_fmt=png
[640_wx_fmt_png 12]: /images/20210827/1de8be1d673348b99bc412b02e9e54ad.png?wx_fmt=png
[640_wx_fmt_png 13]: /images/20210827/ac98b9a51e7642c787d583c17dc79bfd.png?wx_fmt=png