MySQL & Postgres Enhancements (#5)

* remove mysql login script and add password script

* move excess mysql password query to new script

* add db admin folders

* add postgres

* add mongo admins script

* Commit from GitHub Actions (Ruff)

* update tests for mysql and postgres

* update tests for mysql and postgres

---------

Co-authored-by: github-actions <41898282+github-actions[bot]@users.noreply.github.com>

1 files changed, 31 insertions, 0 deletions

diff --git a/databases/passwords/postgres/README.org b/databases/passwords/postgres/README.org
new file mode 100644
index 0000000..694aa4e
--- /dev/null
+++ b/databases/passwords/postgres/README.org
@@ -0,0 +1,31 @@
+#+title: Postgres Passwords
+
+* =passwords.sql=
+
+#+begin_src sql
+SELECT *
+FROM pg_settings
+WHERE name LIKE 'password_%';
+#+end_src
+
+#+begin_src
+| name                | setting       | unit | category                                        | short_desc                                      | extra_desc | context | vartype | source  | min_val | max_val | enumvals            | boot_val      | reset_val     | sourcefile | sourceline | pending_restart |
+|---------------------+---------------+------+-------------------------------------------------+-------------------------------------------------+------------+---------+---------+---------+---------+---------+---------------------+---------------+---------------+------------+------------+-----------------|
+| password_encryption | scram-sha-256 |      | Connections and Authentication / Authentication | Chooses the algorithm for encrypting passwords. |            | user    | enum    | default |         |         | {md5,scram-sha-256} | scram-sha-256 | scram-sha-256 |            |            | false           |
+#+end_src
+
+#+begin_src sql
+SELECT 
+    usename AS user_name,
+    passwd AS password,
+    valuntil AS valid_until,
+    useconfig AS user_config
+FROM pg_shadow;
+#+end_src
+
+#+begin_src
+| user_name | password                                                                                                                              | valid_until            | user_config |
+|-----------+---------------------------------------------------------------------------------------------------------------------------------------+------------------------+-------------|
+| cmc       |                                                                                                                                       |                        |             |
+| testuser  | SCRAM-SHA-256$4096:+NSpEU+8afhJ4BUTkzdKeg==$FGIRcTWr89b42qkLUl4Ntfp4RUpoc3GIpLHqJl/fWZE=:o1UM8YiEj5SLV5l/geMuqXMRi6onWazryn/l+LXYMxU= | 2025-12-31 00:00:00-06 |             |
+#+end_src