Removing the anonymous user that has all privileges, then sets a root user password: C:\> C:\mysql\bin\mysql mysql mysql> DELETE FROM user WHERE Host='localhost' AND User=''; mysql> FLUSH PRIVILEGES; mysql> QUIT C:\> C:\mysql\bin\mysqladmin -u root password your_passwordAfter you've set the password, if you want to shut down the mysqld server, you can do so using this command: C:\> mysqladmin --user=root --password=your_password shutdown
不行啊.关了又开了多次.然后敲下面命令: c:\>c:\mysql\bin\mysql mysql 出现以下信息: ERROR 1044:Access denied for user:'@localhost'to database 'mysql' 后面的就无法试了唷!
谢了cngonet(VC的QQ群:4196043); 呵呵.重新安装MYSQL后,root是没有密码的.以root身份进入后: mysql> DELETE FROM user WHERE Host='localhost' AND User=''; mysql> FLUSH PRIVILEGES; mysql> QUIT C:\> C:\mysql\bin\mysqladmin -u root password my_password //ok!!!!!!!!!!!!!!! c:\>c:\mysql\bin\mysql -u root -p Enter password:mypassword mysql>//爽!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> FLUSH PRIVILEGES;
mysql> QUIT
C:\> C:\mysql\bin\mysqladmin -u root password your_passwordAfter you've set the password, if you want to shut down the mysqld server, you can do so using this command: C:\> mysqladmin --user=root --password=your_password shutdown
c:\>c:\mysql\bin\mysql mysql 出现以下信息:
ERROR 1044:Access denied for user:'@localhost'to database 'mysql' 后面的就无法试了唷!
呵呵.重新安装MYSQL后,root是没有密码的.以root身份进入后:
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> FLUSH PRIVILEGES;
mysql> QUIT
C:\> C:\mysql\bin\mysqladmin -u root password my_password
//ok!!!!!!!!!!!!!!!
c:\>c:\mysql\bin\mysql -u root -p
Enter password:mypassword
mysql>//爽!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>mysqladmin -u root password mypassword //给用户设了密码
可是:
>mysql -u root -p
Enterpassword:mypassword //用刚设的密码却进不去.如果说还没有设密成功的话.则:>mysql -u root //如果说没有设成功的话这样就应该可以进的呀.但还是进不了>mysql -u root -p
Enterpassword: //此处直接回车,还是进不了!难以理解,请cngonet(VC的QQ群:4196043)不吝赐教!!!!!!!
mysql\bin\mysql -u root -p mysql
mysql> update user set password=PASSWORD('12345') where user='root';
mysql>flush privileges;
然后再重新登录就行了!!