mysql Error 1045(28000) Access Denied for user 'root'@'localhost' (Using password:NO)
来源:互联网 发布:编程原本 英文 pdf 编辑:程序博客网 时间:2024/05/29 03:51
mysql error 1045
windows系统下mysql出现Error1045(28000) Access Denied for user 'root'@'localhost' (Using password:NO)错误解决方法
在windows操作系统安装mysql数据库,碰到Error 1045(28000) Access Denied for user 'root'@'localhost' (Using password:NO)错误时,你需要重新设置密码。
具体方法是:
1.先在安装目录找到my.ini配置文件,打开配置文件,找到[mysqld]一行,在下面添加skip-grant-tables后保存该文件,重新启mysql动服务;
windows7下装了mysql5.1,error1045,删除实例后服务就启动不了,试了很多方法都不能解决,,最后重装了个6.0的beta,出现刚装5.1时的初始错误error1045最终错误解决:(感谢作者)
1、mysql-u root
2、usemysql
3、updateuser set password=old_password('scf') where user='root' and host='localhost' ;
4、FLUSHPRIVILEGES;
windows系统下mysql出现Error
windows7下装了mysql5.1,error1045,删除实例后服务就启动不了,试了很多方法都不能解决,,最后重装了个6.0的beta,出现刚装5.1时的初始错误error
1、mysql
2、use
3、update
4、FLUSH
ok了试验一下!
装载自:http://blog.sina.com.cn/s/blog_6bce54010100zhnw.html
- mysql-->ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql Error 1045(28000) Access Denied for user 'root'@'localhost' (Using password:NO)
- [linux][mysql]ERROR 1045 (28000) : Access denied for user 'root'@'localhost' (using password:No)错误
- mysql解决ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- MySQL: Error 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: NO)
- centOS下mysql-ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql问题:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql提示ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql问题ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- 新安装mysql ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
- 解决MySQL 报错:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Mysql没有初始密码(ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO))
- Linux mysql 5.6: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- mysql GRANT with ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO
- MySQL:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- Ubuntu下 MySQL的“ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)”
- centOS下mysql-ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
- HDU OJ 3127 WHUgirls【DP之背包】
- Effective C++(五)实现
- PHP编程的文件资源管理一例
- bios 中断
- C语言解释器-4 C程序的结构
- mysql Error 1045(28000) Access Denied for user 'root'@'localhost' (Using password:NO)
- Android 最初级入门指南...
- POI中可能会用到一些需要设置EXCEL单元格格式的操作小结
- Memcache分布式部署方案
- Sqlserver2012 安装错误
- android Application Component研究之Activity(一)
- 配置zend studio9文件字符编码以解决中文乱码问题
- Linux下的Memcache安装
- Discuz!的Memcache缓存实现