Hot File

Instructions to reset mysql password

View: 565    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 565

Comment:

To comment you must be logged in members.

Files with category

  • SQL Query to Find Nth Highest Salary of Employee with java

    View: 196    Download: 0   Comment: 0   Author: none  

    SQL Query to Find Nth Highest Salary of Employee with java

    Category: MySQL
    Fields: Other

    0/0 review
    This is a very common interview question if you are going for the role at junior level. Most of the people learn it character by character, but few understand how this query works.

  • World OOP With PHP and MySQL

    View: 956    Download: 0   Comment: 0   Author: none  

    World OOP With PHP and MySQL

    Category: MySQL
    Fields: Other

    0.32142857142857/14 review
    Setting up the skeleton of our class is fairly simple once we figure out exactly what we need.

  • How to Build a Newsletter System With PHP and MySQL

    View: 1183    Download: 0   Comment: 0   Author: none  

    How to Build a Newsletter System With PHP and MySQL

    Category: MySQL
    Fields: Other

    1.125/4 review
    When starting any project, I like to layout the folders before I start coding, so lets do that now.

  • Top 20+ MySQL Best Practices that can not be ignored

    View: 893    Download: 0   Comment: 0   Author: none  

    Top 20+ MySQL Best Practices that can not be ignored

    Category: MySQL
    Fields: Other

    1.6666666666667/3 review
    Database operations often tend to be the main bottleneck for most web applications today.

  • Create a PHP/MySQL Powered Forum from Scratch

    View: 1040    Download: 0   Comment: 0   Author: none  

    Create a PHP/MySQL Powered Forum from Scratch

    Category: MySQL
    Fields: Other

    1.5/3 review
    In this tutorial, we're going to build a PHP/MySQL powered forum from scratch.

  • Triggers Introduction to MySQL

    View: 256    Download: 0   Comment: 0   Author: none  

    Triggers Introduction to MySQL

    Category: MySQL
    Fields: Other

    1.6666666666667/3 review
    I would guess, even armed with this knowledge, that a good many of you are not taking advantage of triggers with MySQL.

  • How to Stored Procedures in MySQL 5

    View: 247    Download: 0   Comment: 0   Author: none  

    How to Stored Procedures in MySQL 5

    Category: MySQL
    Fields: Other

    2.25/2 review
    MySQL 5 introduced a plethora of new features - stored procedures being one of the most significant. In this tutorial, we will focus on what they are, and how they can make your life easier.

  • The strength of the PDO and. MySQLi: Which Should You Use?

    View: 267    Download: 0   Comment: 0   Author: none  

    The strength of the PDO and. MySQLi: Which Should You Use?

    Category: MySQL
    Fields: Other

    1.5/3 review
    When accessing a database in PHP, we have two choices: MySQLi and PDO. So what should you know before choosing one?

 
Newsletter Email

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