帐号密码忘记了怎么办

钟武

帐号密码忘记了怎么办

linji

1、[root@linode ~]# /usr/local/mysql/bin/mysql -u root -p
Enter password:

2、mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| LuManager          |
| mysql              |
| performance_schema |
| test               |
+--------------------+
5 rows in set (0.08 sec)

3、mysql> use LuManager
Database changed

4、mysql> select * from LuManager.lu_settings;

5、mysql> UPDATE lu_settings SET deny_ip_access = '0';

修改LUM后台登录密码。
select * from LuManager.lu_users;

UPDATE lu_users SET password = 'dd8eb031789b6a0664709455e7d512ce';

即将密码还原为zijidelu