Open CMD as an administrator and run net start Mysql to start the service. There is no problem starting.
It is said that the port number was changed, show global variables like ‘port’; You can find it. There’s no problem after checking it.
Later, it was correct to change the SQL host address to localhost.
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- After installing mysql5.7 on centos7, an error 1045 (28000) is reported: access denied for user ‘root’ @’localhost ‘(using PAS)
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- [Solved] There is a problem with mysql8.0 without password in Navicat connection
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- [Solved] C# connecting to MySQL database reports an error
- MySQL server has gone away Error [How to Solve]
- [Solved] Access denied for user ‘root‘@‘localhost‘ (using password: YES)
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- MySQL 8.0 error 1114 (HY000): the table’sbtest1’is full (Fixed)
- MYSQL Error 1045 (28000): access denied for user ‘root’ @’localhost ‘(using password: Yes)
- Ubuntu ODBC MySQL 8 OPTION NOT Work [How to Solve]
- [How to Fix] Database can’t open file (errno:24)
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- MySQL Install Error: MySQL error 1042: Unable to connect to any of the specified MySQL hosts
- [Solved] SQLSTATE[HY000]  Connection refused to report an error when PHP connects to mysql in the docker container
- How to Solve mysql [Err] 1067-Invalid default value for
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’