Tuesday, December 23, 2008
Reset MySQL Password
Keyword: MySQL, Password, MySQL Password, Reset mySQL Password, Root Password, Forgot MySQL Password, MySQL Administration Password Reset
Just chill. Not in a bad situation, You're in right place to solve your problem. Let us see how to reset your mysql administration password.
I know the big question now is, "how to reset mysql password?"
Once I lost my MySQL root password, but was able to recover it in the following way.
Enjoy mySQL-ing.
1. Stop the mysqld daemon process.
# service mysqld stop
or
# /etc/init.d/mysqld stop
or
# chkconfig mysqld off
2. Start the mysqld daemon process with the --skip-grant-tables option.
# mysqld --skip-grant-tables
3. Start the mysql client with the -u root option.
# mysql -u root
4. Execute the following SQL command to set a new password.
mysql> UPDATE mysql.user SET Password=PASSWORD('password') WHERE User='root';
5. Execute the following SQL command to refresh mySQL engine server.
# FLUSH PRIVILEGES;
Enjoy mySQL-ing.
Keyword: MySQL, Password, MySQL Password, Reset mySQL Password, Root Password, Forgot MySQL Password, MySQL Administration Password Reset
Featured Blog Topics:
- MySQL SQL_CACHE - http://kathyravan.blogspot.com/2008/12/mysql-sqlcache.html
- MySQL Query Caching - http://kathyravan.blogspot.com/2008/12/mysql-query-cache.html
- MySQL Show - http://kathyravan.blogspot.com/2008/12/mysql-show-statements.html
- CSV - MySQL Storage Engine - http://kathyravan.blogspot.com/2008/12/csv-mysql-storage-engine.html
- Blackhole - MySQL Storage Engine - http://kathyravan.blogspot.com/2008/12/blackhole-mysql-storage-engine.html
- Memory - MySQL Storage Engine (Formerly Heap Storage Engine) - http://kathyravan.blogspot.com/2008/12/memory-mysql-storage-engine-formerly.html
- Xml in MySQL - http://kathyravan.blogspot.com/2008/03/xml-in-mysql.html
- Forgot mySQL root Password? - http://kathyravan.blogspot.com/2008/02/forgot-mysql-root-password.html
- Samba - Installation & Configuration - http://kathyravan.blogspot.com/2008/02/samba-installation-configuration.html
- Enabling HTTP Authentication in Apache - http://kathyravan.blogspot.com/2008/08/enabling-http-authentication-in-apache.html
- PHP Function: isFTPFileExists (Searching a FILE in FTP) - http://kathyravan.blogspot.com/2008/12/php-function-isftpfileexists-searching.html
- Shell Scripting & Linux - http://kathyravan.blogspot.com/search/label/Shell%20Scripts
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment