FreeBSD - Tutorials, Security
Home   Archives   Sitemap   About   Contact

Recover a lost MySQL root password

Home NEW! Unix Forum News 100 Tips and Tricks Website Development Server Operating Systems Databases
 Ivorde.ROarrow Databases arrowSecurity and BackuparrowRecover a lost MySQL root password 

Article Sections

    Hello, Guest !
User name:
Password:
 
Google

 SSD VPS Hosting - Vpsie.com
 Mo.nitor.me
 Ivorde forum
 FreeBSD Tutorials
 Linux LVM Commands
 Free Shell Accounts
 FreeBSD Project
 FreeBSD Handbook
 Advanced Bash-Scripting Guide
 The OpenBSD Project
 Distrowatch
 FreeBSD Handbook


Apache Webserver Home Page

Posted on: 12 Dec 2007
Author: mandrei
Section: Databases | Security and Backup
Views: 594
Comments: 0 (Add)

Recover a lost MySQL root password
Recovering a MySql root password is very easy, starting mysql server with--skip-grant-tables flag, skip mysql passwor checking

 



Loosing MySql root password could happen to anyone (specially to me :D ).

In this case, we need to start in MySql server in background with --skip-grant-tables flag in order to tell it to ignore any user/password restrictions.

Once MySql server is started with this flag, we can now connect to the database and update the password for user root (you'll probably use this method only if you have forgotten your root's password, not a regular user's password)

But first we need to stop MySql server, otherwise we cannot start it again.

FreeBSD: Stopping MySQL server

/usr/local/etc/rc.d/mysql-server stop
Stopping mysql.
Waiting for PIDS: 23239, 23239.

Linux (Red Hat): Stopping MySql server

$ service mysqld stop

FreeBSD: Starting MySql server in background with -skip-grant-tables flag

$ /usr/local/libexec/mysqld --skip-grant-tables --user=root &
[1] 32549

Linux: Starting mysql server in background with --skip-grant-tables flag

$ /usr/bin/mysqld_safe --skip-grant-tables &
[1] 6702

The last two FreeBSD - Linux commands will start mysql server without it asking you for a password.

Now start mysql client and change the password for root:

$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.1.20-beta-log FreeBSD port: mysql-server-5.1.20

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> UPDATE user SET Password=PASSWORD('newpassword') WHERE User='root';
Query OK, 0 rows affected (0.00 sec)

This command updates in user table column Password where column User is 'root' with the result from mysql function PASSWORD() and now the password for user root is recovered.

Now stop mysql server, start it in normal mode and try the new password.

Bookmarks: Echo "Recover a lost MySQL root password" around:
del.icio.usdiggFurlYahooMyWebGoogleBookmarksFaceBookTechnocratti
-------------------advertising-----------------

Other articles in Databases / Security and Backup
» How to set up a password for root user in MySql
» How to copy a mysql database using mysqldump
» MySQL table - change or rename MySql table name
» How to backup all mysql databases with one command
» How to calculate difference in days between two dates in MySQL




Contact webmaster regarding this article
Register or Login to post your article
Hello, Guest ! You can Login or Register to www.ivorde.ro!

 Post comment:

Name:
Title:
Comment:
Please type the word you see in the image (anti-spam verification). Refresh the page if you don't understand the word.
Allowed HTML Tags for comments:<p><strong><em><u><h1><h2><h3><h4><h5><h6><img><li>
<ol><ul><span><div><br><ins><del>

0 comment(s) to Recover a lost MySQL root password:

   Latest topics on the forum:
 
   Most viewed articles:
How to copy a mysql database using mysqldump - 9376 views
How to change a user's password in AIX with the output from ECHO command - 8635 views
FreeBSD: Add/remove an additional IP alias - 5609 views
Qmail relay to smarthost: How to route all mail to a smarthost - 3929 views
Print queues in AIX 5L - How to list print queues in AIX - 2885 views

   Latest 10 articles:
Qmail relay to smarthost: How to route all mail to a smarthost - 03 Feb 2009
EXIM 4 relay to smarthost: How to route all mail except local domain - 03 Feb 2009
Windows XP: print LISTEN ports and network connections using netstat - 30 Jan 2009
How to cut out first last n characters from each file name, from a filelist - 04 Nov 2008
Mozilla Firefox3 is now released - 18 Jun 2008
How to switch lower case to upper case and upper case to lower case in a string - 17 Jun 2008
How to rename files/directories to uppercase/lowercase character names - 17 Jun 2008
How to convert lower case to upper case letters in a shell script/command - 17 Jun 2008
Unix,Linux,FreeBSD - How to rename a list of files, replacing spaces inside their names - 12 Jun 2008
How to change a user's password in AIX with the output from ECHO command - 21 May 2008


Archives
» 2007  |  June  |  October  |  November  |  December
» 2008  |  January  |  February  |  March  |  April  |  May  |  June  |  November
» 2009  |  January  |  February



Home | Archives | Sitemap | About | Contact

Designed and developed by Andrei Manescu. Optimized for Mozilla Firefox.  
Copyright 2007 Andrei Manescu
All trademarks and copyrights on this page are owned by their respective owners. Comments are owned by those who posted them.
Valid W3 Document Valid XHTML 1.0 Transitional Valid CSS! The FreeBSD Project Viewable With Any Browser