Change MySQL Password via SSH

login ssh, type mysqladmin. A tip if you can not remember mysql password type

mysql -uadmin -p`cat /etc/psa/.psa.shadow`
mysql> USE mysql;
mysql> SELECT * FROM user;
mysql> SET PASSWORD FOR 'username'@'hostname' = PASSWORD('password_here');
mysql> FLUSH PRIVILEGES;

Forgot WordPress Admin Password

Firstly; you need access to your MySQL Server and maybe access to your wp-config.php file in the root of your site.

  1. Go www.md5-creator.com and type in a password you want to use.Example type “123″ then copy. “123 in MD5 :” ’s result is “202cb962ac59075b964b07152d234b70″
  2. Than open your MySQL database, and click the wp_users table
  3. Change “user_pass” value to copied value. In our example “202cb962ac59075b964b07152d234b70″
  4. Now go to your blogĀ and log in :)
Oyun