DirectAdmin PHPMyAdmin auto-login allows the users to effortlessly log in to the PHPMyAdmin.

Bobcares answers all questions no matter the size, as part of our DirectAdmin support

Let us take a look at automatic PHPMyAdmin log in in detail.

Automatic PHPMyAdmin login

Before DirectAdmin, access to PHPMyAdmin required logging in. The database users’ credentials present in the site’s configuration file would need for this login. So, to handle the newly formed database, users might log into the PHPMyAdmin using the user credentials they created while configuring or creating the database, database user, and database password in the panel.

cPanel and database accessibility

With cPanel, the cPanel user has access to all tables created under the cPanel user. An end-user could access all databases for all of the cPanel user’s websites. They can access it with just one click from within the cPanel interface after already being authorized as a cPanel user.

When clients switch to DirectAdmin, they try to access the PHPMyAdmin after logging in. And they have to type in the credentials. They would presume that the DirectAdmin user credentials would be valid and type in the same. But instead, they would have to enter the database users’ credentials using DirectAdmin. They would only be able to access the databases that the database user would have access to if they did enter the database user log in and password to log in.

Directadmin PHPMYadmin auto-login

The developers of DirectAdmin added a PHPMyAdmin singlesignOn feature that would enable an authenticated user to log into PHPMyAdmin from the DirectAdmin interface. This make’s using PHPMyAdmin easier. It is important to note that after October 2019, this feature is, by default, turned off.

[root@host ~]# /usr/local/directadmin/directadmin c | grep one_click_pma_loginCopy Code

How To Enable Auto-Login for PHPMyAdmin Via DirectAdmin?

Firstly, use the following command to enable the one-click-pma-login in /usr/local/directadmin:

cd /usr/local/directadmin ./directadmin set one_click_pma_login 1 restartCopy Code

[root@host ~]# cd /usr/local/directadmin
[root@host directadmin] # ./directadmin set one_click_pma_login i restart one_click_pma_login=1Copy Code

Secondly, use the following commands to update and rebuild the packages:

cd custombuild
./build update
./build phpmyadminCopy Code

[root@host directadmin]# cd custombuild [root@host custombuild)# ./build update 38 ##0000#*#******** ***000 0 00000003813 8 23 3 009903888888SERBESSE8888 100.0% Extracting custombuild.tar.gz. [root@host custombuild]# ./build phpmyadmin 18.01.201 8 13001000000000000000000000000003 SERBEERBEEBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBEEEEEEEEEE 100.0% Adding AuthLog to /var/www/html/phpMyAdmin-5.1.1-all-languages/config.inc.php Adding PmaNoRelation_Disablewarning to /var/www/html/phpMyAdmin-5.1.1-all-languages/config.inc.php phpMyAdmin 5.1.1-all-languages installation is done. [root@host custombuild)#Copy Code

Subsequently, it will enable the users using DirectAdmin to automatically log into PHPMyAdmin.

Accessing PHPMyAdmin to Login

Firstly sign in to the  DirectAdmin user account. Then in the Account Manager section click on MySQL management. After that, a list of current databases will open up. After that, for any database, click on the ‘+’ sign. This process will open up a menu with additional Login to PHPMyAdmin. And when the user selects the option, the database will display in the PHPMyAdmin interface.

[Need assistance with similar queries? We are here to help]

Conclusion

To conclude, it is easy to manage the PHP log-in credentials with the DirectAdmin PHPMyAdmin auto-login. Users with accessibility can easily log in without submitting credentials every time they try to log in.