Forgot your password MySQL for Windows solution is as follows:

2011-05-09  来源:本站原创  分类:Database  人气:105 

1, run the command Net stop mysql service mysql stop
2, into the mysql installation path, bin directory, use the mysqld-nt.exe start, then run the command mysqld-nt - skip-grant-tables
3, open another command into the command line window and execute the mysql, then you can look into the carriage.
4, sequence type: use mysql; update user set password = password ("New password") where user = "root";; flush privileges;; exit
5, using the Task Manager, find the mysqld-nt process, the end of the process!
6, restart the mysql-nt service, net start mysql with the new password can be logged.

相关文章
  • Forgot your password MySQL for Windows solution is as follows: 2011-05-09

    1, run the command Net stop mysql service mysql stop 2, into the mysql installation path, bin directory, use the mysqld-nt.exe start, then run the command mysqld-nt - skip-grant-tables 3, open another command into the command line window and execute

  • Forgot your password MYSQL ROOT 2010-03-18

    Forgot your password MYSQL ROOT UNIX version 1. First stopped mysql # / Etc / rc.d / init.d / mysql stop 2. To - skip-grant-table parameters start mysql # Mysql_safe - skip-grant-table & 3. Change the root password 123456 # Mysql mysql mysql> UPDAT

  • Forgot your password mysql 2010-06-25

    1. KILL off system in the MySQL process; 2. At the command prompt (CMD), to enter into MYSQL the BIN directory with the following command to start MySQL, do not check the permissions on the way to start; mysqld-nt - skip-grant-tables 3. And then re-o

  • Forgot your password mysql how do? 2010-07-17

    When the forgotten password mysql mysql-Front can link time to implement update mysql.user set password = PASSWORD ('root') where User = 'root' Run in myfront Then restart the service is ok! ! !

  • Forgot your password MySQL solutions 2010-09-09

    Under the windows: Open a command line window, stop the mysql service: Net stop mysql The installation path to the mysql start mysql, the directory in the bin to use mysqld-nt.exe start the implementation of the command line window: mysqld-nt - skip-

  • Forgot your password ucenter founder simple solution 2010-03-30

    ucenter + uchome + discuz architecture test system, sometimes for a long time, not, forgotten password, depressed. . Specifically study a little, use the following method is very simple to solve. Find ucenter under the data / config.inc.php Find UC_F

  • Forgot your password solution windows 2010-11-28

    Solution one, with the net command (assuming the user name Forgot your password abcd) <span lang = "EN-US" "FONT-SIZE: 9pt; COLOR: # 333333; LINE-HEIGHT: 150%; FONT-FAMILY:" '"; LETTER-SPACING: 0.35pt; mso-font-kerning: 0pt; ms

  • Windows forgotten password mysql solution 2010-08-12

    If you forget the root MySQL password, you can reset the following way: 1.KILL out system in the MySQL process is as follows: a. Click the Desktop toolbar to open the task bar manager. b. the process from the Task Manager to find mysqld-nt.exe proces

  • Forgot your password windows solutions 2010-11-28

    One solution, using net command (assuming the user name Forgot your password abcd) <span lang = "EN-US" "FONT-SIZE: 9pt; COLOR: # 333333; LINE-HEIGHT: 150%; FONT-FAMILY:" '"; LETTER-SPACING: 0.35pt; mso-font-kerning: 0pt; mso-b

  • MySQL database password forgotten the original solution from [bit network], reprinted, please retain the original link: http://soft.chinabyte.com/database/320/11 2010-12-18

    The following article introduces the MySQL database password in forgot the circumstances of their practical solutions. If you encountered in practice similar to the situation, then the following articles for you must be very useful, I hope will give

  • MYsql 1045 windows xp problem solution 2011-04-28

    MYsql 1045 issue: solution windows xp windows operating system is installed in the mysql database, run into Error 1045 (28000) Access Denied for user'root '@' localhost '(Using password: NO) error, you need to reset your password. LAMP configuration

  • Forgot your password or mysql report 'Access denied for user' root '@' localhost '(using password: YES)' 2011-07-08

    Forgot your password or mysql report 'Access denied for user' root '@' localhost '(using password: YES)'. Method One: # / Etc / init.d / mysql stop # Mysqld_safe - user = mysql - skip-grant-tables - skip-networking & # Mysql-u root mysql mysql> UPD

  • You forgot your password? 2010-11-28

    In daily operation, we often have to enter a wide variety of password, for example, to enter a password at boot time, QQ when they first enter a password if you forget the password, it may not take the machine, open the file, can not chat ..., may al

  • Forgot your password? 2010-11-28

    In daily operations, we often have to enter a wide variety of password, for example, to enter a password at boot time, QQ when they first enter a password if you forget the password, it may not take the machine, open the file, can not chat ..., may a

  • MySQL in Windows, start and stop methods 2010-09-08

    MySQL in Windows, start and stop methods <script type="text/javascript"> document.body.oncopy = function () (if (window.clipboardData) (setTimeout (function () (var text = clipboardData.getData ("text"); if (text & ; & te

  • MySQL on Windows, free installation and configuration 2010-10-31

    1, the software is downloaded to the official website mysql MySQL decompression package, mysql-noinstall-5.0.22-win32.zip Then extract to C: \ mysql MySQL database, which is the entire contents. 2, the configuration First we look at MySQL's root dire

  • Open the IIS Web site domain name or IP deployment requires a user name or password to access the solution 2010-11-10

    IIS to deploy services or projects, if not pay attention as the control authority is very likely to cause confusion permission. Problem phenomenon: 1, each input domain name or IP is always asked to enter user name or password to open. The solution:

  • MySQL on Windows start and stop methods 2010-09-08

    MySQL on Windows start and stop methods MySQL is that it can be more fun that starts with a variety of ways, of course, it can also be turned off in many ways. Here I start MySQL several simple ways to talk about, hoping to provide some reference. Fi

  • zz how to install multiple MySQL on Windows 2011-04-25

    Installed version of this article in order to avoid mysql (Without installer), for example, on how to install multiple MySQL on Windows to explain. Free installation version of mysql (Without installer), install the package file name similar to mysql

  • Mysql For Windows安装图解 2013-10-04

    演示安装版本:mysql-5.5.20-win32.msi(目前是mysql for windows的最新版) 安装环境:Windows Server 2003 SP2 32位 Mysql下载地址:http://www.mysql.com/downloads/mysql/ 安装文件如下图所示,直接双击; 下一步; 勾选接受协议,下一步; 三种安装模式:Typical(典型安装).Custom(自定义安装).Complete(完全安装) 选择Custom,然后下一步; 这一步需要选择Mysql程序