Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 20-08-2009
Member
 
Join Date: Apr 2009
Posts: 42
Recover lost mysql password

Is there any to recover lost mysql password? I forgot my root password for mySQL database and i want to know the instructions to recover it.
Reply With Quote
  #2  
Old 20-08-2009
Member
 
Join Date: May 2008
Posts: 2,293
Re: Recover lost mysql password

  • Stop the MySQL service :
  • Code:
  • # /etc/init.d/mysql stop
  • Start the MySQL server w/o password :
  • Code:
  • # mysqld_safe --skip-grant-tables &
  • Connect to the MySQL server using the MySQL client :
  • Code:
    # mysql -u root
  • Change root password :
    Code:
  • UPDATE user SET password = password('.......') WHERE user = 'root' AND host='localhost'; (type the new password instead of dots)
  • Stop MySQL server :
    Code:
    # /etc/init.d/mysql stop
  • Reply With Quote
      #3  
    Old 20-08-2009
    Member
     
    Join Date: Jan 2009
    Posts: 199
    Re: Recover lost mysql password

    Access 9X Database Password 1.0 : Access 9X Database Password can instantly recover any MS Access 95/97 (MS Jet 3.0/3.5) database password. You can use standard shortcut keys and menus to select, copy and paste the password.

    Download Access 9X Database Password 1.0
    Reply With Quote
    Reply

      TechArena Community > Software > Software Development
    Tags: , ,



    Thread Tools Search this Thread
    Search this Thread:

    Advanced Search


    Similar Threads for: "Recover lost mysql password"
    Thread Thread Starter Forum Replies Last Post
    How to Enhance Security of Windows and Recover Lost/Forgotten Password bydwpr Windows Software 1 26-04-2011 06:51 PM
    How to recover a Lost Password For Dell Inspiron 1545 Phaedra Hardware Peripherals 5 31-12-2010 02:48 PM
    How to recover lost, partially known DriveCrypt password Svana Networking & Security 5 27-12-2010 02:19 PM
    How do I recover a lost password for Windows buaini Windows Software 1 16-09-2010 05:58 PM
    Mac OS X recover lost password jesse Tips & Tweaks 1 22-01-2009 10:58 PM


    All times are GMT +5.5. The time now is 11:31 AM.