[module] PhpMyAdmin auto login

This helps you to login directly to phpMyAdmin with one click
Note: You might also be interested on: http://forum.centos-webpanel.com/new-modules/%28module%29-favorites-top-bar/msg2604/#msg2604

Please give a support message if you use this module


Add this line to:
/usr/local/cwpsrv/htdocs/resources/admin/include/3rdparty.php

<li><a href="index.php?module=phpMyAdmin_autologin" target="_blank"><span class="icon16 icomoon-icon-arrow-right-3"></span>PhpMyAdmin auto login</a></li>

Then create a new file called "phpMyAdmin_autologin.php" on:
/usr/local/cwpsrv/htdocs/resources/admin/modules
with this content:

<h3>Redirecting to phpMyAdmin...</h3>
This might take a few seconds.<br>
Click <a href="#" onclick="location.reload();">here</a> to try again.

<form method="post" id="phpMyAdmin_Form" action="http://<?php echo $_SERVER["SERVER_NAME"];?>/phpMyAdmin/" name="login_form" style="display:none">
<input type="text" name="pma_username" id="input_username" value="root" size="24" class="textfield"/>
<input type="password" name="pma_password" id="input_password" value="<?php echo $db_pass ?>" size="24" class="textfield" />
<input type="hidden" name="server" value="1" />

<input value="Exec" type="submit" id="input_go" />
<input type="hidden" name="target" value="index.php" />
</form>

<script>
$('#phpMyAdmin_Form').submit();
</script>

If you want to avoid that "unsecured access" message that pops up on your browser, just activate SSL on your phpmyadmin and also change the "action" in the form and you are ready to go

This does not seem to work with pma 4.8.3 it just displays the login page and does nothing.

@ekgrad
Replace:

Code: [Select]

action="http://<?php echo $_SERVER["SERVER_NAME"];?>/phpMyAdmin/"with:

Code: [Select]

action="/pma/"

Its a great feature and This should be added to CWP by default.

The default login form has a hidden field

<input type="hidden" name="token" value="&amp;|)3qM3+5GUlsEqN">

where the value of token keeps on changing with every refresh of the page. Without this the auto login does not seem to work.

This works fine for me, I only had to replace that form action url to fix broken link cos cwp got new url format.
That hidden field is useless, you'll get that token anyway later once you login. Adblockers can be reason why it don't work...adblockers are known to corrupt js libraries like jquery. Try in the new browser.

I have tried it without adblock but still all i get is the phpMyAdmin login page.

Ok, 4.8.4. doesn't work for me anymore. Seems there are some session thing changes in pma. If I find the solution it'll be posted here.

What about pma 4.8.3?

Please does anyone know how to make this work for CWP in 2022?

Please does anyone know how to make this work for CWP in 2022?

Have you even tried the phpmyadmin button in the menu of admincp and usercp instead of reviving a 7 years old thread?
It's already there!

In my opinion, this should actually be reversed. I don't like auto-logins to security-sensitive areas.

In my opinion, this should actually be reversed. I don't like auto-logins to security-sensitive areas.

If you don't want phpMyAdmin auto-login, you can simply set the MySQL root password to something different than your system root password. And make sure to update /root/.my.cnf -- then PMA will go to its login screen instead of auto-logging in with your system root credentials (that you also use for CWP).