手册上的方法,你试试看
If you set a root password previously, but have forgotten what it was, you can set a new password. The following procedure is for Windows systems. The procedure for Unix systems is given later in this section. The procedure under Windows: Log on to your system as Administrator. Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager: Start Menu -> Control Panel -> Administrative Tools -> ServicesThen find the MySQL service in the list, and stop it. If your server is not running as a service, you may need to use the Task Manager to force it to stop. Create a text file and place the following command within it on a single line: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');Save the file with any name. For this example the file will be C:\mysql-init.txt. Open a console window to get to the DOS command prompt: Start Menu -> Run -> cmdWe are assuming that you installed MySQL to C:\mysql. If you installed MySQL to another location, adjust the following commands accordingly. At the DOS command prompt, execute this command: C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txtThe contents of the file named by the --init-file option are executed at server startup, changing the root password. After the server has started successfully, you should delete C:\mysql-init.txt. If you install MySQL using the MySQL Installation Wizard, you may need to specify a --defaults-file option: C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe"
--defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini"
--init-file=C:\mysql-init.txtThe appropriate --defaults-file setting can be found using the Services Manager: Start Menu -> Control Panel -> Administrative Tools -> ServicesFind the MySQL service in the list, right-click on it, and choose the Properties option. The Path to executable field contains the --defaults-file setting. Stop the MySQL server, then restart it in normal mode again. If you run the server as a service, start it from the Windows Services window. If you start the server manually, use whatever command you normally use. You should be able to connect using the new password.
If you set a root password previously, but have forgotten what it was, you can set a new password. The following procedure is for Windows systems. The procedure for Unix systems is given later in this section. The procedure under Windows: Log on to your system as Administrator. Stop the MySQL server if it is running. For a server that is running as a Windows service, go to the Services manager: Start Menu -> Control Panel -> Administrative Tools -> ServicesThen find the MySQL service in the list, and stop it. If your server is not running as a service, you may need to use the Task Manager to force it to stop. Create a text file and place the following command within it on a single line: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');Save the file with any name. For this example the file will be C:\mysql-init.txt. Open a console window to get to the DOS command prompt: Start Menu -> Run -> cmdWe are assuming that you installed MySQL to C:\mysql. If you installed MySQL to another location, adjust the following commands accordingly. At the DOS command prompt, execute this command: C:\> C:\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txtThe contents of the file named by the --init-file option are executed at server startup, changing the root password. After the server has started successfully, you should delete C:\mysql-init.txt. If you install MySQL using the MySQL Installation Wizard, you may need to specify a --defaults-file option: C:\> "C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt.exe"
--defaults-file="C:\Program Files\MySQL\MySQL Server 5.0\my.ini"
--init-file=C:\mysql-init.txtThe appropriate --defaults-file setting can be found using the Services Manager: Start Menu -> Control Panel -> Administrative Tools -> ServicesFind the MySQL service in the list, right-click on it, and choose the Properties option. The Path to executable field contains the --defaults-file setting. Stop the MySQL server, then restart it in normal mode again. If you run the server as a service, start it from the Windows Services window. If you start the server manually, use whatever command you normally use. You should be able to connect using the new password.
解决方案 »
- phpmyadmin 数据库表中字段 插入中文出现乱码的问题?
- MySQL 数据,如何移走binlog到一个专门的log目录下?
- 大神们 关于导入数据库 出错 #1064
- 关于字段integer
- 主从同步中load data from master的问题!
- C语言写的Console程式,查询显示MySQL table中的中文内容乱码!
- 请大家帮我分析一下我的my.ini文件
- 如何用=来查询double,float型记录
- 绑定不了自己的数据,各位帮忙看看
- jdbc删除问题实现删除数据库中的表任意一列,不能实现求助
- 我安装的mysql怎么没有winmysqladmin.exe这个程序?
- [翻译]MySQL5.0用户手册——第三章:快速入门
不过我是在linux平台下,我通过将mysql这个库重新建立,就实现了恢复到最初状态,并修改密码,现在已经可以访问了!