Skip to content

Password truncated to 32 Characters ! #484

@luckylinux

Description

@luckylinux

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions