How to Enable All Features for PHPMyAdmin in DirectAdmin?

It’s a good idea as a DirectAdmin admin to restrict which PHPMyAdmin functionalities are available to specific users. These users are unable to use PHPMyAdmin’s Designer tab or other capabilities. A notification stating the following will show up on the interface when they attempt to use these features:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated.

But, there is a way to enable all these features of PHPMyAdmin via DirectAdmin SSH and make them available to these users.

To Enable All Features for PHPMyAdmin

1. Log into your DirectAdmin server via SSH as the root user.

2. Run these commands:

cd /root
wget -O create_tables.sh http://files1.directadmin.com/services/all/phpMyAdmin/create_tables.sh
chmod 755 create_tables.sh
./create_tables.sh

These commands are to download the create_tables.sh script. It will also create the da_phpmyadmin user and password and configure the config.inc.php file.