{"id":387,"date":"2024-08-04T14:49:11","date_gmt":"2024-08-04T14:49:11","guid":{"rendered":"https:\/\/www.erodewebhosting.com\/knowledgebase\/?p=387"},"modified":"2024-08-04T14:50:47","modified_gmt":"2024-08-04T14:50:47","slug":"how-to-enable-auto-login-for-phpmyadmin-in-directadmin-2","status":"publish","type":"post","link":"https:\/\/www.erodewebhosting.com\/knowledgebase\/how-to-enable-auto-login-for-phpmyadmin-in-directadmin-2\/","title":{"rendered":"How to Enable Auto-Login for PHPMyAdmin in DirectAdmin ?"},"content":{"rendered":"\n<p>Enable auto-login for phpMyAdmin in DirectAdmin can significantly streamline database management by allowing users to bypass the login screen. This is particularly useful for administrators who frequently access phpMyAdmin and prefer a more seamless experience. In this guide, we will walk through the process of enabling auto-login for phpMyAdmin using a simple command in DirectAdmin. By configuring this setting, you can automate the login process, saving time and effort. However, it\u2019s important to balance convenience with security to ensure\u00a0<a href=\"https:\/\/pondywebhosting.com\/vps-web-hosting\/\" target=\"_blank\" rel=\"noopener\">your server remains protected.<\/a>\u00a0Let\u2019s get started on how to set up auto-login for phpMyAdmin via DirectAdmin using the\u00a0<code>one_click_pma_login<\/code>\u00a0command.<\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#step-1-access-your-server-via-ssh\">Step 1: Access Your Server via SSH<\/a><\/li><li><a href=\"#step-2-execute-the-command\">Step 2: Execute the Command<\/a><\/li><li><a href=\"#step-3-verify-the-setting\">Step 3: Verify the Setting<\/a><\/li><li><a href=\"#step-4-test-the-auto-login-for-php-my-admin-in-direct-admin\">Step 4: Test the Auto-Login for PHPMyAdmin in DirectAdmin<\/a><\/li><li><a href=\"#additional-notes\">Additional Notes<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-1-access-your-server-via-ssh\">Step 1: Access Your Server via SSH<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use an SSH client to connect to your <a href=\"https:\/\/www.erodewebhosting.com\/vps-web-hosting\/\">server<\/a>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pondywebhosting.com\/blog\/wp-content\/uploads\/2024\/07\/image.png\" alt=\"Enable Auto-Login for PHPMyAdmin in DirectAdmin\" class=\"wp-image-405\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-2-execute-the-command\">Step 2: Execute the Command<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Once logged in to your server, navigate to the DirectAdmin installation directory. This is usually\u00a0<code>\/usr\/local\/directadmin<\/code>.<\/li>\n\n\n\n<li>Run the following command:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>cd \/usr\/local\/directadmin\n.\/directadmin set one_click_pma_login 1 restart<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>then Run the following command to build phpmyadmin :<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-preformatted\">cd custombuild\n.\/build update\n.\/build phpmyadmin<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-3-verify-the-setting\">Step 3: Verify the Setting<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>After running the command, verify that the setting has been applied correctly.<\/li>\n\n\n\n<li>You can check the DirectAdmin configuration to ensure the\u00a0<code>one_click_pma_login<\/code>\u00a0is enabled.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-4-test-the-auto-login-for-php-my-admin-in-direct-admin\">Step 4: Test the Auto-Login for PHPMyAdmin in DirectAdmin<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Log in to your DirectAdmin panel.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"http:\/\/pondywebhosting.com\/blog\/wp-content\/uploads\/2024\/03\/Login-1024x425.png\" alt=\"Enable Auto-Login for PHPMyAdmin in DirectAdmin\" class=\"wp-image-274\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on\u00a0<strong>MySQL Management<\/strong>\u00a0in the\u00a0<strong>Account Manager<\/strong>\u00a0section<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pondywebhosting.com\/blog\/wp-content\/uploads\/2024\/07\/da_mysql_management-1024x262.png\" alt=\"\" class=\"wp-image-406\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Navigate to phpMyAdmin via the DirectAdmin interface.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pondywebhosting.com\/blog\/wp-content\/uploads\/2024\/07\/da_login_to_phpmyadmin-1024x213.png\" alt=\"\" class=\"wp-image-407\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You should be Auto-Login for PHPMyAdmin in DirectAdmin without the need to enter your credentials.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"additional-notes\">Additional Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Security<\/strong>: Ensure your server and DirectAdmin installations are secure. Enabling auto-login can pose a security risk if not properly managed.<\/li>\n\n\n\n<li><strong>Updates<\/strong>: Keep your DirectAdmin and phpMyAdmin up-to-date to mitigate any potential security vulnerabilities.<\/li>\n<\/ul>\n\n\n\n<p>By running the&nbsp;<code>.\/directadmin set one_click_pma_login 1 restart<\/code>&nbsp;command, you configure DirectAdmin to enable one-click login for phpMyAdmin, simplifying the login process.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Enable auto-login for phpMyAdmin in DirectAdmin can significantly streamline database management by allowing users to bypass the login screen. This is particularly useful for administrators who frequently access phpMyAdmin and&hellip;<\/p>\n","protected":false},"author":1,"featured_media":388,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58],"tags":[],"class_list":["post-387","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/www.erodewebhosting.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/387","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.erodewebhosting.com\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.erodewebhosting.com\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.erodewebhosting.com\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.erodewebhosting.com\/knowledgebase\/wp-json\/wp\/v2\/comments?post=387"}],"version-history":[{"count":1,"href":"https:\/\/www.erodewebhosting.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/387\/revisions"}],"predecessor-version":[{"id":389,"href":"https:\/\/www.erodewebhosting.com\/knowledgebase\/wp-json\/wp\/v2\/posts\/387\/revisions\/389"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.erodewebhosting.com\/knowledgebase\/wp-json\/wp\/v2\/media\/388"}],"wp:attachment":[{"href":"https:\/\/www.erodewebhosting.com\/knowledgebase\/wp-json\/wp\/v2\/media?parent=387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.erodewebhosting.com\/knowledgebase\/wp-json\/wp\/v2\/categories?post=387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.erodewebhosting.com\/knowledgebase\/wp-json\/wp\/v2\/tags?post=387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}