{"id":1223,"date":"2021-08-06T07:49:38","date_gmt":"2021-08-06T07:49:38","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=1223"},"modified":"2021-08-06T08:18:55","modified_gmt":"2021-08-06T08:18:55","slug":"1223","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/1223\/","title":{"rendered":"How to Create &#038; Manage Databases With PHPmyadmin in Cpanel"},"content":{"rendered":"<p>While creating a database, following are some further things that they have to organize \u2013<\/p>\n<ul>\n<li>Creating a database user<\/li>\n<li>Giving your database user rights to work with your database<\/li>\n<\/ul>\n<p>Fortunately, cPanel added the MySQL Database Wizard which will help in creation of database just by following the steps given below.<\/p>\n<h4>How to create database in cPanel using the MySQL Database Wizard-<\/h4>\n<ul>\n<li>Login to your cPanel account provided by your cPanel hosting provider<\/li>\n<li>Click the\u00a0<b>MySQL Database Wizard<\/b>\u00a0below the\u00a0<i>Databases<\/i><\/li>\n<li>Enter a name for your database next to\u00a0<b><i>New Database<\/i><\/b>\u00a0and click on\u00a0<b><i>Next Step<\/i><\/b><\/li>\n<li>Enter a username Next to\u00a0<b>Username<\/b>.<\/li>\n<li>Enter a password next to\u00a0<b>Password<\/b>, reenter the Password and then click on\u00a0<b><i>Create User<\/i><\/b><\/li>\n<li>On the next page, you can assign rights for the user to the database. Check the box next to\u00a0<b><i>All Privileges<\/i><\/b>\u00a0and then click on\u00a0<b><i>Next Step<\/i><\/b><\/li>\n<\/ul>\n<p>Thus you have successfully created the database!<\/p>\n<p>For managing the databases by using phpMyAdmin in cPanel, you can handle various options such as:<\/p>\n<ul>\n<li><b>Structure:<\/b>\u00a0 Helps to organize your schemas, tables, and columns.<\/li>\n<li><b>SQL:<\/b>\u00a0 Runs SQL query\/queries on a database.<\/li>\n<li><b>Search:<\/b>\u00a0Searches words or values inside database tables.<\/li>\n<li><b>Query:<\/b>\u00a0SQL defines a set of commands, such as SELECT, INSERT, UPDATE, DELETE, CREATE TABLE and etc.<\/li>\n<li><b>Export:<\/b>\u00a0Exports database in different formats such as CSV, PDF, SQL, XML, Text etc.<\/li>\n<li><b>Import:<\/b>\u00a0Imports database in different formats such as OpenDocument Spreadsheet, CSV, SQL, ESRI Shape file, MediaWiki Table, XML.<\/li>\n<li><b>Operations:<\/b>\u00a0There are various operations which you can execute on the whole database and on a separate table.<\/li>\n<li><b>Triggers:<\/b>\u00a0A trigger is known as database object that is linked with a table, and it activates whenever a particular event (e.g. an insert, update or delete) happens for the table.<\/li>\n<\/ul>\n<p>The basic functionality of the phpMyAdmin is to manage your databases. To create database follow the below steps:<\/p>\n<p><strong>Step1:<\/strong><\/p>\n<p>Click on the <b>Databases<\/b> tab. Select the database which you want to manage and click on the database name.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1224\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-1-300x168.png\" alt=\"db-1\" width=\"658\" height=\"369\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-1-300x168.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-1.png 658w\" sizes=\"auto, (max-width: 658px) 100vw, 658px\" \/><\/p>\n<p><strong>Step 2: <\/strong>After clicking on the database name, the list of <b>database tables <\/b>will get appear.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1225\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-2-300x140.png\" alt=\"db-2\" width=\"983\" height=\"458\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-2-300x140.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-2-768x358.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-2.png 983w\" sizes=\"auto, (max-width: 983px) 100vw, 983px\" \/><\/p>\n<h2>Operations to Perform on the Database<\/h2>\n<h3><b>Browse:<\/b><\/h3>\n<p>With existing records, You can browse the database tables. When you click on the table name, the <b>Browse<\/b>\u00a0window opens with the records.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1226\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-3-300x135.png\" alt=\"db-3\" width=\"1024\" height=\"462\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-3-300x135.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-3-768x347.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-3.png 1024w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>The record can be edited by simply clicking on the Pen symbol.<\/p>\n<h3><b>Structure:<\/b><\/h3>\n<p>In the\u00a0<b>structure<\/b> screen you will see the structure of database\u2019s table. Which will include the field name, their data types, collation, attributes etc. You can change the field\u2019s structure as well as delete a field. Also, you can assign indexes i.e. Primary, Unique, Index, Fulltext.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1227\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-4-300x133.png\" alt=\"db-4\" width=\"1097\" height=\"486\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-4-300x133.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-4-1024x454.png 1024w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-4-768x340.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-4.png 1097w\" sizes=\"auto, (max-width: 1097px) 100vw, 1097px\" \/><\/p>\n<h3><b>Search:<\/b><\/h3>\n<p>By using <b>Search<\/b> action, you can create a search query for the selected table. Either you can write the <strong>WHERE<\/strong> clause or use the \u201c<strong>query by example<\/strong>\u201d option. Click on the <strong>Go<\/strong> button to perform search query.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1228\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-5-300x130.png\" alt=\"db-5\" width=\"1090\" height=\"473\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-5-300x130.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-5-1024x444.png 1024w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-5-768x333.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-5.png 1090w\" sizes=\"auto, (max-width: 1090px) 100vw, 1090px\" \/><\/p>\n<h3><b>Insert:<\/b><\/h3>\n<p>Through the <b>Insert<\/b> action, record can be inserted in database. To insert a new record you require to fill the appropriate values and click on the Go button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1229\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-6-300x149.png\" alt=\"db-6\" width=\"1000\" height=\"497\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-6-300x149.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-6-768x382.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-6.png 1000w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/p>\n<h3><b>Empty:<\/b><\/h3>\n<p>Using the <b>Empty<\/b> option, you can empty your database table. It will remove the records and keep the table blank.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1230\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-7-300x149.png\" alt=\"db-7\" width=\"988\" height=\"491\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-7-300x149.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-7-768x382.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-7.png 988w\" sizes=\"auto, (max-width: 988px) 100vw, 988px\" \/><\/p>\n<h3><b>Drop:<\/b><\/h3>\n<p>You can delete the table as well as delete stored records in it by using the\u00a0<b>Drop<\/b> option.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1231\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-8-300x148.png\" alt=\"db-8\" width=\"985\" height=\"485\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-8-300x148.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-8-768x378.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-8.png 985w\" sizes=\"auto, (max-width: 985px) 100vw, 985px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>While creating a database, following are some further things that they have to organize \u2013 Creating a database user Giving your database user rights to work with your database Fortunately, cPanel added the MySQL Database Wizard which will help in creation of database just by following the steps given below. How to create database in [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-1223","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Create &amp; Manage Databases With PHPmyadmin in Cpanel - OWS KB<\/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:\/\/ownwebservers.com\/kb\/1223\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create &amp; Manage Databases With PHPmyadmin in Cpanel - OWS KB\" \/>\n<meta property=\"og:description\" content=\"While creating a database, following are some further things that they have to organize \u2013 Creating a database user Giving your database user rights to work with your database Fortunately, cPanel added the MySQL Database Wizard which will help in creation of database just by following the steps given below. How to create database in [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/1223\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-06T07:49:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-06T08:18:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-1-300x168.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"2 minutes\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/1223\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/08\/db-1.png\",\"width\":658,\"height\":369,\"caption\":\"db-1\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/1223\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/1223\/\",\"name\":\"How to Create & Manage Databases With PHPmyadmin in Cpanel - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/1223\/#primaryimage\"},\"datePublished\":\"2021-08-06T07:49:38+00:00\",\"dateModified\":\"2021-08-06T08:18:55+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/1223\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/1223\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/1223\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/1223\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/1223\/\",\"name\":\"How to Create &#038; Manage Databases With PHPmyadmin in Cpanel\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=1223"}],"version-history":[{"count":2,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1223\/revisions"}],"predecessor-version":[{"id":1233,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/1223\/revisions\/1233"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=1223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=1223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=1223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}