dokku/dokku-mysql

How to reset an expired password

hugoruscitti opened this issue · 1 comments

Hi, today i restart the digitalocean machine and then i see some apps having problems with de mysql container. I think this is releated to an expired password, i can't export the database content neither:

root@enjambreDokku:~# dokku mysql:export blog-db
mysqldump: [Warning] Using a password on the command line interface can be insecure.
                                                                                    mysqldump: Got error: 1862: Your password has expired. To log in you must change it using a client that supports expired passwords. when trying to connect
                                                                                       root@enjambreDokku:~#

Any advice?

Oh, i find a way to solve it. I create a file called /var/lib/dokku/services/mysql/blog-db/config/my.cnf with this content:

[mysqld]
default_password_lifetime=0

and then, i restart the database container:

dokku mysql:restart blog-db

Sorry to post a issue too quickly :/