MySQL :: MySQL 5.0 Reference Manual :: B.1.4.1 How to Reset the Root Password - The Diigo Meta page

• 12 Jan 15
  

  hassan ansarifar
  • Log on to your system as Administrator.
  • Stop the MySQL server
  • UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root'; FLUSH PRIVILEGES;
  • FLUSH statement tells the  server to reload the grant tables into memory so that it  notices the password change.
  • Resetting the Root Password: Unix Systems

  3 more annotations...

• 11 Nov 14
  

  mysql password reset root

• 26 Aug 14
  

  li mix

  mysql password reset

• 23 Aug 14
  

  Greg Duffy

  mysql

  • How to Reset the Root Password
• 21 Jan 14
  

  Engelbert Tejeda
• 22 Aug 13
  

  Pedro Ferreira

  mysql password security root reset database howto

• 18 Jul 13
  

  Ron Lock
• 

  thisismark
  • 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
  

  dralimohsen
• 09 May 13
  

  Jeff Barczewski
• 30 Jan 13
  
• 29 Nov 12
  

  Julian Elve

  mysql howto

• 10 Nov 12
  

  Jun Li

  mysql password root reset

• 05 Dec 11
  

  quyen_nguyen617
  • C.5.4.1. How to Reset the Root Password
• 01 Nov 11
  

  Matthew York
  • Stop mysqld and restart it with the  --skip-grant-tables  option. This enables anyone to connect without a  password and with all privileges. Because this is  insecure, you might want to use  --skip-grant-tables in  conjunction with  --skip-networking to  prevent remote clients from connecting.
• 27 Sep 11
  

  Syed Ali
• 01 Sep 11
  

  Javier Rodriguez

  Reset MySQL password

  mysql password

• 20 Apr 11
  

  dittonamed
  • mysqld_safe --init-file=/home/me/mysql-init &
• 23 Feb 11
  

  David Barreto

  mysql security

• 16 Dec 10
  

  Phil Garcia

  mysql

• 14 Dec 10
  

  denniszeng2008

  mysql

• 29 Oct 10
  

  konstantinidou

  howto sysadmin mysql password reset root database opensource delicious

• 17 Sep 10
  

  Julius Vaitkevicius

  mysql reset password delicious

• 15 Aug 10
  

  ugrandolini

  mysql root password

• 01 Feb 10
  

  Kevin Styles
• 09 Jan 10
  

  Shawn Skriver

  mysql password howto root reset security reference delicious

• 15 Oct 09
  

  Chris Vertonghen

  reset mysql root passwor

• 07 Aug 09
  

  Roel Ramirez

  mysql recoverpassword

• 30 Jul 09
  

  pietrocigoli

  mysql password database security reference tips sysadmin

• 22 Jun 09
  

  P eter

  permissions mysql password security

• 06 May 09
  

  administration database sysadmin mysql

• 31 Mar 09
  

  Jerry Wong

  MYSQL错误:Error Nr. 1045解决方法
  参看：http://www.issociate.de/board/post/271830/Fw:_Install_MySQL_5.0_Error.html

  mysql

• 20 Jan 09
  

  inutile

  web_design

• 09 Jan 09
  

  John Lewis

  databases passwords mysql

• 11 Dec 08
  

  Yong Zhang

  mysql tutorial user

• 16 Sep 08
  

  Ramesh Babu

  mysql resetRootPswd

• 08 Jul 08
  

  thotfulspot

  mysql

• 27 Jun 08
  

  Damon Snyder

  UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';

  mysql security howto

• 22 Apr 08
  

  Martin Knoller Stocker

  mysql password reset

• 17 Mar 08
  

  mimi .

  mysql

• 14 Mar 08
  

  Markus Laumann

  mysql reference

• 07 Jan 08
  

  Jem Fleming

  resetting mysql root password

  coding design computer webdev trading server database hosting

• 20 Dec 07
  

  Vinicius Andrade

  mysql password

• 19 Dec 07
  

  Glenn Carr
• 25 Nov 07
  

  Kim Woodbridge

  mysql password howto root security reference linux

• 19 Nov 07
  

  Juan Martín

  Reset the root password for mysql database

  mysql password database root

• 13 Nov 07
  

  mysql password howto reference excluded delicious

• 26 Oct 07
  

  McNeal Maddox

  programming mysql

• 13 Oct 07
  

  Israel Saeta Pérez

  Official instructions to reset the mysql root forgotten password.

  mysql resources

• 01 Oct 07
  

  maestrojed

  linux mysql password deliciousImport

• 26 Sep 07
  

  Stuart Cowen

  mysql database password

• 20 Sep 07
  

  Ben Tran

  mysql

• 18 Sep 07
  

  bkeepers

  mysql password

• 23 Aug 07
  

  Carlos Junior

  programming

• 02 Jul 07
  

  Matt Barbadian
• 21 Jun 07
  

  mohakevin

  resetear password de root mysql y permisos

  mysql security sysadmin

• 13 Jun 07
  

  kjleng

  mysql

• 24 May 07
  

  Egyirba H.

  How to Reset the Root Password

  reset root password howto mysql linux

• 23 Apr 07
  

  Maarten Cammaert

  MySQL

• 22 Mar 07
  

  Jason Shein

  Setting permissions

  mysql

• 20 Feb 07
  

  José María Morales

  BASES_DE_DATOS mysql tips

• 10 Jan 07
  

  Ayas

  MySQLのrootパスワード忘れた！　・・ら、頼りにするところ。もうアホかとorz
  

  MySQL 旧はてブ

• 05 Jan 07
  

  Karoly Sz

  SQL

• 03 Nov 06
  

  Serge d'Adesky

  mysql software

• 27 Oct 06
  

  Carlos F Enguix

  links mysql xdev

• 02 Aug 06
  

  Jamie Dinkelacker

  howto mysql reference security

• 27 Jul 06
  

  anycolorilike

  database mysql security tips

• 29 Jun 06
  

  manaburner

  howto mysql root password

• 14 Jun 06
  

  marty williams

  mysql howto password database reference security Root reset

• 14 Nov 05
  

  Marc Medlock

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.