mysql5.7出现:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)问题解决

mysql5.7出现:ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)问题解决
1、首先安装mysqld服务器,输入命令:mysqld --install (必须是管理员身份运行cmd)

mysql5.7出现:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)问题解决

2.接下来就是启动服务器了,输入命令:net start mysql (必须是管理员身份运行cmd)
mysql5.7出现:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)问题解决

3、输入命令:mysqld --initialize-insecure

完了再次输入:net start mysql

mysql5.7出现:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)问题解决
4、然后会出现问题:Access denied for user ‘root’@‘localhost’ (using password: YES)
为什么安装时已经设置了密码不管用?在这里不需要密码可以直接登录
mysql5.7出现:ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)问题解决
5.mysql5.7更改密码应该采用命令ALTER USER ‘root’@'localhost’IDENTIFIED BY ‘********’;

6.改完密码后即可正常登陆!

笔记的习惯吧,会事成功倍!