{"id":3780,"date":"2026-07-22T15:55:22","date_gmt":"2026-07-22T15:55:22","guid":{"rendered":"https:\/\/disoh.com\/support\/how-do-i-access-and-use-phpmyadmin-in-directadmin\/"},"modified":"2026-07-22T15:55:22","modified_gmt":"2026-07-22T15:55:22","password":"","slug":"how-do-i-access-and-use-phpmyadmin-in-directadmin","status":"publish","type":"docs","link":"https:\/\/disoh.com\/fi\/support\/how-do-i-access-and-use-phpmyadmin-in-directadmin\/","title":{"rendered":"How do I access and use phpMyAdmin in DirectAdmin?"},"content":{"rendered":"

phpMyAdmin is a visual tool for managing your MySQL databases. You can browse tables, run queries, and import or export data without using the command line. Here is how to reach and use it in DirectAdmin.<\/p>\n

Opening phpMyAdmin<\/h2>\n
    \n
  1. Log in to DirectAdmin (usually yourdomain.com:2222<\/em>).<\/li>\n
  2. Go to Account Manager<\/strong> and click MySQL Management<\/strong>.<\/li>\n
  3. Find your database and click the phpMyAdmin<\/strong> link next to it.<\/li>\n
  4. Log in with the database username and password.<\/li>\n<\/ol>\n

    Finding your way around<\/h2>\n
      \n
    • Left panel:<\/strong> lists your databases and their tables.<\/li>\n
    • Structure tab:<\/strong> shows the tables and columns.<\/li>\n
    • Browse tab:<\/strong> lets you view and edit rows.<\/li>\n
    • SQL tab:<\/strong> lets you run queries directly.<\/li>\n<\/ul>\n

      Exporting a database (backup)<\/h2>\n
        \n
      1. Select the database in the left panel.<\/li>\n
      2. Click the Export<\/strong> tab.<\/li>\n
      3. Choose the Quick<\/strong> method and SQL<\/strong> format.<\/li>\n
      4. Click Go<\/strong> to download the .sql file.<\/li>\n<\/ol>\n

        Importing a database<\/h2>\n
          \n
        1. Select the target database.<\/li>\n
        2. Click the Import<\/strong> tab.<\/li>\n
        3. Choose your .sql file and click Go<\/strong>.<\/li>\n<\/ol>\n

          If the file is large, you may need to compress it (.zip or .gz) first.<\/p>\n

          Safety tips<\/h2>\n
            \n
          • Always export a copy before making changes.<\/li>\n
          • Double-check which database you are editing.<\/li>\n
          • Avoid dropping tables unless you are certain.<\/li>\n<\/ul>\n

            Troubleshooting<\/h2>\n
              \n
            • Login fails:<\/strong> confirm the database user and password in MySQL Management.<\/li>\n
            • Import too large:<\/strong> compress the file or split it into smaller parts.<\/li>\n
            • Site errors after edits:<\/strong> restore your exported copy.<\/li>\n<\/ul>\n

              Need help?<\/h2>\n

              If you are unsure about a database change, reach out to our support team on live chat before proceeding.<\/p>","protected":false},"excerpt":{"rendered":"

              phpMyAdmin is a visual tool for managing your MySQL databases. You can browse tables, run queries, and import or export data without using the command line. Here is how to reach and use it in DirectAdmin. Opening phpMyAdmin Log in to DirectAdmin (usually yourdomain.com:2222). Go to Account Manager and click MySQL Management. Find your database […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[12],"doc_tag":[],"class_list":["post-3780","docs","type-docs","status-publish","hentry","doc_category-webhosting"],"year_month":"2026-07","word_count":243,"total_views":"23","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Jorn","author_nicename":"jorn","author_url":"https:\/\/disoh.com\/fi\/author\/jorn\/"},"doc_category_info":[{"term_name":"Webhosting","term_url":"https:\/\/disoh.com\/fi\/docs-category\/webhosting\/"}],"doc_tag_info":[],"yoast_head":"\nHow do I access and use phpMyAdmin in DirectAdmin? – Disoh<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/disoh.com\/fi\/support\/how-do-i-access-and-use-phpmyadmin-in-directadmin\/\" \/>\n<meta property=\"og:locale\" content=\"fi_FI\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do I access and use phpMyAdmin in DirectAdmin? – Disoh\" \/>\n<meta property=\"og:description\" content=\"phpMyAdmin is a visual tool for managing your MySQL databases. You can browse tables, run queries, and import or export data without using the command line. Here is how to reach and use it in DirectAdmin. Opening phpMyAdmin Log in to DirectAdmin (usually yourdomain.com:2222). Go to Account Manager and click MySQL Management. Find your database […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/disoh.com\/fi\/support\/how-do-i-access-and-use-phpmyadmin-in-directadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Disoh\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/disohhosting\" \/>\n<meta property=\"og:image\" content=\"https:\/\/disoh.com\/wp-content\/uploads\/2025\/07\/disoh_about.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1536\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Arvioitu lukuaika\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuutti\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/disoh.com\\\/support\\\/how-do-i-access-and-use-phpmyadmin-in-directadmin\\\/\",\"url\":\"https:\\\/\\\/disoh.com\\\/support\\\/how-do-i-access-and-use-phpmyadmin-in-directadmin\\\/\",\"name\":\"How do I access and use phpMyAdmin in DirectAdmin? – Disoh\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/disoh.com\\\/#website\"},\"datePublished\":\"2026-07-22T15:55:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/disoh.com\\\/support\\\/how-do-i-access-and-use-phpmyadmin-in-directadmin\\\/#breadcrumb\"},\"inLanguage\":\"fi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/disoh.com\\\/support\\\/how-do-i-access-and-use-phpmyadmin-in-directadmin\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/disoh.com\\\/support\\\/how-do-i-access-and-use-phpmyadmin-in-directadmin\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/disoh.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How do I access and use phpMyAdmin in DirectAdmin?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/disoh.com\\\/#website\",\"url\":\"https:\\\/\\\/disoh.com\\\/\",\"name\":\"Disoh\",\"description\":\"Digital Solutions Hosting\",\"publisher\":{\"@id\":\"https:\\\/\\\/disoh.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/disoh.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fi\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/disoh.com\\\/#organization\",\"name\":\"Disoh LLC\",\"url\":\"https:\\\/\\\/disoh.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fi\",\"@id\":\"https:\\\/\\\/disoh.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/disoh.com\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/favicon_1.svg\",\"contentUrl\":\"https:\\\/\\\/disoh.com\\\/wp-content\\\/uploads\\\/2025\\\/06\\\/favicon_1.svg\",\"width\":615,\"height\":615,\"caption\":\"Disoh LLC\"},\"image\":{\"@id\":\"https:\\\/\\\/disoh.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/disohhosting\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How do I access and use phpMyAdmin in DirectAdmin? – Disoh","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/disoh.com\/fi\/support\/how-do-i-access-and-use-phpmyadmin-in-directadmin\/","og_locale":"fi_FI","og_type":"article","og_title":"How do I access and use phpMyAdmin in DirectAdmin? – Disoh","og_description":"phpMyAdmin is a visual tool for managing your MySQL databases. You can browse tables, run queries, and import or export data without using the command line. Here is how to reach and use it in DirectAdmin. Opening phpMyAdmin Log in to DirectAdmin (usually yourdomain.com:2222). Go to Account Manager and click MySQL Management. Find your database […]","og_url":"https:\/\/disoh.com\/fi\/support\/how-do-i-access-and-use-phpmyadmin-in-directadmin\/","og_site_name":"Disoh","article_publisher":"https:\/\/www.facebook.com\/disohhosting","og_image":[{"width":1536,"height":1024,"url":"https:\/\/disoh.com\/wp-content\/uploads\/2025\/07\/disoh_about.webp","type":"image\/webp"}],"twitter_card":"summary_large_image","twitter_misc":{"Arvioitu lukuaika":"1 minuutti"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/disoh.com\/support\/how-do-i-access-and-use-phpmyadmin-in-directadmin\/","url":"https:\/\/disoh.com\/support\/how-do-i-access-and-use-phpmyadmin-in-directadmin\/","name":"How do I access and use phpMyAdmin in DirectAdmin? – Disoh","isPartOf":{"@id":"https:\/\/disoh.com\/#website"},"datePublished":"2026-07-22T15:55:22+00:00","breadcrumb":{"@id":"https:\/\/disoh.com\/support\/how-do-i-access-and-use-phpmyadmin-in-directadmin\/#breadcrumb"},"inLanguage":"fi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/disoh.com\/support\/how-do-i-access-and-use-phpmyadmin-in-directadmin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/disoh.com\/support\/how-do-i-access-and-use-phpmyadmin-in-directadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/disoh.com\/"},{"@type":"ListItem","position":2,"name":"How do I access and use phpMyAdmin in DirectAdmin?"}]},{"@type":"WebSite","@id":"https:\/\/disoh.com\/#website","url":"https:\/\/disoh.com\/","name":"Disoh","description":"Digitaalisten ratkaisujen is\u00e4nn\u00f6inti","publisher":{"@id":"https:\/\/disoh.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/disoh.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fi"},{"@type":"Organization","@id":"https:\/\/disoh.com\/#organization","name":"Disoh LLC","url":"https:\/\/disoh.com\/","logo":{"@type":"ImageObject","inLanguage":"fi","@id":"https:\/\/disoh.com\/#\/schema\/logo\/image\/","url":"https:\/\/disoh.com\/wp-content\/uploads\/2025\/06\/favicon_1.svg","contentUrl":"https:\/\/disoh.com\/wp-content\/uploads\/2025\/06\/favicon_1.svg","width":615,"height":615,"caption":"Disoh LLC"},"image":{"@id":"https:\/\/disoh.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/disohhosting"]}]}},"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/disoh.com\/fi\/wp-json\/wp\/v2\/docs\/3780","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/disoh.com\/fi\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/disoh.com\/fi\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/disoh.com\/fi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/disoh.com\/fi\/wp-json\/wp\/v2\/comments?post=3780"}],"version-history":[{"count":0,"href":"https:\/\/disoh.com\/fi\/wp-json\/wp\/v2\/docs\/3780\/revisions"}],"wp:attachment":[{"href":"https:\/\/disoh.com\/fi\/wp-json\/wp\/v2\/media?parent=3780"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/disoh.com\/fi\/wp-json\/wp\/v2\/doc_category?post=3780"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/disoh.com\/fi\/wp-json\/wp\/v2\/doc_tag?post=3780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}