It depends on whether you are using a Managed WordPress hosting account or have Wordpress installed via a cPanel interface for your site.
If you are using Manage Wordpress login to your account. go to "manage hosting", click on managed wordpress, click on the Settings Button for the site you're working with. On the tabs across the top, click on databases and you'll have a link and login information.
If you are using cPanel, login, open your cPanel, scroll roughly 2/3 way down the page and click on the myPhPadmin in the Database section of the page. This will list your databases along with a access information.
Hope this helps,
to access phpmyadmin you need to edit the config file. for fedora installed via DNF config file is located
/etc/httpd/conf.d/phpMyAdmin.conf and locate the section <IfModule mod_authz_core.c> and add your Public IP. It is not a good idea to allow all so a static IP is recommended but you can change your IP when you need access.
# Apache 2.4
Require ip 127.0.0.1
Require ip ::1
Require ip <Insert your current Public IP>
# Apache 2.2
Deny from All
Allow from 127.0.0.1
Allow from ::1
Allow from <Insert your current Public IP>
After the changes you will need to restart apache for Fedora systemctl restart httpd
I am not familare with Debian based distros so location of config file and needed commands will be different.