{"id":38253,"date":"2017-02-09T13:51:28","date_gmt":"2017-02-09T19:51:28","guid":{"rendered":"http:\/\/webirix.com\/?p=38253"},"modified":"2017-02-09T13:53:10","modified_gmt":"2017-02-09T19:53:10","slug":"crear-una-base-datos-mysql-desde-cpanel","status":"publish","type":"post","link":"https:\/\/webirix.com\/en\/crear-una-base-datos-mysql-desde-cpanel\/","title":{"rendered":"How to create a database in MySQL from cpanel?"},"content":{"rendered":"<p>- To create a new MySQL database in our cPanel hosting panel, we must first access the control panel through the usual link:<br \/>\nhttp:\/\/alexander.kiubix.link\/cpanel<br \/>\n&nbsp;<\/p>\n<ul>\n<li>We access the Databases menu, in the section <strong>MySQL Databases<\/strong>.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-38255 aligncenter\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos1-300x30.png\" alt=\"\" width=\"610\" height=\"61\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos1-300x30.png 300w, https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos1-768x76.png 768w, https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos1-600x60.png 600w, https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos1.png 975w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/a><\/p>\n<ul>\n<li>\u00a0We create a new <em>database<\/em> MySQL by typing the name in the box and pressing <em>&#8220;Crear Base de Datos&#8221;<\/em><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-38257 aligncenter\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos2-300x73.png\" alt=\"\" width=\"514\" height=\"125\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos2-300x73.png 300w, https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos2-768x186.png 768w, https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos2-1024x247.png 1024w, https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos2-600x145.png 600w, https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/basededatos2.png 1142w\" sizes=\"auto, (max-width: 514px) 100vw, 514px\" \/><\/a><\/p>\n<ul>\n<li>Once the database is created, we will create the user that will work with the database.<\/li>\n<li>\u00a0To create a User for the Database and a password for it. We will have to repeat the password twice for security or as the example Generate one and select I have copied the password in a safe place. Click on <em>&#8220;Crear Usuario&#8221;<\/em>.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/usuario1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-38258 aligncenter\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/usuario1-300x139.png\" alt=\"\" width=\"561\" height=\"260\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/usuario1-300x139.png 300w, https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/usuario1-768x355.png 768w, https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/usuario1-600x278.png 600w, https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/usuario1.png 808w\" sizes=\"auto, (max-width: 561px) 100vw, 561px\" \/><\/a><\/p>\n<p>- We assign the User to the Database from <em>&#8220;A\u00f1adir Usuario a la Base de Datos&#8221;<\/em>. This step is sometimes confused by more inexperienced users. <strong>It is not enough to create a user and a database,<\/strong> it is totally necessary <strong>Link the User with the Database.<\/strong><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/usuariodb.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-38259 aligncenter\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/usuariodb-300x106.png\" alt=\"\" width=\"572\" height=\"202\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/usuariodb-300x106.png 300w, https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/usuariodb.png 584w\" sizes=\"auto, (max-width: 572px) 100vw, 572px\" \/><\/a><br \/>\nIt is important that<strong> let&#039;s grant all privileges to the user <\/strong>so that it connects correctly with the Database.<\/p>\n<p>&nbsp;<\/p>\n<h2><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/permisosuserdb.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-38260 aligncenter\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/permisosuserdb-210x300.png\" alt=\"\" width=\"402\" height=\"574\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/permisosuserdb-210x300.png 210w, https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/permisosuserdb.png 293w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/a><br \/>\nWhat is a MySQL Database Good for?<\/h2>\n<p>MySQL databases are wildly popular even if you don&#039;t really know you&#039;re using them. For example, a MySQL database is necessary for file managers as common as <strong>WordPress, PrestaShop, Joomla !, Magento, etc ...<\/strong><\/p>\n<p>Any dynamic website needs a database to function properly since it is the place where all the information is stored.<\/p>\n<p>For example, on this website that you are currently viewing while reading this article, <strong>makes use of a MySQL database.<\/strong><\/p>\n<p>When you have entered the page, the system has been in charge of generating the page, which is not a file hosted on a server, but is generated on the fly with each request from each user and each request generates a query to the database which is responsible for storing, archiving and offering the necessary content at all times.<\/p>","protected":false},"excerpt":{"rendered":"<p>- To create a new MySQL database in our cPanel hosting panel, we must first access the control panel through the usual link: http:\/\/alexander.kiubix.link\/cpanel We access the Databases menu, in the MySQL Databases section. We create a new MySQL database writing the name in the ...<\/p>","protected":false},"author":25,"featured_media":38261,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2258],"tags":[],"class_list":["post-38253","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel"],"jetpack_featured_media_url":"https:\/\/webirix.com\/wp-content\/uploads\/2017\/02\/Blue-User-Authentication-Icon.png","_links":{"self":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/38253","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/comments?post=38253"}],"version-history":[{"count":3,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/38253\/revisions"}],"predecessor-version":[{"id":38263,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/38253\/revisions\/38263"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media\/38261"}],"wp:attachment":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media?parent=38253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/categories?post=38253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/tags?post=38253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}