{"id":5424,"date":"2021-12-21T07:08:52","date_gmt":"2021-12-21T13:08:52","guid":{"rendered":"https:\/\/www.knownhost.com\/kb\/?p=5424"},"modified":"2026-01-23T06:31:06","modified_gmt":"2026-01-23T12:31:06","slug":"repair-create-database-table-using-phpmyadmin-check-version-of-mysql","status":"publish","type":"post","link":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/","title":{"rendered":"How to Repair, Create Database Table using phpMyAdmin &amp; Check version of MySQL?"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #212121;color:#212121\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #212121;color:#212121\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#check_mysql_version\" >Check MySQL Version<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#via_ssh_shell\" >via SSH Shell<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#via_mysql_shell\" >via MySQL Shell<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#via_phpmyadmin\" >via phpMyAdmin<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#repair_database_table_using_phpmyadmin\" >Repair Database Table Using phpMyAdmin<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#access_phpmyadmin_using_cpanel_interface\" >Access phpMyAdmin Using cPanel Interface<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#access_phpmyadmin_using_whm_interface\" >Access phpMyAdmin Using WHM Interface<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#repair_multiple_tables\" >Repair Multiple Tables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#repair_single_table\" >Repair Single Table<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#create_a_mysql_database_table_in_phpmyadmin\" >Create a MySQL Database Table in PhpMyAdmin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n\n<p>You might have interacted with the PhpMyAdmin to manage the database tables, repair the database table, and for many small tasks. Before that, we will learn more about how to check the MySQL version and how to repair and create a table using PhpMyAdmin?<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"check_mysql_version\"><\/span>Check MySQL Version<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>MySQL is the most popular Relational Database Management System in use today, and is going to be used in some form on any Linux-based webserver. Knowing which version you are currently using is important, as some important features and configurations change based on the MySQL server version.<\/p>\n\n\n\n<p>Please note that the instructions provided in this short document work for both MySQL and MariaDB. The relevant differences will be explained later on.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"via_ssh_shell\"><\/span>via SSH Shell<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Once you have logged in to the server via&nbsp;SSH&nbsp;type the command:&nbsp;<code>mysql -V<\/code>. Here are the command and its results:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"341\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/mysql-v-command-line-1024x341.jpg\" alt=\"mysql v command line\" class=\"wp-image-5443\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/mysql-v-command-line-1024x341.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/mysql-v-command-line-300x100.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/mysql-v-command-line-768x256.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/mysql-v-command-line.jpg 1284w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"via_mysql_shell\"><\/span>via MySQL Shell<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You could also check the MySQL version from the MySQL shell. You can enter the MySQL shell by typing <strong>mysql<\/strong> at the command prompt. Once you are in the mysql shell you can execute the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>show variables  like '%version%';<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"885\" height=\"764\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/login-to-mysql-run-the-command-mysql-v-check-copy.jpg\" alt=\"login to mysql run the command mysql v check copy\" class=\"wp-image-5444\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/login-to-mysql-run-the-command-mysql-v-check-copy.jpg 885w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/login-to-mysql-run-the-command-mysql-v-check-copy-300x259.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/login-to-mysql-run-the-command-mysql-v-check-copy-768x663.jpg 768w\" sizes=\"(max-width: 885px) 100vw, 885px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"via_phpmyadmin\"><\/span>via phpMyAdmin<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Once you log in to phpMyAdmin \u2192 on the Home interface, you can see the Database Server information, mentioned with the database version and other details.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"319\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/how-to-check-database-version-using-phpmyadmin-1024x319.jpg\" alt=\"how to check database version using phpmyadmin\" class=\"wp-image-5467\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/how-to-check-database-version-using-phpmyadmin-1024x319.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/how-to-check-database-version-using-phpmyadmin-300x94.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/how-to-check-database-version-using-phpmyadmin-768x240.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/how-to-check-database-version-using-phpmyadmin-1536x479.jpg 1536w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/how-to-check-database-version-using-phpmyadmin.jpg 1616w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"repair_database_table_using_phpmyadmin\"><\/span>Repair Database Table Using phpMyAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>You can access PhpMyAdmin using two methods through cPanel as well as using Web Host Manager.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"access_phpmyadmin_using_cpanel_interface\"><\/span>Access phpMyAdmin Using cPanel Interface<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Login to cPanel \u2192 Navigate to Databases \u2192 phpMyAdmin.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"460\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-cpanel-1024x460.jpg\" alt=\"navigate to phpmyadmin cpanel\" class=\"wp-image-5450\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-cpanel-1024x460.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-cpanel-300x135.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-cpanel-768x345.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-cpanel.jpg 1151w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"access_phpmyadmin_using_whm_interface\"><\/span>Access phpMyAdmin Using WHM Interface<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Login to cPanel \u2192 Navigate to SQL Services \u2192 phpMyAdmin.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"321\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-whm-1024x321.jpg\" alt=\"navigate to phpmyadmin whm\" class=\"wp-image-5451\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-whm-1024x321.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-whm-300x94.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-whm-768x241.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-whm.jpg 1242w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>You can follow,<strong> <a href=\"https:\/\/www.knownhost.com\/kb\/how-to-access-phpmyadmin-in-the-directadmin\/\">How to access phpMyAdmin in the DirectAdmin?<\/a><\/strong> if you&#8217;re dealing with DirectAdmin control panel.<\/p>\n\n\n<div class=\"kb-shortcode kb-shortcode_warning\">\n                    <div class=\"kb-shortcode-icon\">\n                        <i class=\"fa fa-exclamation-triangle fa-2x\"><\/i>\n                    <\/div>\n                    <div class=\"kb-shortcode-content_warning\">This method works only when the damaged table is using the MyISAM engine. If the InnoDB table is corrupted, then more advanced techniques should be used.<\/div>\n                <\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"repair_multiple_tables\"><\/span>Repair Multiple Tables<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Log<\/strong> in to <strong>phpMyAdmin<\/strong> \u2192 <strong>Click<\/strong> on <strong>Database<\/strong> \u2192 <strong>Select<\/strong> the <strong>required<\/strong> <strong>tables<\/strong> that need to be repaired \u2192 <strong>Click<\/strong> on <strong>With<\/strong> <strong>Selected<\/strong>.<\/p>\n\n\n\n<p><strong>Note<\/strong>: For confirmation, we have highlighted the type of database engine. in blue outline, which is MyISAM. Hence, it is fully compatible to repair tables using this method.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"446\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-database-tables-to-repair-using-phpmyadmin-1024x446.jpg\" alt=\"select database - tables to repair using phpmyadmin\" class=\"wp-image-5453\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-database-tables-to-repair-using-phpmyadmin-1024x446.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-database-tables-to-repair-using-phpmyadmin-300x131.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-database-tables-to-repair-using-phpmyadmin-768x335.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-database-tables-to-repair-using-phpmyadmin.jpg 1260w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>From the drop-down <strong>select<\/strong> <strong>Repair<\/strong> <strong>table<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"672\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-repair-table-from-the-list-tables-1024x672.jpg\" alt=\"select repair table from the list tables\" class=\"wp-image-5454\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-repair-table-from-the-list-tables-1024x672.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-repair-table-from-the-list-tables-300x197.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-repair-table-from-the-list-tables-768x504.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-repair-table-from-the-list-tables.jpg 1088w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>After selecting the Repair Table option, the system will instantly execute the query to repair the selected tables. Post execution of query you could see confirmation that selected database tables have been repaired,<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"326\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/Repair-Multiple-Tables-using-phpmyadmin-1024x326.jpg\" alt=\"Repair Multiple Tables using phpmyadmin\" class=\"wp-image-5452\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/Repair-Multiple-Tables-using-phpmyadmin-1024x326.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/Repair-Multiple-Tables-using-phpmyadmin-300x95.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/Repair-Multiple-Tables-using-phpmyadmin-768x244.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/Repair-Multiple-Tables-using-phpmyadmin.jpg 1088w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"repair_single_table\"><\/span>Repair Single Table<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Log<\/strong> in to <strong>phpMyAdmin<\/strong> \u2192 <strong>Click<\/strong> on <strong>Database<\/strong> \u2192 <strong>Select<\/strong> the <strong>individual<\/strong> <strong>table <\/strong>that<strong> <\/strong>needs to be repaired.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"364\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-the-individual-table-from-phpmyadmin-database-1024x364.jpg\" alt=\"\" class=\"wp-image-5461\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-the-individual-table-from-phpmyadmin-database-1024x364.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-the-individual-table-from-phpmyadmin-database-300x107.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-the-individual-table-from-phpmyadmin-database-768x273.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/select-the-individual-table-from-phpmyadmin-database.jpg 1357w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Next, <strong>navigate<\/strong> to <strong>Operations<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"364\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-operations-phpmyadmin-table-1024x364.jpg\" alt=\"\" class=\"wp-image-5459\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-operations-phpmyadmin-table-1024x364.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-operations-phpmyadmin-table-300x107.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-operations-phpmyadmin-table-768x273.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-operations-phpmyadmin-table.jpg 1357w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Scroll<\/strong> <strong>down<\/strong> and <strong>navigate<\/strong> to <strong>Table<\/strong> <strong>maintenance<\/strong> section \u2192 <strong>Click<\/strong> on <strong>Repair<\/strong> <strong>table<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"655\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-table-maintenance-repair-table--1024x655.jpg\" alt=\"navigate to table maintenance repair table\" class=\"wp-image-5460\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-table-maintenance-repair-table--1024x655.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-table-maintenance-repair-table--300x192.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-table-maintenance-repair-table--768x491.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-table-maintenance-repair-table-.jpg 1357w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>After selecting the Repair Table option, the system will instantly execute the query to repair the selected table. Post execution of query you could see confirmation that selected database table has been repaired,<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"327\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/how-to-repair-selected-table-using-phpmyadmin-1024x327.jpg\" alt=\"how to repair selected table using phpmyadmin\" class=\"wp-image-5458\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/how-to-repair-selected-table-using-phpmyadmin-1024x327.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/how-to-repair-selected-table-using-phpmyadmin-300x96.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/how-to-repair-selected-table-using-phpmyadmin-768x245.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/how-to-repair-selected-table-using-phpmyadmin.jpg 1357w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"create_a_mysql_database_table_in_phpmyadmin\"><\/span>Create a MySQL Database Table in PhpMyAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Most applications need databases to properly work, and although for the most part we do not need to modify these databases, we do need to create, delete, backup and restore databases from time to time.<\/p>\n\n\n\n<p>Once we have logged into phpMyAdmin, we are going to see existing databases on the left top side of the screen. First, click on the desired database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"315\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-select-db-1024x315.jpg\" alt=\"navigate to phpmyadmin select db\" class=\"wp-image-5466\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-select-db-1024x315.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-select-db-300x92.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-select-db-768x236.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-select-db-1536x472.jpg 1536w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/navigate-to-phpmyadmin-select-db.jpg 1543w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Once you click on the desired database, the &#8220;Create Table&#8221; form will be under the list of tables. Before the table is created, we will need to,<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Type in the name of the table.<\/li><li>Type in the &#8220;Number of columns\/fields&#8221; the table is going to contain.<\/li><li>Click Go.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"271\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/enter-the-table-name-and-click-on-ok-1024x271.jpg\" alt=\"enter the table name and click on ok\" class=\"wp-image-5465\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/enter-the-table-name-and-click-on-ok-1024x271.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/enter-the-table-name-and-click-on-ok-300x80.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/enter-the-table-name-and-click-on-ok-768x204.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/enter-the-table-name-and-click-on-ok-1536x407.jpg 1536w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/enter-the-table-name-and-click-on-ok.jpg 1543w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Once we have clicked on &#8220;Go&#8221; we will see a screen asking for several fields. For the simplest tables, we can focus on the first three fields:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Name of the column.<\/li><li>Type of characterset, for example, INT for integers or VARCHAR for regular text.<\/li><li>The maximum length these fields can store in characters.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"396\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/enter-required-details-create-table-using-phpmyadmin-1024x396.jpg\" alt=\"enter required details create table using phpmyadmin\" class=\"wp-image-5464\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/enter-required-details-create-table-using-phpmyadmin-1024x396.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/enter-required-details-create-table-using-phpmyadmin-300x116.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/enter-required-details-create-table-using-phpmyadmin-768x297.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/enter-required-details-create-table-using-phpmyadmin-1536x594.jpg 1536w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/enter-required-details-create-table-using-phpmyadmin.jpg 1543w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Once the above is done, we can click save and that is it, you have a new table.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"230\" src=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/Create-a-MySQL-Table-in-PhpMyAdmin-1024x230.jpg\" alt=\"Create a MySQL Table in PhpMyAdmin\" class=\"wp-image-5463\" srcset=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/Create-a-MySQL-Table-in-PhpMyAdmin-1024x230.jpg 1024w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/Create-a-MySQL-Table-in-PhpMyAdmin-300x67.jpg 300w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/Create-a-MySQL-Table-in-PhpMyAdmin-768x172.jpg 768w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/Create-a-MySQL-Table-in-PhpMyAdmin-1536x344.jpg 1536w, https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/Create-a-MySQL-Table-in-PhpMyAdmin.jpg 1543w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now that we\u2019ve gone over how to Repair, Create Database Table using phpMyAdmin &amp; Check version of MySQL. This tutorial is not specific to any control panel, you can use this article to perform mentioned methods on any server which has phpMyAdmin installed on it.<\/p>\n\n\n\n<p>KnownHost offers 365 days a year, 24 hours a day, all 7 days of the week best in class technical support. A dedicated team ready to help you with requests should you need our assistance. You\u2019re not using KnownHost for the best webhosting experience? Well, why not? Check with&nbsp;<a href=\"https:\/\/www.knownhost.com\/contact\">our Sales team<\/a>&nbsp;to see what can&nbsp;<a href=\"https:\/\/www.knownhost.com\/\">KnownHost<\/a>&nbsp;do for you in improving your webhosting experience.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You might have interacted with the PhpMyAdmin to manage the database tables, repair the database table, and for many small tasks. Before that, we will learn more about how to check the MySQL version and how to repair and create a table using PhpMyAdmin? Check MySQL Version MySQL is the most popular Relational Database Management [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[91],"tags":[522,257,186,258,521,375],"class_list":["post-5424","post","type-post","status-publish","format-standard","hentry","category-guides","tag-create-table","tag-database","tag-mysql","tag-phpmyadmin","tag-repair-database","tag-version"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Repair &amp; Create MySQL Tables in phpMyAdmin: Complete Guide | KnownHost<\/title>\n<meta name=\"description\" content=\"Learn to directly repair and create database table using phpMyAdmin interface and steps to check version MySQL or MariaDB database server.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Repair &amp; Create MySQL Tables in phpMyAdmin: Complete Guide | KnownHost\" \/>\n<meta property=\"og:description\" content=\"Learn to directly repair and create database table using phpMyAdmin interface and steps to check version MySQL or MariaDB database server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"KnownHost\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-21T13:08:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-23T12:31:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/mysql-v-command-line.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1284\" \/>\n\t<meta property=\"og:image:height\" content=\"428\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Somesh Z\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Somesh Z\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\\\/\"},\"author\":{\"name\":\"Somesh Z\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/8b518f13cf69dd00d147e577d63ff3b1\"},\"headline\":\"How to Repair, Create Database Table using phpMyAdmin &amp; Check version of MySQL?\",\"datePublished\":\"2021-12-21T13:08:52+00:00\",\"dateModified\":\"2026-01-23T12:31:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\\\/\"},\"wordCount\":778,\"image\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/mysql-v-command-line-1024x341.jpg\",\"keywords\":[\"create table\",\"database\",\"mysql\",\"phpmyadmin\",\"repair database\",\"version\"],\"articleSection\":[\"Guides\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\\\/\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\\\/\",\"name\":\"Repair & Create MySQL Tables in phpMyAdmin: Complete Guide | KnownHost\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/mysql-v-command-line-1024x341.jpg\",\"datePublished\":\"2021-12-21T13:08:52+00:00\",\"dateModified\":\"2026-01-23T12:31:06+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/8b518f13cf69dd00d147e577d63ff3b1\"},\"description\":\"Learn to directly repair and create database table using phpMyAdmin interface and steps to check version MySQL or MariaDB database server.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/mysql-v-command-line.jpg\",\"contentUrl\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2021\\\/12\\\/mysql-v-command-line.jpg\",\"width\":1284,\"height\":428,\"caption\":\"mysql v command line\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Repair, Create Database Table using phpMyAdmin &amp; Check version of MySQL?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\",\"name\":\"KnownHost\",\"description\":\"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/8b518f13cf69dd00d147e577d63ff3b1\",\"name\":\"Somesh Z\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g\",\"caption\":\"Somesh Z\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Repair & Create MySQL Tables in phpMyAdmin: Complete Guide | KnownHost","description":"Learn to directly repair and create database table using phpMyAdmin interface and steps to check version MySQL or MariaDB database server.","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:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Repair & Create MySQL Tables in phpMyAdmin: Complete Guide | KnownHost","og_description":"Learn to directly repair and create database table using phpMyAdmin interface and steps to check version MySQL or MariaDB database server.","og_url":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/","og_site_name":"KnownHost","article_published_time":"2021-12-21T13:08:52+00:00","article_modified_time":"2026-01-23T12:31:06+00:00","og_image":[{"width":1284,"height":428,"url":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/mysql-v-command-line.jpg","type":"image\/jpeg"}],"author":"Somesh Z","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Somesh Z","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#article","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/"},"author":{"name":"Somesh Z","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/8b518f13cf69dd00d147e577d63ff3b1"},"headline":"How to Repair, Create Database Table using phpMyAdmin &amp; Check version of MySQL?","datePublished":"2021-12-21T13:08:52+00:00","dateModified":"2026-01-23T12:31:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/"},"wordCount":778,"image":{"@id":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/mysql-v-command-line-1024x341.jpg","keywords":["create table","database","mysql","phpmyadmin","repair database","version"],"articleSection":["Guides"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/","url":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/","name":"Repair & Create MySQL Tables in phpMyAdmin: Complete Guide | KnownHost","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#primaryimage"},"image":{"@id":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/mysql-v-command-line-1024x341.jpg","datePublished":"2021-12-21T13:08:52+00:00","dateModified":"2026-01-23T12:31:06+00:00","author":{"@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/8b518f13cf69dd00d147e577d63ff3b1"},"description":"Learn to directly repair and create database table using phpMyAdmin interface and steps to check version MySQL or MariaDB database server.","breadcrumb":{"@id":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#primaryimage","url":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/mysql-v-command-line.jpg","contentUrl":"https:\/\/www.knownhost.com\/kb\/wp-content\/uploads\/2021\/12\/mysql-v-command-line.jpg","width":1284,"height":428,"caption":"mysql v command line"},{"@type":"BreadcrumbList","@id":"https:\/\/www.knownhost.com\/kb\/repair-create-database-table-using-phpmyadmin-check-version-of-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.knownhost.com\/kb\/"},{"@type":"ListItem","position":2,"name":"How to Repair, Create Database Table using phpMyAdmin &amp; Check version of MySQL?"}]},{"@type":"WebSite","@id":"https:\/\/www.knownhost.com\/kb\/#website","url":"https:\/\/www.knownhost.com\/kb\/","name":"KnownHost","description":"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.knownhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/8b518f13cf69dd00d147e577d63ff3b1","name":"Somesh Z","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/276c97317c2d6905cc5a1bd9ceb10a0fd121cc4da22126f648fa88f95dcf32dd?s=96&d=mm&r=g","caption":"Somesh Z"}}]}},"_links":{"self":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/5424","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/comments?post=5424"}],"version-history":[{"count":1,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/5424\/revisions"}],"predecessor-version":[{"id":7994,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/5424\/revisions\/7994"}],"wp:attachment":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/media?parent=5424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/categories?post=5424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/tags?post=5424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}