Guide to Resetting Database Passwords

In routine database management, resetting a database password is a common and necessary task. Whether for security reasons, password forgetfulness, or other causes, knowing how to reset database passwords is crucial for database administrators. This document will detail how to reset passwords for MariaDB, PostgreSQL, and Redis databases. When using ServBay, note that different versions of databases have different configurations and paths.

Resetting MariaDB Password

MariaDB is a fork of MySQL, a popular relational database management system. The following steps will guide you on how to reset the password for MariaDB.

The example will use version MariaDB 10.11.

Steps to Reset MariaDB Password

1. Stop MariaDB Service:

   servbayctl stop mariadb 10.11

2. Start MariaDB in Safe Mode:

   /Applications/ServBay/package/mariadb/10.11/current/bin/mysqld_safe --skip-grant-tables --skip-networking &

3. Log in to MariaDB:

   /Applications/ServBay/package/mariadb/10.11/current/bin/mysql -u root

4. Reset Password:

   FLUSH PRIVILEGES;
   ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';
   FLUSH PRIVILEGES;

5. Exit MariaDB:

   exit;

6. Stop MariaDB Safe Mode:

   servbayctl stop mariadb 10.11

7. Restart MariaDB Service:

   servbayctl start mariadb 10.11

Resetting PostgreSQL Password

PostgreSQL is a powerful, open-source object-relational database system. The following steps will guide you on how to reset the password for PostgreSQL.

The example will use version PostgreSQL 16.

Steps to Reset PostgreSQL Password

1. Find PostgreSQL Admin Account

Open the ServBay management panel and go to Settings -> Database Passwords to find the PostgreSQL Account.

2. Stop PostgreSQL Service:

   servbayctl stop postgresql 16

3. Back up pg_hba.conf File:

   cp /Applications/ServBay/db/postgresql/16/pg_hba.conf /Applications/ServBay/db/postgresql/16/pg_hba.conf.bak

4. Edit pg_hba.conf File to Disable Password Authentication:

   sed -i '' 's/scram-sha-256/trust/g' /Applications/ServBay/db/postgresql/16/pg_hba.conf

5. Start PostgreSQL:

   servbayctl start postgresql 16

6. Access psql Command Line:

   psql -h /Applications/ServBay/tmp -U <user from step 1> postgres
   # Example: psql -h /Applications/ServBay/tmp -U servbay postgres

7. Reset Password:

   ALTER USER <user from step 1> WITH PASSWORD 'new_password';
   -- Example: ALTER USER servbay WITH PASSWORD 'new_password';

8. Exit psql:

   \q

9. Stop PostgreSQL Service:

   servbayctl stop postgresql 16

10. Restore pg_hba.conf File:

    cp /Applications/ServBay/db/postgresql/16/pg_hba.conf.bak /Applications/ServBay/db/postgresql/16/pg_hba.conf

11. Restart PostgreSQL Service:

    servbayctl start postgresql 16

Resetting Redis Password

Redis is an open-source, in-memory data structure store used as a database, cache, and message broker. The following steps will guide you on how to reset the password for Redis.

Steps to Reset Redis Password

1. Open Redis Configuration File:

   vim /Applications/ServBay/package/etc/redis/redis.conf

2. Find and Modify the requirepass Configuration:

   requirepass new_password

3. Save and Exit Editor.

4. Restart Redis Service:

   servbayctl restart redis -all

Summary

Resetting database passwords is an important task in database management. This document provides detailed instructions on how to reset passwords for MariaDB, PostgreSQL, and Redis databases. When using ServBay, be mindful that different versions of databases have different configurations and paths. By following these steps, you can ensure the security and accessibility of your databases. Whether for security reasons or due to forgotten passwords, mastering these skills will help you manage database systems more effectively.