How do I retrieve my MySQL username and password

Question

I lost my MySQL username and password  How do I retrieve it

User · Accepted Answer

Stop the MySQL process  Start the MySQL process with the --skip-grant-tables option  Start the MySQL console client with the -u root option   List all the users  SELECT   FROM mysql user   Reset password  UPDATE mysql user SET Password PASSWORD   password    WHERE User   username      But DO NOT FORGET to  Stop the MySQL process Start the MySQL Process normally  i e  without the --skip-grant-tables option   when you are finished   Otherwise  your database s security could be compromised

User · Answer

Although a strict  logical  computer science ish interpretation of the op s question would be to require both  How do I retrieve my MySQL username  and  password  - I thought It might be useful to someone to also address the OR interpretation  In other words      1  How do I retrieve my MySQL username   OR  2  password  This latter condition seems to have been amply addressed already so I won t bother with it  The following is a solution for the case  How do i retreive my MySQL username  alone  HIH   To find your mysql username run the following commands from the mysql shell      SELECT User FROM mysql user   it will print a table of all mysql users

User · Answer

IF you happen to have ODBC set up  you can get the password from the ODBC config file   This is in  etc odbc ini for Linux and in the Software ODBC folder in the registry in Windows  there are several - it may take some hunting

User · Answer

While you can t directly recover a MySQL password without bruteforcing  there might be another way - if you ve used MySQL Workbench to connect to the database  and have saved the credentials to the  vault   you re golden   On Windows  the credentials are stored in  APPDATA  MySQL Workbench workbench user data dat - encrypted with CryptProtectData  without any additional entropy   Decrypting is easy peasy   std  vector lt unsigned char gt  decrypt BYTE  input  size t length        DATA BLOB inblob   length  input        DATA BLOB outblob       if   CryptUnprotectData  amp inblob  NULL  NULL  NULL  NULL  CRYPTPROTECT UI FORBIDDEN   amp outblob                 throw std  runtime error  Couldn t decrypt               std  vector lt unsigned char gt  output length       memcpy  amp output 0   outblob pbData  outblob cbData        return output      Or you can check out this DonationCoder thread for source   executable of a quick-and-dirty implementation

User · Answer

Unfortunately your user password is irretrievable  It has been hashed with a one way hash which if you don t know is irreversible  I recommend go with Xenph Yan above and just create an new one   You can also use the following procedure from the manual for resetting the password for any MySQL root accounts on Windows      Log on to your system as Administrator    Stop the MySQL server if it is running  For a server that is running as a Windows service  go to the Services manager                 Start Menu -  Control Panel -  Administrative Tools -  Services   Then find the MySQL service in the list  and stop it  If your server is not running as a service  you may need to use the Task Manager to force it to stop    Create a text file and place the following statements in it  Replace the password with the password that you want to use   UPDATE mysql user SET Password PASSWORD  MyNewPass   WHERE User  root   FLUSH PRIVILEGES    The UPDATE and FLUSH statements each must be written on a single line  The UPDATE statement resets the password for all existing root accounts  and the FLUSH statement tells the server to reload the grant tables into memory  Save the file  For this example  the file will be named C  mysql-init txt  Open a console window to get to the command prompt            Start Menu -  Run -  cmd  Start the MySQL server with the special --init-file option   C   gt  C  mysql bin mysqld-nt --init-file   C  mysql-init txt   If you installed MySQL to a location other than C  mysql  adjust the command accordingly   The server executes the contents of the file named by the --init-file option at startup  changing each root account password   You can also add the --console option to the command if you want server output to appear in the console window rather than in a log file   If you installed MySQL using the MySQL Installation Wizard  you may need to specify a --defaults-file option   C   gt   C  Program Files MySQL MySQL Server 5 0 bin mysqld-nt exe  --defaults-file  C  Program Files MySQL MySQL Server 5 0 my ini  --init-file C  mysql-init txt   The appropriate --defaults-file setting can be found using the Services Manager      Start Menu -  Control Panel -  Administrative Tools -  Services   Find the MySQL service in the list  right-click on it  and choose the Properties option  The Path to executable field contains the --defaults-file setting  After the server has started successfully  delete C  mysql-init txt  Stop the MySQL server  then restart it in normal mode again  If you run the server as a service  start it from the Windows Services window  If you start the server manually  use whatever command you normally use    You should now be able to connect to MySQL as root using the new password

User · Answer

An improvement to the most useful answer here      1  No need to restart the mysql server    2  Security concern for a MySQL server connected to a network   There is no need to restart the MySQL server   use FLUSH PRIVILEGES  after the update mysql user statement for password change      The FLUSH statement tells the server to reload the grant tables into memory so that it notices the password change    The --skip-grant-options 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     from  reference  resetting-permissions-generic

User · Answer

If you have root access to the server where mysql is running you should stop the mysql server using this command  sudo service mysql stop   Now start mysql using this command  sudo  usr sbin mysqld --skip-grant-tables  --skip-networking  amp    Now you can login to mysql using   sudo mysql FLUSH PRIVILEGES  SET PASSWORD FOR  root   localhost    PASSWORD  MyNewPass      Full instructions can be found here http   www techmatterz com recover-mysql-root-password

User · Answer

Do it without down time  Run following command in the Terminal to connect to the DBMS  you need root access      sudo mysql -u root -p    run update password of the target user  for my example username is mousavi and it s password must be 123456      UPDATE mysql user SET authentication string PASSWORD  123456   WHERE user  mousavi       at this point you need to do a flush to apply changes     FLUSH PRIVILEGES    Done  You did it without any stop or restart mysql service

User · Answer

Login MySql from windows cmd using existing user           mysql -u username -p             Enter password           Then run the following command   mysql gt  SELECT   FROM mysql user    After that copy encrypted md5 password for corresponding user and there are several online password decrypted application available in web  Using this decrypt password and use this for login in next time  or update user password using flowing command   mysql gt  UPDATE mysql user SET Password PASSWORD   password    WHERE User   username      Then login using the new password and user

User · Answer

Save the file  For this example  the file will be named C  mysql-init txt  it asking administrative permisions for saving the file

[mysql] How do I retrieve my MySQL username and password?

Examples related to mysql