MySQL 错误信息 Errors

ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)

无法连接到 MySQL 服务

极大的可能是 MySQL 的服务没有启动
Most is Service of MySQL hasn’t started

这时候在命令行使用net start mysql启动服务
Then start the service on command with net start mysql

如果这时启动服务出错
Fail to start

A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly.

出现系统错误 1067， 进程意外中止

首先检查 my.ini 文件
At first, check your file named ‘my.ini’

必要时删除目录下的 data 文件夹
If necessary, delete the folder named ‘data’

重新执行命令 net start mysql
net start mysqlAgain

如果还不行
Not again

执行命令 mysqld --initialize --console初始化数据库
Execute command mysqld --initialize --consoleto initialize the database

重启服务
net start mysql

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement

在执行这条语句前，你必须使用ALTER USER语句重新设置你的密码

这一般出现在初始化数据库时
Occurs while initializing your database

使用以下语句重置密码 Reset your password by the next line

 ALTER USER 'root'@'localhost' IDENTIFIED  BY '123456';

现在你的账号 root 的密码就被设置为了 123456
Now, your password of your account ‘root’ is ‘123456’

ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)

用户’root’@'localhost’的登录被拒绝，密码错误