{"id":22411,"date":"2017-06-06T08:34:19","date_gmt":"2017-06-06T13:34:19","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=22411"},"modified":"2022-12-08T02:59:00","modified_gmt":"2022-12-08T08:59:00","slug":"create-a-new-mysql-user-and-grant-permissions-to-mysql-database","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/","title":{"rendered":"MySQL Create User | Create a New MySQL User and Grant Permissions"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-28379\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user.jpg\" alt=\"mysql create user\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user-300x150.jpg 300w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>MySQL is an open source relational database managed system (RDBMS) that enables users and applications to store, organize, and retrieve their data. It has an access control system that consists of permissions that the users can have within tables and databases. In this tutorial, we will explain how to create a new user in MySQL, and grant permissions to that use.\u00a0<strong>Creating a new user in MySQL<\/strong> database and granting permissions is an easy task if you follow this tutorial carefully.<\/p>\n<p><!--more--><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-662c89479a8af\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-662c89479a8af\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#Step-1-Log-in-to-MySQL\" title=\"Step 1:\u00a0 Log in to MySQL\">Step 1:\u00a0 Log in to MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#Step-2-Create-MySQL-User\" title=\"Step 2: Create MySQL User\">Step 2: Create MySQL User<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#Step-3-Granting-users-other-types-of-permissions-in-MySQL\" title=\"Step 3: Granting users other types of permissions in MySQL\">Step 3: Granting users other types of permissions in MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#Step-4-Delete-user-in-MySQL\" title=\"Step 4: Delete user in MySQL\">Step 4: Delete user in MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#Step-5-Test-user-in-MySQL\" title=\"Step 5: Test user in MySQL\">Step 5: Test user in MySQL<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Step-1-Log-in-to-MySQL\"><\/span>Step 1:\u00a0 Log in to MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To log in to our MySQL system we use the following command:<\/p>\n<pre># mysql -u root -p<\/pre>\n<p>By executing this command we tell the MySQL client to log us in with the root user and to prompt us for the user&#8217;s password.<\/p>\n<p>If you haven&#8217;t installed MySQL on your server, you can check our tutorial on <a href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-mysql-on-ubuntu-16-04\/\">how to install MySQL on Ubuntu 16.04<\/a>.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-2-Create-MySQL-User\"><\/span>Step 2: Create MySQL User<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Create a new MySQL user with the following query:<\/p>\n<pre>CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'password';<\/pre>\n<p>Pro-tip: always use a strong password for all your accounts. You can <a href=\"https:\/\/www.rosehosting.com\/blog\/generate-password-linux-command-line\/\">generate one from the command line<\/a>.<\/p>\n<p>Another interesting thing to note about this command is that the hostname of the new user we just created can be a different hostname or IP address if we want the user to log in remotely.<br \/>\nAs an example:<\/p>\n<pre>CREATE USER 'new_user'@'10.20.30.111' IDENTIFIED BY 'password';<\/pre>\n<p>Let&#8217;s say we want to provide our new user with permissions so that they can read data from all databases on our MySQL server. We do that by typing in the following command:<\/p>\n<pre>GRANT SELECT ON *.* TO 'new_user'@'localhost';<\/pre>\n<p>By executing the query above we instruct MySQL to give our new user permission to use the command SELECT to read from databases on our MySQL server, we used the SELECT keyword in order to do that. GRANT SELECT tells MySQL that the user will have nothing other than permissions to read data from a given database or databases. Granting permissions is typically done in this format:<\/p>\n<pre>GRANT &lt;permission type&gt; ON &lt;database&gt;.&lt;table&gt; TO '&lt;username&gt;'@'&lt;host&gt;';<\/pre>\n<p>We can also instruct MySQL to take away a certain permission from a user in the same format as above by only replacing the keyword GRANT with REVOKE and the keyword TO with FROM:<\/p>\n<pre>REVOKE &lt;permission type&gt; ON &lt;database&gt;.&lt;table&gt; FROM '&lt;username&gt;'@'&lt;host&gt;';<\/pre>\n<p>Note: The asterisks that we use for the database and table positions in the query above are wildcards and match any database or table depending on position.<br \/>\nIn order for our new set permissions to take effect we need to reload all the privileges:<\/p>\n<pre>FLUSH PRIVILEGES;<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-3-Granting-users-other-types-of-permissions-in-MySQL\"><\/span>Step 3: Granting users other types of permissions in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In the section above we saw how to grant read permissions to the user by using the keyword SELECT. In this section, we will explore other keywords that will allow us to set various types of permissions on the user.<\/p>\n<ul>\n<li>USAGE &#8211; gives the user permission to log in to the MySQL server(given by default when creating a new user)<\/li>\n<li>SELECT &#8211; gives the user permission to use the select command to fetch data from tables<\/li>\n<li>INSERT &#8211; gives the user permission to add new rows into tables<\/li>\n<li>UPDATE &#8211; gives the user permission to modify the existing rows in tables<\/li>\n<li>DELETE &#8211; gives the user permission to delete existing rows from tables<\/li>\n<li>CREATE &#8211; gives the user permission to create new tables or databases<\/li>\n<li>DROP &#8211; gives the user permission to remove existing tables or databases<\/li>\n<li>ALL PRIVILEGES &#8211; gives the user permission to have unrestricted access on a database or the whole system(by using an asterisk in the database position)<\/li>\n<li>GRANT OPTION &#8211; gives the user permission to grant or remove other users&#8217; permissions<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Step-4-Delete-user-in-MySQL\"><\/span>Step 4: Delete user in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Deleting users is done the same way as it is with databases or tables by using the DROP command:<\/p>\n<pre>DROP USER 'new_user'@'localhost';<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-5-Test-user-in-MySQL\"><\/span>Step 5: Test user in MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Finally, we can test our new user, type in the following command to end the currently active session:<\/p>\n<pre>exit;<\/pre>\n<p>And then we log back in by typing in this command in the shell prompt:<\/p>\n<pre>mysql -u new_user -p<\/pre>\n<p>Note: Remember to substitute new_user for your own desired username.<\/p>\n<p>That&#8217;s it, now you have created a new MySQL user and assigned permissions to it.<\/p>\n<hr \/>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-27681\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2017\/06\/Create-a-New-User-and-Grant-Permissions-in-MySQL.jpg\" alt=\"Create a New User and Grant Permissions in MySQL\" width=\"180\" height=\"122\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2017\/06\/Create-a-New-User-and-Grant-Permissions-in-MySQL.jpg 180w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2017\/06\/Create-a-New-User-and-Grant-Permissions-in-MySQL-150x102.jpg 150w\" sizes=\"(max-width: 180px) 100vw, 180px\" \/> Of course, if you are one of our <a href=\"https:\/\/www.rosehosting.com\/mysql-hosting.html\">MySQL VPS Hosting<\/a> customers, you don\u2019t have to create a new user in MySQL and grant permissions,\u00a0 simply ask our admins, sit back and relax. Our admins will create a new user in MySQL for you immediately.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PS.<\/strong><\/span> If you liked this post on How to Create a New User in MySQL and Grant Permissions to MySQL Database,\u00a0 please share it with your friends on the social networks using the buttons below or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL is an open source relational database managed system (RDBMS) that enables users and applications to store, organize, and retrieve &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"MySQL Create User | Create a New MySQL User and Grant Permissions\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#more-22411\" aria-label=\"Read more about MySQL Create User | Create a New MySQL User and Grant Permissions\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":28379,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702],"tags":[39],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Create MySQL user and Grant Permissions to MySQL Database<\/title>\n<meta name=\"description\" content=\"Creating a new user in MySQL database and granting permissions is an easy task if you follow this tutorial carefully. Follow this guide to create user in MySQL\" \/>\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.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create MySQL user and Grant Permissions to MySQL Database\" \/>\n<meta property=\"og:description\" content=\"Creating a new user in MySQL database and granting permissions is an easy task if you follow this tutorial carefully. Follow this guide to create user in MySQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-06T13:34:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-08T08:59:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"MySQL Create User | Create a New MySQL User and Grant Permissions\",\"datePublished\":\"2017-06-06T13:34:19+00:00\",\"dateModified\":\"2022-12-08T08:59:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/\"},\"wordCount\":765,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user.jpg\",\"keywords\":[\"mysql\"],\"articleSection\":[\"Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/\",\"name\":\"Create MySQL user and Grant Permissions to MySQL Database\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user.jpg\",\"datePublished\":\"2017-06-06T13:34:19+00:00\",\"dateModified\":\"2022-12-08T08:59:00+00:00\",\"description\":\"Creating a new user in MySQL database and granting permissions is an easy task if you follow this tutorial carefully. Follow this guide to create user in MySQL\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user.jpg\",\"width\":742,\"height\":372,\"caption\":\"mysql create user\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Create User | Create a New MySQL User and Grant Permissions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/RoseHosting\",\"https:\/\/x.com\/rosehosting\",\"https:\/\/www.linkedin.com\/in\/rosehosting\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\/\/www.rosehosting.com\",\"https:\/\/www.facebook.com\/rosehosting.helpdesk\"],\"url\":\"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create MySQL user and Grant Permissions to MySQL Database","description":"Creating a new user in MySQL database and granting permissions is an easy task if you follow this tutorial carefully. Follow this guide to create user in MySQL","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.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/","og_locale":"en_US","og_type":"article","og_title":"Create MySQL user and Grant Permissions to MySQL Database","og_description":"Creating a new user in MySQL database and granting permissions is an easy task if you follow this tutorial carefully. Follow this guide to create user in MySQL","og_url":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2017-06-06T13:34:19+00:00","article_modified_time":"2022-12-08T08:59:00+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"MySQL Create User | Create a New MySQL User and Grant Permissions","datePublished":"2017-06-06T13:34:19+00:00","dateModified":"2022-12-08T08:59:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/"},"wordCount":765,"commentCount":2,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user.jpg","keywords":["mysql"],"articleSection":["Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/","url":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/","name":"Create MySQL user and Grant Permissions to MySQL Database","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user.jpg","datePublished":"2017-06-06T13:34:19+00:00","dateModified":"2022-12-08T08:59:00+00:00","description":"Creating a new user in MySQL database and granting permissions is an easy task if you follow this tutorial carefully. Follow this guide to create user in MySQL","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/10\/mysql-create-user.jpg","width":742,"height":372,"caption":"mysql create user"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/create-a-new-mysql-user-and-grant-permissions-to-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL Create User | Create a New MySQL User and Grant Permissions"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"]},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/22411"}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=22411"}],"version-history":[{"count":3,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/22411\/revisions"}],"predecessor-version":[{"id":43781,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/22411\/revisions\/43781"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/28379"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=22411"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=22411"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=22411"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}