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!!!!!!!!!!!!!!!!!