User password recovery and management in PHP

1). In/etc/my.ini, add

Skip-grant-tables

2). Mysql-u root-p (no password required)

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| Information_schema |
| Cacti |
| Gfxpv_database |
| MySQL |
| Test |
+--------------------+
5 rows in Set (0.08 sec)

3). Select Cacti Database

mysql> use cacti;
Reading table information for completion of table and column names
Can turn off this feature to get a quicker startup with-a

Database changed

4). Show all tables in cacti database

Mysql> Show tables;
+---------------------------+
| Tables_in_cacti |
+---------------------------+
| Cdef |
| Cdef_items |
| Colors |
| Data_input |
| Data_input_data |
| Data_input_fields |
| data_local |
| Data_template |
| Data_template_data |
| Data_template_data_rra |
| DATA_TEMPLATE_RRD |
| graph_local |
| Graph_template_input |
| Graph_template_input_defs |
| Graph_templates |
| Graph_templates_gprint |
| Graph_templates_graph |
| Graph_templates_item |
| Graph_tree |
| Graph_tree_items |
| Host |
| Host_graph |
| Host_snmp_cache |
| Host_snmp_query |
| Host_template |
| Host_template_graph |
| Host_template_snmp_query |
| Plugin_config |
| Plugin_db_changes |
| Plugin_hooks |
| Plugin_realms |
| Poller |
| Poller_command |
| Poller_item |
| Poller_output |
| Poller_reindex |
| Poller_time |
| RRA |
| RRA_CF |
| Settings |
| settings_graphs |
| Settings_tree |
| Snmp_query |
| Snmp_query_graph |
| SNMP_QUERY_GRAPH_RRD |
| SNMP_QUERY_GRAPH_RRD_SV |
| SNMP_QUERY_GRAPH_SV |
| User_auth |
| user_auth_perms |
| User_auth_realm |
| User_log |
| Version |
+---------------------------+
All rows in Set (0.00 sec)

5). Select all user in the User_auth table (cacti database)

Mysql> select * from User_auth;
+----+----------+----------------------------------+-------+---------------+----------------------+-----------+ -----------+--------------+----------------+------------+---------------+--------------+--------------+-------- ----------------+---------+
| ID | Username | password | Realm | Full_name | Must_change_password | Show_tree | Show_list | Show_preview | graph_settings | login_opts | policy_graphs | Policy_trees | policy_hosts | Policy_graph_templates | Enabled |
+----+----------+----------------------------------+-------+---------------+----------------------+-----------+ -----------+--------------+----------------+------------+---------------+--------------+--------------+-------- ----------------+---------+
| 1 | admin |     e10adc3949ba59abbe56e057f20f883e | 0 |                      Administrator | | On | On | On |          On |             1 |            1 |            1 |                      1 | 1 | On |
|  3 | guest    | 43e9a4ab75570f5b                  |     0 | Guest Account | on                   | on        | on        | on           | on             |           3 |             1 |             1 |             1 |                       1 |         |
+----+----------+----------------------------------+-------+---------------+----------------------+-----------+ -----------+--------------+----------------+------------+---------------+--------------+--------------+-------- ----------------+---------+
2 rows in Set (0.00 sec)

6). Update "Guest" account with password "Guest"

mysql> Update User_auth set Password=password (' guest ') where username= ' guest ';
Query OK, 1 row Affected (0.00 sec)
Rows matched:1 changed:1 warnings:0

mysql> flush Privileges;
Query OK, 0 rows Affected (0.00 sec)

mysql> flush Privileges;

Query OK, 0 rows Affected (0.00 sec)

mysql> Update User_auth Set Password=password (' admin ') where username= ' admin ';
Query OK, 1 row Affected (0.00 sec)
Rows matched:1 changed:1 warnings:0

mysql> flush Privileges;
Query OK, 0 rows Affected (0.00 sec)

Still not working!!!!!!!!!!!!!!!!!