记得早上因为没有网络,把root密码改错了写成了: update user set password="122" where user="root"; 之后mysql就开始不工作了。 #mysql -u root -p #123 就会出现:ERROR 1045 (28000): access denied for user ''@'localhost' (using password: NO) 只能这样: #mysql -u root mysql> use mysql 又出现了ERROR 1045 (28000): access denied for user ''@'localhost' (using password: NO) 找了好久资料: 解决方法: 1.关闭mys...
by yexin218 - MySQL文档中心 - 2007-08-22 17:37:12 阅读(1235) 回复(0)
用administartor登陆,检查发现系统path改变。 cmd模式下执行任何命令提示access is denied 有人遇到过吗?
想要实现admin不受限制使用,其它用户受限制. 本人的配置文件如下 http_port 3389 cache_dir ufs /usr/local/squid/cache 3000M 16 256 cache_mem 30 MB cache_swap_low 90 cache_swap_high 95 cache_store_log /usr/local/squid/logs/store.log cache_access_log /usr/local/squid/logs/access.log cache_log /usr/local/squid/logs/cache.log cache_effective_user squid cache_effective_group squid visible_hostname squid_...
我在Suse Linux 10.2下用自带光盘用Yast2安装Mysql 5.0, 装好后在终端输入mysql, mysql 成功启动,退出,再输入 mysqladmin -u root password XXXXX, 出现错误: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (using password: NO)' 如先输入mysql,成功启动后输入use mysql,出现如下错误:access denied for user ''@'localhost' to database 'mysql' 还有,输m...
access denied for user 'root'@'localhost' (using password: YES) 在bin 目录下运行./mysql 就出现以上对话框 网页中也是显示这个对话框
我的系统是ubuntu6.06,最近新装好的mysql在进入mysql工具时,总是有错误提示: # mysql -uroot -p Enter password: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO) 使用网上介绍的方法修改root用户的密码: # mysqladmin -uroot -p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (using...
我的系统是ubuntu6.06,最近新装好的mysql在进入mysql工具时,总是有错误提示: # mysql -uroot -p Enter password: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO) 使用网上介绍的方法修改root用户的密码: # mysqladmin -uroot -p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (using...
登录正常,就是我要用grant修改权限时就出现如下提示: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: YES) 修改密码root密码后还是一样: $ mysql -h localhost -u root -p # 登录没有问题 Enter password: mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup ...
我的系统是ubuntu6.06,最近新装好的mysql在进入mysql工具时,总是有错误提示: # mysql -uroot -p Enter password: ERROR 1045 (28000): access denied for user 'root'@'localhost' (using password: NO) 使用网上介绍的方法修改root用户的密码: # mysqladmin -uroot -p password 'newpassword' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'access denied for user 'root'@'localhost' (using...
#1045 - access denied for user 'root'@'localhost' (using password: NO) 解决办法: mysqladmin -h hostname flush-privileges use mysql; update user set password =password('yourpass') where user='root' 出现无法连接数据库的话,命令行用root用户登陆,敲下面命令: SET PASSWORD FOR [email=sns@-localhost-=OLD_PASSWORD%28-sns-]sns@'localhost'=OLD_PASSWORD('sns'[/email] ); 然后刷新mysql权限 FLUSH PRIVIL...