我的操作系统为WinXP+SP2,
在三台电脑上分别安装MySQL5.1.24然后进行配置,总是在最后一步出现问题,请问如何解决?
我在倒数第二步设置sceurity options时设置如下:
激活Modify security settings项
Current root password: (空)
New root password:123
Confirm:123
未激活Enable root access from remote machines
激活Create an anonymous account项最后一步的四项配置最后一项“Apply security settings”总无法通过,提示:
The current setting could not applied.
Error Number 1045.
Access denied for user 'root'@'localhost'(using password:NO)我试过卸载MySQL,删除安装目录,重新安装MySQL,关闭windows防火墙,添加mysql的3306端口,
仍然无法解决?
配置个mysql就这么费劲吗??
在三台电脑上分别安装MySQL5.1.24然后进行配置,总是在最后一步出现问题,请问如何解决?
我在倒数第二步设置sceurity options时设置如下:
激活Modify security settings项
Current root password: (空)
New root password:123
Confirm:123
未激活Enable root access from remote machines
激活Create an anonymous account项最后一步的四项配置最后一项“Apply security settings”总无法通过,提示:
The current setting could not applied.
Error Number 1045.
Access denied for user 'root'@'localhost'(using password:NO)我试过卸载MySQL,删除安装目录,重新安装MySQL,关闭windows防火墙,添加mysql的3306端口,
仍然无法解决?
配置个mysql就这么费劲吗??
请输入这个 当前root密码。否则你无法修改root密码,权限不够 Access denied for user 'root'@'localhost'(using password:NO)
就没有哪个Current root password: 的选项
只有New root password:123 和Confirm:123
root密码就是空啊,我直接回车就出现错误:ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)另外我安装MySQL Administrator 5.0后启动,输入连接名,localhost,root,密码为空,还是提示:Access denied for user 'root'@'localhost' (using password: NO)我在网上查询关于这个问题,看来是广大用户普遍安装mysql都遇到的问题,到现在我也没查到什么原因
mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('newpwd');
mysql> SET PASSWORD FOR ''@'%' = PASSWORD('newpwd');
ERROR 1470 (HY000): String '@'localhost' = password('123');
set password for ' is too long for user name (should be no longer than 16)搞了2天都没有搞定,我真想知道为什么简单装一个mysql,无论用安装包还是无须安装的资源包,WindowsXP ,Windows2003均不能正常配置。
总是提示ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
到底是为什么呢?它到底需要什么样的权限呢?默认root权限就是为空,还需要什么呢?
用这个好像可以解决
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
应该就可以了