Differences

This shows you the differences between two versions of the page.

@@ Line 1: / Line 1: @@
+====== Mysql Mariadb Cacti PW Reset ======
+Resetting mysql/mariaDB passwords.
+----
+====== MySQL/MariaDB Root PW ======
+To reset a forgotten root password on MySQL/MariaDB:
+  * Determine if it is mysql vs mariadb<code bash>mysql --version</code>
+  * Stop the database
+    * MariaDB<code bash>systemctl stop mariadb</code>
+    * MySQL<code bash>systemctl stop mysql</code>
+  * Start the database manually, skipping grants and networking<code bash>mysqld_safe --skip-grant-tables --skip-networking &</code>
+  * Login as root (should not be prompted)<code bash>mysql -u root</code>
+    * Set new root password for the database<code bash>MariaDB [(none)]> update mysql.user set password=password('MyNewPass') where user='root';</code>
+    * Flush privileges<code bash>MariaDB [(none)]> flush privileges;</code>
+    * Exit the database<code bash>MariaDB [(none)]> exit</code>
+  * Stop the database, using the newly set pw(prompted)<code bash>mysqladmin shutdown -u root -p</code>
+  * Start the database server with normal settings
+    * MariaDB<code bash>systemctl start mariadb</code>
+    * MySQL<code bash>systemctl start mysql</code>
+----
+====== Cacti ======
+Resetting the cacti local admin pw.
+  * Login to the cacti database<code bash>mysql -u root -p cacti</code>
+    * Requires knowledge of the mysql root pw
+  * Set a new password for the cacti admin<code bash>MariaDB [cacti]> update user_auth set password=md5('newpasswordhere') where username='admin';</code>
+----