{"id":2845,"date":"2019-11-25T13:43:57","date_gmt":"2019-11-25T19:43:57","guid":{"rendered":"https:\/\/ugit.siua.ac.cr\/?p=2845"},"modified":"2019-11-25T14:00:16","modified_gmt":"2019-11-25T20:00:16","slug":"mariadb-crear-usuario","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=2845","title":{"rendered":"MARIADB: Crear usuario"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li>Si vamos a crear uno para una sala base de datos con este comando se hace todo<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT ALL PRIVILEGES ON bd_sis_riesgos_siua.* TO 'riesgos'@'%' IDENTIFIED BY 'RB4';\nFLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Creamos el usuario:<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE USER 'riesgos' IDENTIFIED BY 'mipassword';<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Conceder permisos para poder acceder y usar el servidor MySQL<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT USAGE ON *.* TO 'miusuario'@'%' IDENTIFIED BY 'mipassword';<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Conceder todos los privilegios sobre la base de datos al usuario<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>GRANT ALL privileges ON `mibd`.* TO 'miusuario'@localhost;<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Aplicar los cambios realizados<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>FLUSH PRIVILEGES;<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Verificar que nuestro nuevo usuario tiene los permisos correctos<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW GRANTS FOR 'riesgos'@'%';<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Si vamos a crear uno para una sala base de datos con este comando se hace todo Creamos el usuario: Conceder permisos para poder acceder y usar el servidor MySQL Conceder todos los privilegios sobre la base de datos al usuario Aplicar los cambios realizados FLUSH PRIVILEGES; Verificar que nuestro nuevo usuario tiene los permisos [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2845","post","type-post","status-publish","format-standard","hentry","category-sin-categoria"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/2845","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2845"}],"version-history":[{"count":4,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/2845\/revisions"}],"predecessor-version":[{"id":2849,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/2845\/revisions\/2849"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2845"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2845"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2845"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}