{"id":16941,"date":"2024-05-21T17:39:25","date_gmt":"2024-05-21T17:39:25","guid":{"rendered":"https:\/\/hostvento.com\/kb\/web-hosting\/how-to-enable-all-features-for-phpmyadmin-in-directadmin\/"},"modified":"2024-06-16T18:04:45","modified_gmt":"2024-06-16T18:04:45","slug":"how-to-enable-all-features-for-phpmyadmin-in-directadmin","status":"publish","type":"docs","link":"https:\/\/www.hostvento.com\/kb\/docs\/hosting-faqs\/how-to-enable-all-features-for-phpmyadmin-in-directadmin\/","title":{"rendered":"How to Enable All Features for PHPMyAdmin in DirectAdmin?"},"content":{"rendered":"\n<p>It&#8217;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&#8217;s Designer tab or other capabilities. A notification stating the following will show up on the interface when they attempt to use these features:<\/p>\n\n\n\n<p>The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated.<\/p>\n\n\n\n<p>But, there is a way to enable all these features of PHPMyAdmin via DirectAdmin SSH and make them available to these users.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">To Enable All Features for PHPMyAdmin<\/h2>\n\n\n\n<p>1. Log into your DirectAdmin server via SSH as the root user.<\/p>\n\n\n\n<p>2. Run these commands:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">cd \/root\nwget -O create_tables.sh http:\/\/files1.directadmin.com\/services\/all\/phpMyAdmin\/create_tables.sh\nchmod 755 create_tables.sh\n.\/create_tables.sh\n<\/pre>\n\n\n\n<p>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.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It&#8217;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&#8217;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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":23377,"menu_order":535,"comment_status":"closed","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-16941","docs","type-docs","status-publish","hentry","no-post-thumbnail"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/16941","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/comments?post=16941"}],"version-history":[{"count":1,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/16941\/revisions"}],"predecessor-version":[{"id":16942,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/16941\/revisions\/16942"}],"up":[{"embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/docs\/23377"}],"wp:attachment":[{"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/media?parent=16941"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.hostvento.com\/kb\/wp-json\/wp\/v2\/doc_tag?post=16941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}