This link has been bookmarked by 122 people . It was first bookmarked on 02 Aug 2006, by Jamie Dinkelacker.
-
12 Jan 15
-
Log on to your system as Administrator.
-
Stop the MySQL server
-
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; FLUSH PRIVILEGES;
-
FLUSHstatement tells the server to reload the grant tables into memory so that it notices the password change. -
Resetting the Root Password: Unix Systems
-
-
11 Nov 14
-
26 Aug 14
-
23 Aug 14
-
How to Reset the Root Password
-
-
21 Jan 14
-
22 Aug 13
-
18 Jul 13
-
-
how to reset mysql root password of a mysql installation under windows;i ll share what i did to solve the issue,this method was founded on some articles in internet.i ll share those links also as a references for you.
(mysql 5.5)
1.shut down the mysql server.i used windows services to shutdown(since i have intalled it as a windows service).
also you can shut down using
mysqladmin -u root shutdown (pls find the path for the mysql admmin command-usually inside bin directory of mysql installation)
2.mysqld --skip-grant-tables &
this will strt the server in back ground
(in unix environment u have to use
mysqld_safe --skip-grant-tables & instead)
3.now you open the command line and try to connect to the root user with empty password.(at this mode it is possible to log in without the password.)
3.when you logged in u will get a prompt as
mysql>use mysql;
4.mysql> update user set Password=PASSWORD('new-password-here') WHERE User='root';
5.mysqladmin -u root shutdown (it is very important to stop the server at this stage).
6.now start server again and can log in with new password -
1.shut down the mysql server.i used windows services to shutdown(since i have intalled it as a windows service).
also you can shut down using
mysqladmin -u root shutdown (pls find the path for the mysql admmin command-usually inside bin directory of mysql installation)
2.mysqld --skip-grant-tables &
this will strt the server in back ground
(in unix environment u have to use
mysqld_safe --skip-grant-tables & instead)
3.now you open the command line and try to connect to the root user with empty password.(at this mode it is possible to log in without the password.)
3.when you logged in u will get a prompt as
mysql>use mysql;
4.mysql> update user set Password=PASSWORD('new-password-here') WHERE User='root';
5.mysqladmin -u root shutdown (it is very important to stop the server at this stage).
6.now start server again and can log in with new password
-
-
17 Jun 13
-
09 May 13
-
30 Jan 13
-
29 Nov 12
-
10 Nov 12
-
05 Dec 11
-
C.5.4.1. How to Reset the Root Password
-
-
01 Nov 11
-
Stop mysqld and restart it with the
--skip-grant-tablesoption. This enables anyone to connect without a password and with all privileges. Because this is insecure, you might want to use--skip-grant-tablesin conjunction with--skip-networkingto prevent remote clients from connecting.
-
-
27 Sep 11
-
01 Sep 11
-
20 Apr 11
-
mysqld_safe --init-file=/home/me/mysql-init &
-
-
23 Feb 11
-
16 Dec 10
-
14 Dec 10
-
29 Oct 10
-
17 Sep 10
-
15 Aug 10
-
01 Feb 10
-
09 Jan 10
-
15 Oct 09
-
07 Aug 09
-
30 Jul 09
-
22 Jun 09
-
06 May 09
-
31 Mar 09
Jerry WongMYSQL错误:Error Nr. 1045解决方法
参看:http://www.issociate.de/board/post/271830/Fw:_Install_MySQL_5.0_Error.html -
20 Jan 09
-
09 Jan 09
-
11 Dec 08
-
16 Sep 08
-
08 Jul 08
-
27 Jun 08
Damon SnyderUPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
-
22 Apr 08
-
17 Mar 08
-
14 Mar 08
-
07 Jan 08
-
20 Dec 07
-
19 Dec 07
-
25 Nov 07
-
19 Nov 07
-
13 Nov 07
-
26 Oct 07
-
13 Oct 07
Israel Saeta PérezOfficial instructions to reset the mysql root forgotten password.
-
01 Oct 07
-
26 Sep 07
-
20 Sep 07
-
18 Sep 07
-
23 Aug 07
-
02 Jul 07
-
21 Jun 07
-
13 Jun 07
-
24 May 07
-
23 Apr 07
-
22 Mar 07
-
20 Feb 07
-
10 Jan 07
-
05 Jan 07
-
03 Nov 06
-
27 Oct 06
-
02 Aug 06
-
27 Jul 06
-
29 Jun 06
-
14 Jun 06
-
14 Nov 05
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.