{"id":120,"date":"2013-12-30T02:31:02","date_gmt":"2013-12-30T02:31:02","guid":{"rendered":"http:\/\/www.wperu.com\/ayuda\/?p=120"},"modified":"2023-08-24T21:44:19","modified_gmt":"2023-08-25T02:44:19","slug":"como-crear-una-base-de-datos-mysql-con-cpanel","status":"publish","type":"post","link":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/","title":{"rendered":"C\u00f3mo crear una base de datos mySQL con cPanel"},"content":{"rendered":"
\nEste documento provee informaci\u00f3n sobre como crear una Base de Datos MySQL<\/b> desde tu panel de administraci\u00f3n cPanel<\/b><\/a> en los Planes de Hosting Linux<\/a> de WPERU.COM<\/b>.<\/p>\n

Para crear una base de Datos MySQL<\/b>, siga los siguientes pasos:<\/p>\n

    \n
  1. \n

    Acceda al panel de control cPanel https:\/\/www.sudominio.com\/cpanel<\/b><\/p>\n<\/li>\n

  2. \n

    En la secci\u00f3n Bases de Datos<\/b> clic en Bases de datos MySQL<\/b>.<\/p>\n

    <\/p>\n<\/li>\n

  3. \n

    Creamos la Base de Datos<\/b> En el campo de texto Nueva Base de Datos:<\/b> introducimos el nombre de nuestra base de datos (Ejm. clientes<\/b>), y damos clic en el bot\u00f3n Crear base de Datos<\/b>.
    \n <\/p>\n

    Nota:<\/b> ¡OJO! El nombre de la base de datos tendr\u00e1 el prefijo usuario_<\/b>; donde (usuario_) es en nombre de usuario con el cual tiene acceso al Cpanel
    \n<\/p>\n<\/li>\n

  4. \n

    Creamos un Usuario y una Contrase\u00f1a<\/b> Es normal que las bases de datos tengan usuarios y contrase\u00f1as, normalmente se usa un solo usuario con todos los permisos como escribir, actualizar, borrar, etc. Pero hay proyectos grandes, donde se usan varias bases de datos, y varios usuarios.<\/p>\n

    Para crearlos, debemos escribir el Nombre de usuario<\/b>, y la Contrase\u00f1a<\/b> en los siguientes campos y damos clic en el bot\u00f3nCrear usuario<\/b>.<\/p>\n

    <\/p>\n

    Nota:<\/b> ¡OJO! Al nombre de usuario que escribas se le a\u00f1adir\u00e1 autom\u00e1ticamente el prefijo usuario_<\/b><\/p>\n

    <\/p>\n<\/li>\n

  5. \n

    Vinculamos al usuario con la BD<\/b> Una ves creado el usuario es necesario vincularlo a la base de datos, incluso un solo usuario, puede ser vinculado a varias bases de datos. Elegimos el Usuario y la Base de Datos y hacemos clic en el boton A\u00f1adir
    <\/p>\n<\/li>\n

  6. Administrar Privilegios de Usuario<\/b> seleccionamos TODOS LOS PRIVILEGIOS<\/b>, y damos clic en boton Hacer Cambios<\/b>.<\/p>\n

    <\/p>\n<\/li>\n<\/ol>\n

    Conclusi\u00f3n<\/span> Las bases de datos son sencillas de crear, hay distintas formas de hacerlo, pero es cuesti\u00f3n de comodidad y h\u00e1bito dir\u00eda yo, por ejemplo, se pueden crear desde el lenguaje SQL, tambi\u00e9n desde el popular phpMyAdmin<\/a>, y claro mediante el Cpanel. Existen varias formas, pero \u00e9stas aqu\u00ed mencionadas son las m\u00e1s usadas.<\/div>\n<\/div>\n
    <\/div>\n

    <\/g><\/svg><\/i> \"Loading\"<\/p>\n

    <\/div>\n","protected":false},"excerpt":{"rendered":"

    Este documento provee informaci\u00f3n sobre como crear una Base de Datos MySQL desde tu panel de administraci\u00f3n cPanel en los Planes de Hosting Linux de WPERU.COM. Para crear una base de Datos MySQL, siga los siguientes pasos: Acceda al panel de control cPanel https:\/\/www.sudominio.com\/cpanel En la secci\u00f3n Bases de Datos clic en Bases de datos […]<\/p>\n

    <\/div>\n

    <\/g><\/svg><\/i> \"Loading\"<\/p>\n

    <\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[7,12],"class_list":["post-120","post","type-post","status-publish","format-standard","hentry","category-linux","tag-cpanel","tag-mysql"],"yoast_head":"\nC\u00f3mo crear una base de datos mySQL con cPanel - Centro de Ayuda de WEBPERU<\/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.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00f3mo crear una base de datos mySQL con cPanel - Centro de Ayuda de WEBPERU\" \/>\n<meta property=\"og:description\" content=\"Este documento provee informaci\u00f3n sobre como crear una Base de Datos MySQL desde tu panel de administraci\u00f3n cPanel en los Planes de Hosting Linux de WPERU.COM. Para crear una base de Datos MySQL, siga los siguientes pasos: Acceda al panel de control cPanel https:\/\/www.sudominio.com\/cpanel En la secci\u00f3n Bases de Datos clic en Bases de datos […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Centro de Ayuda de WEBPERU\" \/>\n<meta property=\"article:published_time\" content=\"2013-12-30T02:31:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-25T02:44:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wperu.com\/ayuda\/images\/hosting\/linux\/db\/base-de-datos-mysql.jpg\" \/>\n<meta name=\"author\" content=\"Walter Mendoza\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Walter Mendoza\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/\"},\"author\":{\"name\":\"Walter Mendoza\",\"@id\":\"https:\/\/www.wperu.com\/ayuda\/#\/schema\/person\/545b7f0685970c2ecfac0dc21df1b69e\"},\"headline\":\"C\u00f3mo crear una base de datos mySQL con cPanel\",\"datePublished\":\"2013-12-30T02:31:02+00:00\",\"dateModified\":\"2023-08-25T02:44:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/\"},\"wordCount\":348,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.wperu.com\/ayuda\/#\/schema\/person\/545b7f0685970c2ecfac0dc21df1b69e\"},\"image\":{\"@id\":\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.wperu.com\/ayuda\/images\/hosting\/linux\/db\/base-de-datos-mysql.jpg\",\"keywords\":[\"cPanel\",\"mySQL\"],\"articleSection\":[\"Hosting Linux\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/\",\"url\":\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/\",\"name\":\"C\u00f3mo crear una base de datos mySQL con cPanel - Centro de Ayuda de WEBPERU\",\"isPartOf\":{\"@id\":\"https:\/\/www.wperu.com\/ayuda\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.wperu.com\/ayuda\/images\/hosting\/linux\/db\/base-de-datos-mysql.jpg\",\"datePublished\":\"2013-12-30T02:31:02+00:00\",\"dateModified\":\"2023-08-25T02:44:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#primaryimage\",\"url\":\"https:\/\/www.wperu.com\/ayuda\/images\/hosting\/linux\/db\/base-de-datos-mysql.jpg\",\"contentUrl\":\"https:\/\/www.wperu.com\/ayuda\/images\/hosting\/linux\/db\/base-de-datos-mysql.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.wperu.com\/ayuda\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00f3mo crear una base de datos mySQL con cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wperu.com\/ayuda\/#website\",\"url\":\"https:\/\/www.wperu.com\/ayuda\/\",\"name\":\"Centro de Ayuda de WebPeru\",\"description\":\"Manuales y Tutoriales WEBPERU\",\"publisher\":{\"@id\":\"https:\/\/www.wperu.com\/ayuda\/#\/schema\/person\/545b7f0685970c2ecfac0dc21df1b69e\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wperu.com\/ayuda\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.wperu.com\/ayuda\/#\/schema\/person\/545b7f0685970c2ecfac0dc21df1b69e\",\"name\":\"Walter Mendoza\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.wperu.com\/ayuda\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ca113ffb40ca0f36c9ef9732f863ec0c81b8c1456f33bb0334cb2ad72c4db45d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ca113ffb40ca0f36c9ef9732f863ec0c81b8c1456f33bb0334cb2ad72c4db45d?s=96&d=mm&r=g\",\"caption\":\"Walter Mendoza\"},\"logo\":{\"@id\":\"https:\/\/www.wperu.com\/ayuda\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.wperu.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00f3mo crear una base de datos mySQL con cPanel - Centro de Ayuda de WEBPERU","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.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/","og_locale":"es_ES","og_type":"article","og_title":"C\u00f3mo crear una base de datos mySQL con cPanel - Centro de Ayuda de WEBPERU","og_description":"Este documento provee informaci\u00f3n sobre como crear una Base de Datos MySQL desde tu panel de administraci\u00f3n cPanel en los Planes de Hosting Linux de WPERU.COM. Para crear una base de Datos MySQL, siga los siguientes pasos: Acceda al panel de control cPanel https:\/\/www.sudominio.com\/cpanel En la secci\u00f3n Bases de Datos clic en Bases de datos […]","og_url":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/","og_site_name":"Centro de Ayuda de WEBPERU","article_published_time":"2013-12-30T02:31:02+00:00","article_modified_time":"2023-08-25T02:44:19+00:00","og_image":[{"url":"https:\/\/www.wperu.com\/ayuda\/images\/hosting\/linux\/db\/base-de-datos-mysql.jpg","type":"","width":"","height":""}],"author":"Walter Mendoza","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Walter Mendoza","Tiempo de lectura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#article","isPartOf":{"@id":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/"},"author":{"name":"Walter Mendoza","@id":"https:\/\/www.wperu.com\/ayuda\/#\/schema\/person\/545b7f0685970c2ecfac0dc21df1b69e"},"headline":"C\u00f3mo crear una base de datos mySQL con cPanel","datePublished":"2013-12-30T02:31:02+00:00","dateModified":"2023-08-25T02:44:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/"},"wordCount":348,"commentCount":0,"publisher":{"@id":"https:\/\/www.wperu.com\/ayuda\/#\/schema\/person\/545b7f0685970c2ecfac0dc21df1b69e"},"image":{"@id":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wperu.com\/ayuda\/images\/hosting\/linux\/db\/base-de-datos-mysql.jpg","keywords":["cPanel","mySQL"],"articleSection":["Hosting Linux"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/","url":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/","name":"C\u00f3mo crear una base de datos mySQL con cPanel - Centro de Ayuda de WEBPERU","isPartOf":{"@id":"https:\/\/www.wperu.com\/ayuda\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.wperu.com\/ayuda\/images\/hosting\/linux\/db\/base-de-datos-mysql.jpg","datePublished":"2013-12-30T02:31:02+00:00","dateModified":"2023-08-25T02:44:19+00:00","breadcrumb":{"@id":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#primaryimage","url":"https:\/\/www.wperu.com\/ayuda\/images\/hosting\/linux\/db\/base-de-datos-mysql.jpg","contentUrl":"https:\/\/www.wperu.com\/ayuda\/images\/hosting\/linux\/db\/base-de-datos-mysql.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.wperu.com\/ayuda\/como-crear-una-base-de-datos-mysql-con-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.wperu.com\/ayuda\/"},{"@type":"ListItem","position":2,"name":"C\u00f3mo crear una base de datos mySQL con cPanel"}]},{"@type":"WebSite","@id":"https:\/\/www.wperu.com\/ayuda\/#website","url":"https:\/\/www.wperu.com\/ayuda\/","name":"Centro de Ayuda de WebPeru","description":"Manuales y Tutoriales WEBPERU","publisher":{"@id":"https:\/\/www.wperu.com\/ayuda\/#\/schema\/person\/545b7f0685970c2ecfac0dc21df1b69e"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wperu.com\/ayuda\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":["Person","Organization"],"@id":"https:\/\/www.wperu.com\/ayuda\/#\/schema\/person\/545b7f0685970c2ecfac0dc21df1b69e","name":"Walter Mendoza","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.wperu.com\/ayuda\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ca113ffb40ca0f36c9ef9732f863ec0c81b8c1456f33bb0334cb2ad72c4db45d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ca113ffb40ca0f36c9ef9732f863ec0c81b8c1456f33bb0334cb2ad72c4db45d?s=96&d=mm&r=g","caption":"Walter Mendoza"},"logo":{"@id":"https:\/\/www.wperu.com\/ayuda\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.wperu.com"]}]}},"_links":{"self":[{"href":"https:\/\/www.wperu.com\/ayuda\/wp-json\/wp\/v2\/posts\/120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wperu.com\/ayuda\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wperu.com\/ayuda\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wperu.com\/ayuda\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wperu.com\/ayuda\/wp-json\/wp\/v2\/comments?post=120"}],"version-history":[{"count":8,"href":"https:\/\/www.wperu.com\/ayuda\/wp-json\/wp\/v2\/posts\/120\/revisions"}],"predecessor-version":[{"id":585,"href":"https:\/\/www.wperu.com\/ayuda\/wp-json\/wp\/v2\/posts\/120\/revisions\/585"}],"wp:attachment":[{"href":"https:\/\/www.wperu.com\/ayuda\/wp-json\/wp\/v2\/media?parent=120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wperu.com\/ayuda\/wp-json\/wp\/v2\/categories?post=120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wperu.com\/ayuda\/wp-json\/wp\/v2\/tags?post=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}