How to access as root or admin user?

[hugoruscitti]

Hi, i are using a separate application with phpmyadmin to access to the database by
using the same string connection. But i don't have admin rights by using the "mysql" named
user.

There is any way to get the root user to the mysql database instance?

[josegonzalez]

I believe it is output via dokku mysq:info SERVICE.

[hugoruscitti]

nop, sadly it only show normal credentials, no root access to database settings :(

How i can get admin access to the database?

[josegonzalez]

The root password is stored in a file called ROOTPASSWORD in the service-root dir.

[hugoruscitti]

Thank you very much, your suggestion has worked perfectly !!

[barmmie]

@hugoruscitti
I'm having the same issue
I'm sorry if the answer to this is obvious but how do i access the service-root directory?

Regard

Edit: Asked too soon.
Incase anyone else is looking it is in the /var/lib/dokku/services/mysql/APP/ folder

[cba85]

@hugoruscitti I'm having the same issue I'm sorry if the answer to this is obvious but how do i access the service-root directory?

Regard

Edit: Asked too soon. Incase anyone else is looking it is in the /var/lib/dokku/services/mysql/APP/ folder

To find service-root directory:

$ dokku mysql:info YOUR_APP_NAME