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

Tags: , ,

Sponsored Links



Recover lost mysql password

Software Development


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
Zecho's Avatar
Member
  
Join Date: May 2008
Posts: 2,267
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  
     
         		 
     
          		 
     
      
     
     « Pear mail did not issue mail/expn/vrfy/etrn during connection to MTA
		  
		How to write the form values in Database using C# » 
     
        
     
     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 07: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 06: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 03:59 AM.
     
     
     
     
       
     
     
      
      Contact Us -
				TechArena -
				
				
				
				Privacy Statement -