Instructions to reset mysql password

View: 753    Dowload: 0   Comment: 0   Post by: naruto  
Author: none   Category: MySQL   Fields: Other

0 point/2 review File has been tested

share articles on Instructions to reset mysql password

Introduction

Windows Server I.

B1 :
- Stop mysql service
+ C : \ > net stop mysql
or:
+ Start - > Run - > services.msc . Find the service mysql - > Stop .

B2 :
- At the mysql bin directory , usually C: \ Program Files \ MySQL \ MySQL Server 5.0 \ bin . Type as follows :
+ C : \ Program Files \ MySQL \ MySQL Server 5.0 \ bin > mysqld - nt - skip- grant - tables

Remains current DOS screen and open a new DOS screen .

B3 :
- Open a new DOS screen , type :
+ C : \ Program Files \ MySQL \ MySQL Server 5.0 \ bin > mysql - uroot

After typing the command on the mysql are logged in , now perform a change password for mysql .

B4 :

mysql > use mysql ;
mysql > update user set Password = PASSWORD ( ' new_pass ' ) WHERE User = ' root' ;
mysql > flush privileges ;


Ok done .
+ mysql > exit

After the process is complete, remember mysql - nt.exe stop then start the mysql service .

II . Linux Server

B1 : Stop mysql :
# service mysql stop

B2 : Running mysql in safe_mode mode
# mysqld_safe - skip- grant - tables - skip- networking
( If Ubuntu , use safe_mysqld )

B3 : In the mysql root user .
# / usr / bin / mysql - uroot

B4 : Reset passwd :
# mysql > use mysql ;
# mysql > update user set Password = PASSWORD ( ' new_pass ' ) WHERE User = ' root' ;
# mysql > flush privileges ;

B5 : Stop mysql pid safe_mode :
# / usr / bin / killall mysqld
# / usr / bin / killall -9 mysqld

B6 : Start mysql :
# service mysql start

Instructions to reset mysql password

Instructions to reset mysql password Posted on 24-03-2014  share articles on Instructions to reset mysql password 5/10 753

Comment:

To comment you must be logged in members.

Files with category

 

File suggestion for you

File top downloads

logo codetitle
Codetitle.com - library source code to share, download the file to the community
Copyright © 2015. All rights reserved. codetitle.com Develope by Vinagon .Ltd