Results 1 to 3 of 3

Thread: How to reset mysql password?

  1. #1
    Join Date
    Jan 2009

    How to reset mysql password?

    MySQL Server will be installed with root superuser without any password.I can connect to MySQL server as root without any password. How do i set or reset the password for mysql?

    Thank you for any suggestions.

  2. #2
    Join Date
    Apr 2008

    Re: How to reset mysql password?

    SET PASSWORD [FOR user] =
    PASSWORD('some password')
    | OLD_PASSWORD('some password')
    | 'encrypted password'
    The SET PASSWORD statement assigns a password to an existing MySQL user account. If the password is specified using the PASSWORD() or OLD_PASSWORD() function, the literal text of the password should be given. If the password is specified without using either function, the password should be the already-encrypted password value as returned by PASSWORD().

  3. #3
    Join Date
    May 2008

    Re: How to reset mysql password?

    Following are the steps for resetting password in Unix environment:
    • Log on to your system as either the Unix root user or as the same user that the mysqld server runs as
    • Locate the .pid file that contains the server's process ID. The exact location and name of this file depend on your distribution, hostname, and configuration. Common locations are /var/lib/mysql/, /var/run/mysqld/, and /usr/local/mysql/data/.You can stop the MySQL server by sending a normal kill (not kill -9) to the mysqld process, using the pathname of the .pid file in the following command:
      shell> kill `cat /mysql-data-directory/`
    • Restart the MySQL server with the special --skip-grant-tables option:
      shell> mysqld_safe --skip-grant-tables &
    • Set a new password for the root@localhost MySQL account:
      shell> mysqladmin -u root flush-privileges password "newpwd"
      Replace "newpwd'' with the actual root password that you want to use.

Similar Threads

  1. Impact of AD minimum password age to password reset
    By cmatthews18 in forum Networking & Security
    Replies: 1
    Last Post: 14-03-2012, 02:33 PM
  2. Replies: 9
    Last Post: 17-01-2011, 02:18 PM
  3. Need Password Reset Disk to change password for Windows 7
    By Alfanumeric in forum Operating Systems
    Replies: 3
    Last Post: 11-01-2011, 04:06 PM
  4. Replies: 3
    Last Post: 07-11-2009, 09:36 PM
  5. Reset CMOS password requires reset bios?
    By Aditya kumar in forum Operating Systems
    Replies: 2
    Last Post: 04-08-2009, 06:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts