2003 Can't connect to MySql server on "localhost"(10061)

解决mysql都是启动正常,但就是一直连接不上服务的问题:

解决方法:重改一下密码!

1、在cmd中,进入到mysql的bin目录下,执行mysqld --initialize --user==root --console获得一个暂时性密码,红色圈起来就是密码

2003 Can't connect to MySql server on "localhost"(10061)

2、重新启动服务net start mysql

2003 Can't connect to MySql server on "localhost"(10061)

3、利用暂时性密码进行登录  mysql -u root -p  并输入密码

2003 Can't connect to MySql server on "localhost"(10061)

4、进行set password=password('123456')

2003 Can't connect to MySql server on "localhost"(10061)

下次利用设置密码登入就不会报2003 Can't connect to MySql server on "localhost"(10061)错误了!