Did you try the first button “Enter PhpMyAdmin” ? what that leads to?
the next option you are using (manual login) is only the alternative option, which you might not need to use. But if you want to use that, then you will find the database name, user and password in wp-config.php, so, you only have to enter database user and password in PMA login page.
Hi there,
When I first installed the URL it imagined would be, it was wrong so I entered the correct URL in the box.
I did use “Enter PhpMyAdmin” when I face the login screen that it states I have the wrong login information. There are small red boxes above and below the login entry boxes. The top one states this: ‘Cannot log in to the MySQL server’, the red box below ‘mysqli_real_connect(): (HY000/2002): Connection refused’
Your plugin assumes the username entry is the name of the database inside, its not its ‘root’ and the password to go with that is not the same password for the database inside called projectionpictures. Is it possible to enter lines in the wp-connfig.php so it knows what the phpmyadmin username and password are?
KR,
Ian.
So, as I understand, you want to manage the database, which is not the same database of the wordpress site you are running? because, if that was the case, the plugin uses same database-name, as defined in wp-config (DB_NAME). and respectively, same user/passwords as there.
have you changed anything (host, db-name or whatever) after installing phpMyAdmin plugin?
if so, then you have just to uninstall (delete) and reinstall phpMyAdmin plugin.
if you want to connect external databases, then we are planning to release an update addons for PMA that will do other extra things not available in the plugin currently.
Hi there,
I initially designed the site in the default wordpress folder, then I transfered it into projectionpictures folder to create a live site.
The default username and password to enter phpmyadmin has always been ‘root’ and a cryptic password. However those are not in wp-config.php in the wordpress file or in the projectionpictures either.
The URL for myphpadmin has always been https://192.168.1.###/phpMyAdmin/index.php
Is it necessary for https://192.168.1.###/phpMyAdmin/index.php to change to this https://projectionpictures.com/phpmyadmin/ (this is what your plugging is suggesting).
KR,
Ian.
No, the url plugin suggest, is just example. your give IP address belongs to Local-server (hosted in your network), and could be correct for locally hosted site, but that url is incorrect for production site.
I cant understand, how the site connects to database, if incorrect user/password is used, then WP site wont work. but whatever user/pass is there, it should be used for phpMyAdmin.
If you want to change that, I can tell you to try to login phpMyAdmin page url with:
/index.php?pma_username=XXXX&pma_password=XXXX
just change the X with credentials.
yes, that last link seems a correct url. shorter url is not available for that.
Was that link successful?
Hi there,
Unfortunately both have failed to login;
https://192.168.1.234/phpMyAdmin/index.php?pma_username=XXXX&pma_password=XXXX
or
https://www.projectionpictures.com/wp-content/plugins/wp-phpmyadmin-extension/lib/phpMyAdmin_qugnZUa4oGiXyFdhVj6LBJD//index.php?pma_username=XXXX&pma_password=XXXX
Both insert projectionpictures as the default username, but fails to go any further.
Will this solves it: if you want to connect external databases, then we are planning to release an update addons for PMA that will do other extra things not available in the plugin currently.
That you mentions before.
Lastly which one of these options in the menu helps or hinders my login attempts:
1.Restrict access only to current IP (217.146.82.119) to login into PMA
2. Hide errors in PMA
3. Strip slashes in PMA
As there all un-ticked at the moment.
KR,
Ian.
None of the options(checkboxes) will solve that problem. the problem is with connection credentials. You can try to contact personally at [email protected] and I’ll might go further there. In this topic, I can’t help more, because all I could i’ve suggested.
Hi,
Thank you for your kindness in the support you have given me. If I was to email the address you have suggested, how would you phrase the question to solve the problem based on your understanding of the login URL issue and the solutions you’ve suggested already.
KR,
Ian.
Basically, I will serve to your problem behind that email, just that method gives me more abilities to get in deeper details of your problem, instead of public-posting the details here.
Hi there,
Please see my update responses in puvox support center.
KR,
Ian.
