重新设置root的密码吧.设置密码时用old_password()函数. mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') -> WHERE Host = 'some_host' AND User = 'some_user'; mysql> FLUSH PRIVILEGES
你是怎样修改MYSQL密码的???------修改密码方式错了....改密码必须要ROOT权限. 找到你MYSQL的文件夹---bin文件夹下面有一个mysql.exe打开就出现:mysql> 了,之后:提示输入密码,敲回车表示空密码,在mysql>提示符下输入: musql >use mysql;mysql >update user set password = password('12344321') where user='root';重启系统,OK.
win有个MySQLInstanceConfig.exe的程序的,图形界面的,那里可以设置和修改root密码的呀,我修改过,而且mysql重装了好几次,而且装不同的目录,也全部删除原来的,也不行。按楼上说的,控制台在bin文件夹下运行mysql.exe,显示错误 ERROR 1045(28000):Access denied for user 'ODBC'@'localhost' (using password:NO)
怎么进入">mysql " ?开始->运行->输入cmd c:\cd mysql c:\mysql>cd bin c:\mysql\bin\mysql -u root -p 进入mysql musql >use mysql;mysql >UPDATE user SET Password = OLD_PASSWORD('newpwd') -> WHERE Host = 'some_host' AND User = 'some_user'; mysql> FLUSH PRIVILEGES mysql>quit;c:\mysql\bin\net stop mysql c:\mysql\bin\net start mysql (重启mysql)
按上面的都做了,结果还是一样,真郁闷。 MYSQL重装过N次了,每次都卸载后都删除整个目录。也严格按照 yicikou(伊静) 的做了(其中UPDATE user SET Password = OLD_PASSWORD('newpwd')是UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd'))结果还是一样
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES
找到你MYSQL的文件夹---bin文件夹下面有一个mysql.exe打开就出现:mysql> 了,之后:提示输入密码,敲回车表示空密码,在mysql>提示符下输入:
musql >use mysql;mysql >update user set password = password('12344321') where user='root';重启系统,OK.
ERROR 1045(28000):Access denied for user 'ODBC'@'localhost' (using password:NO)
c:\cd mysql
c:\mysql>cd bin
c:\mysql\bin\mysql -u root -p 进入mysql
musql >use mysql;mysql >UPDATE user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES
mysql>quit;c:\mysql\bin\net stop mysql
c:\mysql\bin\net start mysql (重启mysql)
mysql.exe进入不了,是因为你的密码已经错了.....你应该重装MYSQL:记住,要把MYSQL的文件夹要全删了!手动删除。这样才是真正的删除。重装之后就可以进入命令行界面改密码了。
MYSQL重装过N次了,每次都卸载后都删除整个目录。也严格按照 yicikou(伊静) 的做了(其中UPDATE user SET Password = OLD_PASSWORD('newpwd')是UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd'))结果还是一样