{"id":97051,"date":"2022-05-20T14:22:47","date_gmt":"2022-05-20T18:22:47","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/?p=97051"},"modified":"2024-10-22T11:58:12","modified_gmt":"2024-10-22T15:58:12","slug":"mysql-database-cwp","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/","title":{"rendered":"Create MySQL Databases in Control Web Panel (CWP)"},"content":{"rendered":"<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"538\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases-1024x538.jpg\" alt=\"MySQL Databases in Control Web Panel\" class=\"wp-image-97047\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases-1024x538.jpg 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases-300x158.jpg 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases-768x403.jpg 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases.jpg 1200w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n\n\n\n<p>MySQL is the most popular open-source relational database management system (RDBMS) today. Many of the most popular LAMP-stack web applications depend on MySQL\/MariaDB to manage large amounts of data. WordPress, PrestaShop, and Nextcloud are notable examples. This is likely why MySQL is natively included with a Control Web Panel installation.<\/p>\n\n\n\n<p>Below we\u2019ll cover how to create a MySQL database in CWP.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#database\">Create a MySQL Database<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"#user\">Create MySQL Users<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#settings\">MySQL Server Settings<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"#reset\">Reset MySQL User Passwords<\/a><\/li>\n\n\n\n<li><a href=\"#remote\">Remote Database Management<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"database\">Create a MySQL Database<\/h2>\n\n\n\n<p>Since MySQL is already installed on CWP servers, you simply need to know how to access it in your web hosting control panel.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/install-control-web-panel-cwp\/#login\">Log into CWP<\/a>.<\/li>\n\n\n\n<li>On the left select <strong>MySQL Manager<\/strong>. End users will need to select <strong>Databases<\/strong> to see the <strong>MySQL Manager<\/strong> option. You\u2019ll see all databases to which you have access. For admin users that includes mysql, oauthv2, performance_schema, postfix, root_cwp, and roundcube.<br><figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"531\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-admin-1024x531.png\" alt=\"CWP MySQL databases\" class=\"wp-image-97044\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-admin-1024x531.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-admin-300x156.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-admin-768x398.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-admin.png 1332w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure><br>Regular users will see no databases unless any were manually created for that user.<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"127\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-1024x127.png\" alt=\"List Databases and Users in a CWP end user panel\" class=\"wp-image-97043\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-1024x127.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-300x37.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-768x95.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-1536x190.png 1536w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user.png 1617w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure><br>Each row in the database list shows the database name, action buttons to modify and the database, owner, and system users. The buttons can optimize, check, repair, and backup the database.<br>Manually created databases will include an additional option to assign a database user and delete the database.<\/li>\n\n\n\n<li>To create a MySQL database, admin users select <strong>Add new database<\/strong> from the top-right corner. End users, select <strong>Add database<\/strong> from the same location.<\/li>\n\n\n\n<li>Admin users must assign a CWP user to the database. End users can choose to assign a database user from their account.<\/li>\n\n\n\n<li>Type a name for the new database. It will be modified to include the database user as a prefix (e.g. \u201cuser_wp757\u201d).<\/li>\n\n\n\n<li>Specify a character set (charset) if necessary. The most common ones are \u201cutf8mb4_unicode_ci\u201d and \u201cutf8mb4_general_ci.\u201d<\/li>\n\n\n\n<li>Select <strong>Save<\/strong>. The page will refresh and show your new MySQL database.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"user\">Create MySQL Users<\/h3>\n\n\n\n<p>There are two ways to create MySQL users in CWP. The first method is for an admin user to simply <a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/add-cwp-user\/\">create a new CWP user<\/a>. This automatically creates a MySQL database user of the same name.<\/p>\n\n\n\n<p>The second is for an end user to create a database user under their account. We\u2019ll cover the latter method below.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>From the MySQL Manager page, select <strong>Add User<\/strong>.<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"290\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-new-user-1024x290.png\" alt=\"Create a new MySQL database user\" class=\"wp-image-97045\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-new-user-1024x290.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-new-user-300x85.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-new-user-768x217.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-new-user-1536x435.png 1536w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-new-user.png 1614w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure><\/li>\n\n\n\n<li>Type a MySQL username.<\/li>\n\n\n\n<li>Specify the host if necessary.<\/li>\n\n\n\n<li>Create a strong password.<\/li>\n\n\n\n<li>Add the user to an existing database if necessary.<\/li>\n\n\n\n<li>Select <strong>Save<\/strong>.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"settings\">MySQL Server Settings<\/h2>\n\n\n\n<p>Now that you know how to create MySQL databases and MySQL users in CWP,\u00a0 there are some related tasks you should be familiar with.<\/p>\n\n\n\n<p class=\"alert alert-info\">Remember, within the database list are options to <a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/repair-mysql-database-cwp\/\">check and repair MySQL databases<\/a> in CWP. Within the database list, select the \u201ccheck database\u201d button, then the \u201crepair database\u201d button. Advanced users can do this in the MySQL command-line interface (CLI) as well.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"reset\">Reset MySQL User Passwords<\/h3>\n\n\n\n<p>CWP server admin users can change database user passwords by selecting <strong>Users <\/strong>at the top the page. Then select the gears icon under the \u201cActions\u201d column.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"825\" height=\"460\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-users.png\" alt=\"CWP MySQL database users\" class=\"wp-image-97041\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-users.png 825w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-users-300x167.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-users-768x428.png 768w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n\n\n\n<p>End users have a slightly different process.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select <strong>List Users<\/strong>.<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"270\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-users-1024x270.png\" alt=\"List Users in a CWP end user panel\" class=\"wp-image-97042\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-users-1024x270.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-users-300x79.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-users-768x202.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-users-1536x404.png 1536w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-user-users.png 1611w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure><\/li>\n\n\n\n<li>Select <strong>Change password<\/strong> beside the user you want to edit.<\/li>\n\n\n\n<li>Type a new password.<\/li>\n\n\n\n<li>Select <strong>Change password<\/strong>.<\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"remote\">Remote Database Management<\/h3>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignright size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"558\" height=\"113\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-port-bind.png\" alt=\"CWP MySQL remote connection settings\" class=\"wp-image-97046\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-port-bind.png 558w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-manager-port-bind-300x61.png 300w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n<\/div>\n\n\n<p>Admin users can change remote database connection settings from <strong>MySQL Manager<\/strong> &gt; <strong>Settings<\/strong>.<\/p>\n\n\n\n<p>The default listening port is 3306.<\/p>\n\n\n\n<p>The default bind address is 0.0.0.0.\u00a0<\/p>\n\n\n\n<p>Don\u2019t forget to select <strong>Save settings<\/strong> after any changes.<\/p>\n\n\n\n<p>See what else you can do in <a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/\">CWP<\/a>.<\/p>\n\n\n<div class=\"jumbotron\">Make sure your business, agency, or reseller clients are always connected and powered on with our optimized <a href=\"https:\/\/www.inmotionhosting.com\/vps-hosting\">Managed VPS Hosting<\/a>.<\/div>\n","protected":false},"excerpt":{"rendered":"<p>MySQL is the most popular open-source relational database management system (RDBMS) today. Many of the most popular LAMP-stack web applications depend on MySQL\/MariaDB to manage large amounts of data. WordPress, PrestaShop, and Nextcloud are notable examples. This is likely why MySQL is natively included with a Control Web Panel installation. Below we\u2019ll cover how to<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/\"> Read More ><\/a><\/p>\n","protected":false},"author":57014,"featured_media":97047,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4527,4591],"tags":[],"class_list":["post-97051","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-control-web-panel","category-cwp-database-management"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Create MySQL Databases in Control Web Panel (CWP) | InMotion Hosting<\/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:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create MySQL Databases in Control Web Panel (CWP) | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"MySQL is the most popular open-source relational database management system (RDBMS) today. Many of the most popular LAMP-stack web applications depend on MySQL\/MariaDB to manage large amounts of data. WordPress, PrestaShop, and Nextcloud are notable examples. This is likely why MySQL is natively included with a Control Web Panel installation. Below we\u2019ll cover how to Read More &gt;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-20T18:22:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-22T15:58:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\"},\"headline\":\"Create MySQL Databases in Control Web Panel (CWP)\",\"datePublished\":\"2022-05-20T18:22:47+00:00\",\"dateModified\":\"2024-10-22T15:58:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/\"},\"wordCount\":594,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases.jpg\",\"articleSection\":[\"Control Web Panel\",\"CWP Database Management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/\",\"name\":\"Create MySQL Databases in Control Web Panel (CWP) | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases.jpg\",\"datePublished\":\"2022-05-20T18:22:47+00:00\",\"dateModified\":\"2024-10-22T15:58:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases.jpg\",\"width\":1200,\"height\":630,\"caption\":\"MySQL Databases in Control Web Panel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create MySQL Databases in Control Web Panel (CWP)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create MySQL Databases in Control Web Panel (CWP) | InMotion Hosting","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.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/","og_locale":"en_US","og_type":"article","og_title":"Create MySQL Databases in Control Web Panel (CWP) | InMotion Hosting","og_description":"MySQL is the most popular open-source relational database management system (RDBMS) today. Many of the most popular LAMP-stack web applications depend on MySQL\/MariaDB to manage large amounts of data. WordPress, PrestaShop, and Nextcloud are notable examples. This is likely why MySQL is natively included with a Control Web Panel installation. Below we\u2019ll cover how to Read More >","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2022-05-20T18:22:47+00:00","article_modified_time":"2024-10-22T15:58:12+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases.jpg","type":"image\/jpeg"}],"author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644"},"headline":"Create MySQL Databases in Control Web Panel (CWP)","datePublished":"2022-05-20T18:22:47+00:00","dateModified":"2024-10-22T15:58:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/"},"wordCount":594,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases.jpg","articleSection":["Control Web Panel","CWP Database Management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/","name":"Create MySQL Databases in Control Web Panel (CWP) | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases.jpg","datePublished":"2022-05-20T18:22:47+00:00","dateModified":"2024-10-22T15:58:12+00:00","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases.jpg","width":1200,"height":630,"caption":"MySQL Databases in Control Web Panel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/mysql-database-cwp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"Create MySQL Databases in Control Web Panel (CWP)"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/"}]}},"jetpack_featured_media_url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-mysql-databases.jpg","jetpack_sharing_enabled":true,"primary_category":{"id":4527,"name":"Control Web Panel","slug":"control-web-panel","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/97051","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/57014"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=97051"}],"version-history":[{"count":6,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/97051\/revisions"}],"predecessor-version":[{"id":103098,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/97051\/revisions\/103098"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media\/97047"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=97051"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=97051"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=97051"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}