{"id":2071,"date":"2024-03-15T10:56:27","date_gmt":"2024-03-15T09:56:27","guid":{"rendered":"https:\/\/alessandromasciadri.com\/?p=2071"},"modified":"2024-03-15T10:59:25","modified_gmt":"2024-03-15T09:59:25","slug":"come-creare-un-utente-sql-per-wordpress-ed-assegnare-i-giusti-permessi","status":"publish","type":"post","link":"https:\/\/alessandromasciadri.com\/come-creare-un-utente-sql-per-wordpress-ed-assegnare-i-giusti-permessi\/","title":{"rendered":"Come creare un utente SQL per WordPress ed assegnare i giusti permessi"},"content":{"rendered":"\t\t<div data-akihiro-type=\"ama-post\" data-akihiro-id=\"2071\" class=\"akihiro akihiro-2071\" data-akihiro-post-type=\"post\">\n\t\t\t\t<div class=\"akihiro-element akihiro-element-d92f882 e-flex e-con-boxed e-con e-parent\" data-id=\"d92f882\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"akihiro-element akihiro-element-6772fab akihiro-widget akihiro-widget-text-editor\" data-id=\"6772fab\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Quando si ha a che fare con WordPress, una domanda che ci si pone spesso in fase di installazione \u00e8: quali permessi devo concedere all&#8217;utente SQL usato da WordPress?<\/p><p>In questa guida vediamo quindi come creare un utente SQL per WordPress e come assegnargli i giusti permessi.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-8b0bda6 akihiro-widget akihiro-widget-heading\" data-id=\"8b0bda6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Creazione utente SQL per WordPress<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-b40e72c akihiro-widget akihiro-widget-text-editor\" data-id=\"b40e72c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>La prima cosa da fare \u00e8 creare l&#8217;utente SQL che comunicheremo poi a WordPress durante la sua fase di installazione. Colleghiamoci quindi al nostro DBMS con il seguente comando ed inserire la password quando richiesta:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-4038115 akihiro-widget akihiro-widget-code-highlight\" data-id=\"4038115\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash \">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp>sudo mysql -p<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-a7217ce akihiro-widget akihiro-widget-text-editor\" data-id=\"a7217ce\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Lanciamo quindi il seguente comando per creare un nuovo utente che destiniamo a WordPress:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-af3d86a akihiro-widget akihiro-widget-code-highlight\" data-id=\"af3d86a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql \">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>create user 'my_wp_user'@'localhost' IDENTIFIED BY '29cf64afffa756aac21185f9955aa7c5'<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-41347fa akihiro-widget akihiro-widget-heading\" data-id=\"41347fa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t<h3 class=\"akihiro-heading-title akihiro-size-default\">Assegnazione dei permessi<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-f4e34fe akihiro-widget akihiro-widget-text-editor\" data-id=\"f4e34fe\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Una volta creato l&#8217;utente, non ci resta che assegnargli i permessi di accesso al DB di WordPress. Lanciamo quindi il seguente comando:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"akihiro-element akihiro-element-c0aa058 akihiro-widget akihiro-widget-code-highlight\" data-id=\"c0aa058\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"akihiro-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-okaidia copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql \">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>grant all privileges on my_wp_db.* to 'my_wp_user'@'localhost'<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Quando si ha a che fare con WordPress, una domanda che ci si pone spesso in fase di installazione \u00e8: quali permessi devo concedere all&#8217;utente SQL usato da WordPress? In questa guida vediamo quindi come creare un utente SQL per WordPress e come assegnargli i giusti permessi. Creazione utente SQL per WordPress La prima cosa [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[10],"class_list":["post-2071","post","type-post","status-publish","format-standard","hentry","category-sistemistica","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/2071","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/comments?post=2071"}],"version-history":[{"count":4,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/2071\/revisions"}],"predecessor-version":[{"id":2075,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/posts\/2071\/revisions\/2075"}],"wp:attachment":[{"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/media?parent=2071"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/categories?post=2071"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alessandromasciadri.com\/ama-json\/wp\/v2\/tags?post=2071"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}