When setting up the first User, the Password is getting truncated to 32 (or 31) Characters without Warning !
There is also currently no Instruction at all in how to reset a Password.
This is what I did, assuming you only have the Admin first User:
podman exec -it linguacafe-mariadb /bin/bash
mariadb --host=localhost --user=linguacafe --password=XXXXXXXXXXXXXXXXXXXXX
MariaDB [(none)]> USE linguacafe;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [linguacafe]> SHOW tables;
+--------------------------------+
| Tables_in_linguacafe |
+--------------------------------+
| books |
| cache |
| cache_locks |
| chapters |
| daily_achivements |
| deepl_caches |
| dict_jp_jmdict |
| dict_jp_jmdict_readings |
| dict_jp_jmdict_words |
| dict_jp_kanji |
| dict_jp_kanji_radicals |
| dictionaries |
| encountered_words |
| example_sentences |
| failed_jobs |
| font_types |
| goal_achievements |
| goals |
| job_batches |
| jobs |
| migrations |
| password_resets |
| personal_access_tokens |
| phrases |
| queue_stats_chapter_processing |
| settings |
| users |
+--------------------------------+
27 rows in set (0.000 sec)
MariaDB [linguacafe]> SELECT * from users;
+----+-------+---------------------+-------------------+--------------------------------------------------------------+----------------+---------------------+---------------------+-------------------+----------+------------------+--------------------------------------+
| id | name | email | email_verified_at | password | remember_token | created_at | updated_at | selected_language | is_admin | password_changed | uuid |
+----+-------+---------------------+-------------------+--------------------------------------------------------------+----------------+---------------------+---------------------+-------------------+----------+------------------+--------------------------------------+
| 1 | admin | admin@MYDOMAIN.TLD | NULL | $2y$10XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | NULL | 2026-01-17 19:11:44 | 2026-01-17 19:11:44 | spanish | 1 | 1 | 158c23e5-c539-4f09-a087-81436cedb79b |
+----+-------+---------------------+-------------------+--------------------------------------------------------------+----------------+---------------------+---------------------+-------------------+----------+------------------+--------------------------------------+
1 row in set (0.000 sec)
MariaDB [linguacafe]> DELETE from users WHERE id=1;
Query OK, 1 row affected (0.001 sec)
MariaDB [linguacafe]> SELECT * from users;
Empty set (0.000 sec)
MariaDB [linguacafe]> EXIT;
Bye
Note that if you already had to re-create the User, the ID will now be 2, etc.
When setting up the first User, the Password is getting truncated to 32 (or 31) Characters without Warning !
There is also currently no Instruction at all in how to reset a Password.
This is what I did, assuming you only have the Admin first User:
Note that if you already had to re-create the User, the ID will now be 2, etc.