{"id":21876,"date":"2026-11-10T14:33:34","date_gmt":"2026-11-10T11:33:34","guid":{"rendered":"https:\/\/sunucun.com.tr\/blog\/what-is-phpmyadmin\/"},"modified":"2026-11-10T14:33:34","modified_gmt":"2026-11-10T11:33:34","slug":"what-is-phpmyadmin","status":"publish","type":"post","link":"https:\/\/sunucun.com.tr\/blog\/what-is-phpmyadmin\/","title":{"rendered":"What Is phpMyAdmin? localhost\/phpmyadmin Login, Creating and Backing Up Databases"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/sunucun.com.tr\/blog\/what-is-phpmyadmin\/#What_You_Can_Do\" >What You Can Do<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sunucun.com.tr\/blog\/what-is-phpmyadmin\/#Opening_localhostphpmyadmin_XAMPP\" >Opening localhost\/phpmyadmin (XAMPP)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sunucun.com.tr\/blog\/what-is-phpmyadmin\/#phpMyAdmin_on_Hosting\" >phpMyAdmin on Hosting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/sunucun.com.tr\/blog\/what-is-phpmyadmin\/#Basic_Tasks\" >Basic Tasks<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/sunucun.com.tr\/blog\/what-is-phpmyadmin\/#Common_Errors\" >Common Errors<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/sunucun.com.tr\/blog\/what-is-phpmyadmin\/#Frequently_Asked_Questions\" >Frequently Asked Questions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/sunucun.com.tr\/blog\/what-is-phpmyadmin\/#Is_phpMyAdmin_free\" >Is phpMyAdmin free?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/sunucun.com.tr\/blog\/what-is-phpmyadmin\/#Is_phpMyAdmin_the_same_as_MySQL\" >Is phpMyAdmin the same as MySQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/sunucun.com.tr\/blog\/what-is-phpmyadmin\/#What_is_the_phpMyAdmin_password\" >What is the phpMyAdmin password?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n\n<p class=\"wp-block-paragraph\"><strong>phpMyAdmin<\/strong> is a <strong>free tool written in PHP for managing MySQL and MariaDB databases in the browser<\/strong>. Without the command line you can create databases and tables, browse and edit rows, run SQL queries, and export or import databases. Locally with XAMPP it opens at <code>http:\/\/localhost\/phpmyadmin<\/code>; on <a href=\"https:\/\/sunucun.com.tr\/hosting\/\" data-internallinksmanager029f6b8e52c=\"126\" title=\"Web bar\u0131nd\u0131rma paketlerini inceleyin\">hosting<\/a>, through cPanel or Plesk.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_You_Can_Do\"><\/span>What You Can Do<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create, edit and drop databases, tables, columns and indexes<\/li>\n<li>Browse, search, insert and edit rows<\/li>\n<li>Run SQL queries, including batch queries<\/li>\n<li>Export and import in formats such as SQL and CSV<\/li>\n<li>Manage database users and privileges (if permitted)<\/li>\n<li>Visualise relations between tables<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Opening_localhostphpmyadmin_XAMPP\"><\/span>Opening localhost\/phpmyadmin (XAMPP)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open the XAMPP Control Panel and <strong>Start<\/strong> both <strong>Apache<\/strong> and <strong>MySQL<\/strong>.<\/li>\n<li>Go to <code>http:\/\/localhost\/phpmyadmin<\/code> or <code>http:\/\/127.0.0.1\/phpmyadmin<\/code>.<\/li>\n<li>According to the XAMPP FAQ, the MySQL <strong>root<\/strong> user has <strong>no password<\/strong> by default; if prompted, enter <code>root<\/code> and leave the password empty.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">XAMPP&#8217;s own documentation says it is meant for development, not production. Set a root password before exposing your machine to a network. See <a href=\"https:\/\/sunucun.com.tr\/blog\/what-is-xampp\/\">what is XAMPP<\/a> and <a href=\"https:\/\/sunucun.com.tr\/blog\/what-is-localhost\/\">what is localhost<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"phpMyAdmin_on_Hosting\"><\/span>phpMyAdmin on Hosting<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>cPanel:<\/strong> click <strong>phpMyAdmin<\/strong> under Databases; you are logged in automatically. Create the database and user first in <strong>MySQL Databases<\/strong> (see <a href=\"https:\/\/sunucun.com.tr\/blog\/efficient-database-management-in-cpanel\/\">database management in cPanel<\/a>).<\/li>\n<li><strong>Plesk:<\/strong> Databases &gt; your database &gt; <strong>phpMyAdmin<\/strong>.<\/li>\n<li><strong>Your own <a href=\"https:\/\/sunucun.com.tr\/vps-sunucu\" data-internallinksmanager029f6b8e52c=\"132\" title=\"Sanal sunucu se\u00e7eneklerini inceleyin\">VPS<\/a>\/<a href=\"https:\/\/sunucun.com.tr\/vds-sunucu\" data-internallinksmanager029f6b8e52c=\"133\" title=\"Tahsisli kaynakl\u0131 sanal sunucu \u00e7\u00f6z\u00fcmleri\">VDS<\/a>:<\/strong> install it yourself and don&#8217;t leave it public; use IP restrictions, extra HTTP auth or an SSH tunnel, and consider changing the default \/phpmyadmin path.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Basic_Tasks\"><\/span>Basic Tasks<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"snc-table-wrap\"><table>\n<thead><tr><th>Task<\/th><th>How<\/th><\/tr><\/thead>\n<tbody>\n<tr><td><strong>Create a database<\/strong><\/td><td><strong>Databases<\/strong> tab &gt; name &gt; a utf8mb4 collation such as <code>utf8mb4_unicode_ci<\/code> &gt; Create. (On shared hosting this is usually done in the panel.)<\/td><\/tr>\n<tr><td><strong>Back up (export)<\/strong><\/td><td>Select the database &gt; <strong>Export<\/strong> &gt; Format: SQL &gt; Go.<\/td><\/tr>\n<tr><td><strong>Restore (import)<\/strong><\/td><td>Select an empty database &gt; <strong>Import<\/strong> &gt; choose the .sql (or .sql.zip\/.gz) file &gt; Go.<\/td><\/tr>\n<tr><td><strong>Run SQL<\/strong><\/td><td><strong>SQL<\/strong> tab &gt; type the query &gt; Go. Back up before DELETE\/UPDATE.<\/td><\/tr>\n<tr><td><strong>Repair \/ optimise<\/strong><\/td><td>Tick tables &gt; <strong>Repair table<\/strong> or <strong>Optimize table<\/strong> from the menu below.<\/td><\/tr>\n<\/tbody><\/table><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Common_Errors\"><\/span>Common Errors<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>localhost\/phpmyadmin won&#8217;t open:<\/strong> Apache isn&#8217;t running. Start it in XAMPP; if another program uses port 80, change Apache&#8217;s port and add it to the URL (e.g. <code>localhost:8080\/phpmyadmin<\/code>).<\/li>\n<li><strong>#2002 &#8211; Cannot connect to server:<\/strong> the MySQL\/MariaDB service is stopped; start MySQL in XAMPP.<\/li>\n<li><strong>#1045 &#8211; Access denied:<\/strong> wrong username or password; if you changed the root password, update config.inc.php too.<\/li>\n<li><strong>Import size limit:<\/strong> large .sql files hit PHP&#8217;s upload_max_filesize and post_max_size; compress the file, raise the limits or import from the command line (<code>mysql -u user -p database &lt; backup.sql<\/code>).<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">See also <a href=\"https:\/\/sunucun.com.tr\/blog\/what-is-mysql\/\">what is MySQL<\/a>. For phpMyAdmin ready to use, see our <a href=\"https:\/\/sunucun.com.tr\/en\/hosting\/cpanel-hosting\">cPanel hosting<\/a>; for a full database server, our <a href=\"https:\/\/sunucun.com.tr\/en\/vds-server\">VDS server<\/a> plans.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions\"><\/span>Frequently Asked Questions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Is_phpMyAdmin_free\"><\/span>Is phpMyAdmin free?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Yes. It is free, open-source software bundled with XAMPP, cPanel and Plesk.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Is_phpMyAdmin_the_same_as_MySQL\"><\/span>Is phpMyAdmin the same as MySQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">No. MySQL (or MariaDB) is the database server; phpMyAdmin is the web interface for managing it.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_the_phpMyAdmin_password\"><\/span>What is the phpMyAdmin password?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">phpMyAdmin has no password of its own; you log in with a MySQL user. In XAMPP the default is root with an empty password; on hosting, use the database user you created in cPanel or Plesk.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin is a free tool written in PHP for managing MySQL and MariaDB databases in the browser. Without the command line you can create databases and tables, browse and edit rows, run SQL queries, and export or import databases. Locally with XAMPP it opens at http:\/\/localhost\/phpmyadmin; on hosting, through cPanel or Plesk. What You Can&hellip;<\/p>\n","protected":false},"author":1,"featured_media":21878,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1470],"tags":[],"class_list":["post-21876","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/21876","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=21876"}],"version-history":[{"count":0,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/21876\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media\/21878"}],"wp:attachment":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=21876"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=21876"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=21876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}