{"id":1445,"date":"2025-09-14T10:29:11","date_gmt":"2025-09-14T10:29:11","guid":{"rendered":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/?p=1445"},"modified":"2025-09-17T09:44:42","modified_gmt":"2025-09-17T09:44:42","slug":"how-to-add-a-new-user-to-the-plesk-panel-mysql-database","status":"publish","type":"post","link":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/how-to-add-a-new-user-to-the-plesk-panel-mysql-database\/","title":{"rendered":"How to add a new user to the Plesk Panel MySQL database?"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">A user may not have been assigned when the database was created, or you may want to add multiple users to a database and give them different permissions. To add a user to an existing database in the Plesk panel, follow the steps below:<\/span><\/p>\n<ul>\n<li>Log in to the Plesk Panel. If you need support to access the Plesk panel, <a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/how-to-log-in-to-plesk-panel\/\" target=\"_blank\" rel=\"noopener\">click here to check our article.<\/a><\/li>\n<li>Once you access the Plesk panel, click the &#8220;Databases&#8221; button in the menu on the left.<br \/>\n<a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-Databases.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1432\" title=\"Plesk Databases\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-Databases.png\" alt=\"Plesk Databases\" width=\"1881\" height=\"833\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-Databases.png 1881w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-Databases-300x133.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-Databases-1024x453.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-Databases-768x340.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-Databases-1536x680.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-Databases-60x27.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-Databases-150x66.png 150w\" sizes=\"(max-width: 1881px) 100vw, 1881px\" \/><\/a><\/li>\n<li>Go to the &#8220;User Management&#8221; tab.<br \/>\n<a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-User-Management.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1446 size-full\" title=\"Plesk User Management\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-User-Management-e1758102276270.png\" alt=\"Plesk User Management\" width=\"1917\" height=\"827\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-User-Management-e1758102276270.png 1917w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-User-Management-e1758102276270-300x129.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-User-Management-e1758102276270-1024x442.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-User-Management-e1758102276270-768x331.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-User-Management-e1758102276270-1536x663.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-User-Management-e1758102276270-60x26.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Plesk-User-Management-e1758102276270-150x65.png 150w\" sizes=\"(max-width: 1917px) 100vw, 1917px\" \/><\/a><\/li>\n<li>Click the &#8220;+ Add Database User&#8221; button.<br \/>\n<a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Add-Database-User.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1447\" title=\"Add Database User\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Add-Database-User.png\" alt=\"Add Database User\" width=\"1899\" height=\"843\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Add-Database-User.png 1899w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Add-Database-User-300x133.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Add-Database-User-1024x455.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Add-Database-User-768x341.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Add-Database-User-1536x682.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Add-Database-User-60x27.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Add-Database-User-150x67.png 150w\" sizes=\"(max-width: 1899px) 100vw, 1899px\" \/><\/a><\/li>\n<li>The window that opens will request some information. You can follow the steps below:\n<ul>\n<li><strong>Database server<\/strong>: Select MySQL from the dropdown menu.<\/li>\n<li><strong>Database user name<\/strong>: Define a username to access the database.<\/li>\n<li><strong>Password<\/strong>: Define a password to access the database. If you haven&#8217;t created a new password, you can click the &#8220;Generate&#8221; button to automatically create one.<\/li>\n<li><strong>Confirm password<\/strong>: In this field, re-enter the password you specified in the password section.<\/li>\n<li><strong>Database<\/strong>: From the dropdown list, select the database to which you want to assign the database user.<\/li>\n<li>Finally, click the &#8220;<strong>OK<\/strong>&#8221; button.<br \/>\n<a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Plesk-.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1448\" title=\"Database user Plesk\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Plesk-.png\" alt=\"Database user Plesk\" width=\"1905\" height=\"834\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Plesk-.png 1905w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Plesk--300x131.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Plesk--1024x448.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Plesk--768x336.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Plesk--1536x672.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Plesk--60x26.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Plesk--150x66.png 150w\" sizes=\"(max-width: 1905px) 100vw, 1905px\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<li>If you have successfully completed the steps above, the user you created will be associated with your database. To check and modify the user&#8217;s permissions, go back to the &#8220;Database &gt; User Management&#8221; page and click on the user you created.<br \/>\n<a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/User-Management-Edit.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1455\" title=\"User Management Edit\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/User-Management-Edit.png\" alt=\"User Management Edit\" width=\"1910\" height=\"832\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/User-Management-Edit.png 1910w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/User-Management-Edit-300x131.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/User-Management-Edit-1024x446.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/User-Management-Edit-768x335.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/User-Management-Edit-1536x669.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/User-Management-Edit-60x26.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/User-Management-Edit-150x65.png 150w\" sizes=\"(max-width: 1910px) 100vw, 1910px\" \/><\/a><\/li>\n<li>On the page that opens, you can select permissions from the &#8220;Role&#8221; section or click &#8220;Show privileges&#8221; to grant or revoke the desired permissions.<br \/>\n<a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Role.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1456\" title=\"Database user Role\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Role.png\" alt=\"Database user Role\" width=\"1906\" height=\"843\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Role.png 1906w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Role-300x133.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Role-1024x453.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Role-768x340.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Role-1536x679.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Role-60x27.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-user-Role-150x66.png 150w\" sizes=\"(max-width: 1906px) 100vw, 1906px\" \/><\/a><br \/>\n<a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-Show-Privileges.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1457\" title=\"Database Show Privileges\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-Show-Privileges.png\" alt=\"Database Show Privileges\" width=\"1916\" height=\"828\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-Show-Privileges.png 1916w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-Show-Privileges-300x130.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-Show-Privileges-1024x443.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-Show-Privileges-768x332.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-Show-Privileges-1536x664.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-Show-Privileges-60x26.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-Show-Privileges-150x65.png 150w\" sizes=\"(max-width: 1916px) 100vw, 1916px\" \/><\/a><br \/>\n<a href=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-User-Edit.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1458\" title=\"Database User Edit\" src=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-User-Edit.png\" alt=\"Database User Edit\" width=\"1919\" height=\"838\" srcset=\"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-User-Edit.png 1919w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-User-Edit-300x131.png 300w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-User-Edit-1024x447.png 1024w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-User-Edit-768x335.png 768w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-User-Edit-1536x671.png 1536w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-User-Edit-60x26.png 60w, https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-content\/uploads\/2025\/09\/Database-User-Edit-150x66.png 150w\" sizes=\"(max-width: 1919px) 100vw, 1919px\" \/><\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>A user may not have been assigned when the database was created, or you may want to add multiple users to a database and give them different permissions. To add a user to an existing database in the Plesk panel, follow the steps below: Log in to the Plesk Panel. If you need support to [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21,9],"tags":[],"_links":{"self":[{"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/posts\/1445"}],"collection":[{"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/comments?post=1445"}],"version-history":[{"count":5,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/posts\/1445\/revisions"}],"predecessor-version":[{"id":1543,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/posts\/1445\/revisions\/1543"}],"wp:attachment":[{"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/media?parent=1445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/categories?post=1445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fastpanda.co.uk\/knowledge-hub\/wp-json\/wp\/v2\/tags?post=1445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}