简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home> Database> Mysql Tutorial> body text

Windows2003服务器MySql1045 错误

WBOY
Release： 2016-06-07 17:52:19
Original
1049 people have browsed it

有经验的的朋友都知道1045是密码不正确，后面还应该带有一句Access denied for user root@\'localhost’ (using password:YES)提示，如果你是不知道密码可如下操作。

Windows:

1. 管理员登陆系统,停止mysql服务或者结束mysqld-nt进程
2. 进入命令行,来到mysql的安装目录.假设安装目录为 d:mysql , CMD进入命令行
3. 运行 d:mysqlbinmysqld-nt –skip-grant-tables 启动mysql,关闭权限的检查
4. 运行 d:mysqlbinmysqladmin -u root flush-privileges password “newpassword” 重设root密码
5. 重新启动mysql服

如果你是要修改密码可以尝试

代码如下 复制代码

mysql> use mysql;
mysql> UPDATE user SET Password=PASSWORD(‘你的新密码’) where USER=’root’;
mysql> FLUSH PRIVILEGES;
mysql> quit

还有一种绝招了，就是你的在一台密码正常的mysql表中，把user复制过来，这时就可以正常使用密码了哦，不过本人不建义这样做，这样做有可能对权限设置会有些问题哦

Related labels：
1045，Windows2003，mysql
source：php.cn
Previous article：mysql恢复数据数据出现Variable sql_mode cant 解决方法 Next article：mysql中GROUP BY分组取前N条记录实现
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Root user is denied access to MySQL I recently installed MySQL on x86_64 Access denied for "localhost" (using passwo...
From 2023-11-09 11:00:45
0
1
204
Unable to access MySQL, error code 1045 (28000): Access is denied for user 'bill'@'localhost' (using password: yes) Let me first mention that I have looked at many of the suggested questions and found no re...
From 2023-09-17 09:21:55
0
2
271
Can't access the page #1045 Unable to log in to MySQL server Why
From 2018-03-15 11:10:05
0
3
1087
#1045 Unable to log in to MySQL server? #1045 Unable to log in to MySQL server, how to solve it
From 2017-12-03 21:50:17
0
3
1322
Can't log in to mysql? May I ask what went wrong? I installed MySQL before and then a classmate mistakenly deleted the .sock socket file. Af...
From 2017-07-05 10:02:07
0
1
1147
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！