{"id":6870,"date":"2018-04-26T09:14:34","date_gmt":"2018-04-26T07:14:34","guid":{"rendered":"https:\/\/blog.unelink.es\/?p=6870"},"modified":"2019-11-22T11:42:20","modified_gmt":"2019-11-22T10:42:20","slug":"crear-usuarios-para-una-base-de-datos-en-cpanel","status":"publish","type":"post","link":"https:\/\/hosting.airetech.es\/blog\/wiki\/crear-usuarios-para-una-base-de-datos-en-cpanel\/","title":{"rendered":"Crear usuarios para una base de datos en cPanel"},"content":{"rendered":"<p>Si tienes un <a href=\"https:\/\/www.unelink.es\/servidores-dedicados-32.html\" target=\"_blank\" rel=\"noopener noreferrer\">servidor dedicado<\/a>, <a href=\"https:\/\/www.unelink.es\/servidores-virtuales-33.html\" target=\"_blank\" rel=\"noopener noreferrer\">VPS<\/a> o <a href=\"https:\/\/www.unelink.es\/hosting-3.html\" target=\"_blank\" rel=\"noopener noreferrer\">hosting<\/a> con cPanel instalado, puedes utilizar el panel para <strong>crear f\u00e1cilmente usuarios para las bases de datos<\/strong> que tengas en una cuenta.<\/p>\n<p>Para ello, accede a cPanel con tu usuario y contrase\u00f1a.<\/p>\n<div id=\"attachment_6871\" style=\"width: 314px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/acceso-cpanel-1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6871\" class=\"size-full wp-image-6871\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/acceso-cpanel-1.jpg\" alt=\"Acceso cPanel\" width=\"304\" height=\"347\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/acceso-cpanel-1.jpg 304w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/acceso-cpanel-1-263x300.jpg 263w\" sizes=\"auto, (max-width: 304px) 100vw, 304px\" \/><\/a><p id=\"caption-attachment-6871\" class=\"wp-caption-text\">Acceso cPanel<\/p><\/div>\n<p>En la pantalla principal haz clic en el enlace \"Bases de datos MySQL\" dentro del apartado \"Bases de datos\".<\/p>\n<div id=\"attachment_6872\" style=\"width: 662px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/bases-de-datos-1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6872\" class=\" wp-image-6872\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/bases-de-datos-1.jpg\" alt=\"Bases de datos\" width=\"652\" height=\"228\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/bases-de-datos-1.jpg 838w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/bases-de-datos-1-300x105.jpg 300w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/bases-de-datos-1-768x269.jpg 768w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/bases-de-datos-1-600x210.jpg 600w\" sizes=\"auto, (max-width: 652px) 100vw, 652px\" \/><\/a><p id=\"caption-attachment-6872\" class=\"wp-caption-text\">Bases de datos<\/p><\/div>\n<p>Rellena los campos del formulario \"A\u00f1adir nuevo usuario\", dentro del apartado \"Usuarios MySQL\", y pulsa el bot\u00f3n \"Crear usuario\".<\/p>\n<div id=\"attachment_6873\" style=\"width: 660px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/nuevo-usuario-1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6873\" class=\" wp-image-6873\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/nuevo-usuario-1.jpg\" alt=\"Nuevo usuario\" width=\"650\" height=\"424\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/nuevo-usuario-1.jpg 687w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/nuevo-usuario-1-300x196.jpg 300w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/nuevo-usuario-1-600x391.jpg 600w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/a><p id=\"caption-attachment-6873\" class=\"wp-caption-text\">Nuevo usuario<\/p><\/div>\n<p>Una vez creado el usuario, tienes que asignarlo a la base de datos correspondiente. Para ello, dir\u00edgete al apartado \"A\u00f1adir usuario a la base de datos\", elige el usuario y la base de datos, y\u00a0 pulsa el bot\u00f3n \"A\u00f1adir\".<\/p>\n<div id=\"attachment_6874\" style=\"width: 509px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/asignar-usuario-base-datos.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6874\" class=\"size-full wp-image-6874\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/asignar-usuario-base-datos.jpg\" alt=\"Asignar usuario a la base de datos\" width=\"499\" height=\"240\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/asignar-usuario-base-datos.jpg 499w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/asignar-usuario-base-datos-300x144.jpg 300w\" sizes=\"auto, (max-width: 499px) 100vw, 499px\" \/><\/a><p id=\"caption-attachment-6874\" class=\"wp-caption-text\">Asignar usuario a la base de datos<\/p><\/div>\n<p>Ahora selecciona los permisos que tendr\u00e1 ese usuario en la base de datos y pulsa el bot\u00f3n \"Hacer cambios\".<\/p>\n<div id=\"attachment_6876\" style=\"width: 660px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/privilegios-usuario-1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6876\" class=\" wp-image-6876\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/privilegios-usuario-1.jpg\" alt=\"Privilegios de usuario\" width=\"650\" height=\"721\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/privilegios-usuario-1.jpg 673w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/privilegios-usuario-1-271x300.jpg 271w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/04\/privilegios-usuario-1-600x665.jpg 600w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/a><p id=\"caption-attachment-6876\" class=\"wp-caption-text\">Privilegios de usuario<\/p><\/div>\n<p>De esta forma, ya tienes creado el usuario y asignado a tu base de datos.<\/p>\n","protected":false},"excerpt":{"rendered":"Si tienes un servidor dedicado, VPS o hosting con cPanel instalado, puedes utilizar el panel para crear f\u00e1cilmente usuarios para las bases de datos que tengas en una cuenta. Para ello, accede a cPanel con tu usuario y contrase\u00f1a. En la pantalla principal haz clic en el enlace \"Bases de datos MySQL\" dentro del apartado \"Bases de datos\". Rellena los&nbsp;<a href=\"https:\/\/hosting.airetech.es\/blog\/wiki\/crear-usuarios-para-una-base-de-datos-en-cpanel\/\" class=\"read-more\">Seguir leyendo<\/a>","protected":false},"author":1,"featured_media":6873,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[457,493,12,504,512,121,13,7,8,6],"tags":[224,217,20,213,214],"class_list":["post-6870","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bases-de-datos-panel-cpanel","category-bases-de-datos-hosting","category-bases-de-datos","category-cpanel","category-cpanel-servidores-virtuales-vps","category-panel-cpanel","category-hosting","category-servidores-dedicados","category-servidores-virtuales-vps","category-wiki","tag-bases-de-datos","tag-hosting","tag-mysql","tag-servidores-dedicados","tag-servidores-virtuales-vps","cat-457-id","cat-493-id","cat-12-id","cat-504-id","cat-512-id","cat-121-id","cat-13-id","cat-7-id","cat-8-id","cat-6-id"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts\/6870","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/comments?post=6870"}],"version-history":[{"count":3,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts\/6870\/revisions"}],"predecessor-version":[{"id":8859,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts\/6870\/revisions\/8859"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/media\/6873"}],"wp:attachment":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/media?parent=6870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/categories?post=6870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/tags?post=6870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}