How to reset mysql password?

[Yarn]

Sponsored Links

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.

[Praetor]

SET PASSWORD Syntax

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().

[Katty]

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/host_name.pid`

• 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.