{"id":45337,"date":"2024-03-30T07:30:48","date_gmt":"2024-03-30T07:30:48","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=45337"},"modified":"2024-03-30T07:30:48","modified_gmt":"2024-03-30T07:30:48","slug":"what-are-the-authentication-type-in-phpmyadmin-which-for-config-inc-php","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/what-are-the-authentication-type-in-phpmyadmin-which-for-config-inc-php\/","title":{"rendered":"What are the Authentication type in phpmyadmin which for config.inc.php"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"992\" height=\"462\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-781.png\" alt=\"\" class=\"wp-image-45342\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-781.png 992w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-781-300x140.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-781-768x358.png 768w\" sizes=\"auto, (max-width: 992px) 100vw, 992px\" \/><\/figure>\n\n\n\n<p>In phpMyAdmin, the authentication type determines how users are authenticated when they try to access the phpMyAdmin interface. This setting is configured in the <code>config.inc.php<\/code> file of your phpMyAdmin installation, using the <code>$cfg['Servers'][$i]['auth_type']<\/code> directive. There are several authentication types available in phpMyAdmin:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><code>config<\/code><\/strong><\/h2>\n\n\n\n<p><strong><code>config<\/code><\/strong>: This is the simplest method where the username and password are stored in the <code>config.inc.php<\/code> file. This method is not recommended for servers accessible from the Internet due to security concerns, as it does not prompt the user for a username or password.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"957\" height=\"142\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-777.png\" alt=\"\" class=\"wp-image-45338\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-777.png 957w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-777-300x45.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-777-768x114.png 768w\" sizes=\"auto, (max-width: 957px) 100vw, 957px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><code>cookie<\/code><\/strong><\/h2>\n\n\n\n<p><strong><code>cookie<\/code><\/strong>: This method uses cookies for authentication. The user will be presented with a login screen to enter their username and password. This method is more secure than <code>config<\/code> and is commonly used for Internet-facing servers.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"972\" height=\"137\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-778.png\" alt=\"\" class=\"wp-image-45339\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-778.png 972w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-778-300x42.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-778-768x108.png 768w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><code>http<\/code><\/strong><\/h2>\n\n\n\n<p><strong><code>http<\/code><\/strong>: With this method, HTTP Authentication is used. The web server manages the login process, and the login dialogue is presented by the browser itself. This method also allows for the use of web server&#8217;s authentication modules.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"967\" height=\"145\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-779.png\" alt=\"\" class=\"wp-image-45340\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-779.png 967w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-779-300x45.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-779-768x115.png 768w\" sizes=\"auto, (max-width: 967px) 100vw, 967px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong><code>signon<\/code><\/strong><\/h2>\n\n\n\n<p><strong><code>signon<\/code><\/strong>: This advanced authentication method allows for single sign-on capabilities. It uses a session-based mechanism and requires additional scripting to integrate phpMyAdmin logins with other application logins.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"140\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-780.png\" alt=\"\" class=\"wp-image-45341\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-780.png 961w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-780-300x44.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2024\/03\/image-780-768x112.png 768w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/figure>\n\n\n\n<p>Choosing the right authentication type depends on your specific needs, including the level of security required and whether the phpMyAdmin installation is exposed to the Internet. For most users, <code>cookie<\/code> authentication provides a good balance between convenience and security.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Reference<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/howtolamp.com\/lamp\/phpmyadmin\/4.2\/authentication-modes\/\" target=\"_blank\" rel=\"noopener\">https:\/\/howtolamp.com\/lamp\/phpmyadmin\/4.2\/authentication-modes\/<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In phpMyAdmin, the authentication type determines how users are authenticated when they try to access the phpMyAdmin interface. This setting is configured in the config.inc.php file of your phpMyAdmin installation, using the $cfg[&#8216;Servers&#8217;][$i][&#8216;auth_type&#8217;] directive. There are several authentication types available in phpMyAdmin: config config: This is the simplest method where the username and password are&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[2],"tags":[],"class_list":["post-45337","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/45337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=45337"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/45337\/revisions"}],"predecessor-version":[{"id":45343,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/45337\/revisions\/45343"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=45337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=45337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=45337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}