{"id":6440,"date":"2021-05-27T16:43:38","date_gmt":"2021-05-27T11:13:38","guid":{"rendered":"https:\/\/www.skynats.com\/?p=6440"},"modified":"2025-05-28T12:16:45","modified_gmt":"2025-05-28T06:46:45","slug":"how-to-create-user-in-mysql-and-grant-permission","status":"publish","type":"post","link":"https:\/\/www.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/","title":{"rendered":"How to Create User in MySQL and Grant Permission"},"content":{"rendered":"\n

MySQL is an open-source database management system for storing, organising, and retrieving data. It includes a number of options for granting individual users access within tables and databases.<\/p>\n\n\n\n

On our <\/span>server management plan<\/span><\/a>, our experts will cover MySQL setup, optimisation and database migrations. <\/p>\n\n\n\n

Create User in MySQL<\/strong><\/p>\n\n\n\n

Login to MySQL server with below command<\/p>\n\n\n\n

mysql -u root -p\nEnter Password:<\/code><\/pre>\n\n\n\n
Now, create the user<\/p>\n\n\n\n
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';<\/code><\/pre>\n\n\n\n
At this time, newuser does not have any access to the databases. In fact, newuser will be unable to access the MySQL shell even if they try to login (using the password, given). As a result, the first step is to give the user access to the information they’ll need.<\/p>\n\n\n\n
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';<\/code><\/pre>\n\n\n\n
The asterisks in this command denote the database and table that they can access, respectively. The user can read, edit, execute, and conduct all tasks across all databases and tables using this command.<\/p>\n\n\n\n
Always remember to reload all privileges after you’ve confirmed the permissions you wish to set up for your new users.<\/p>\n\n\n\n
FLUSH PRIVILEGES;<\/code><\/pre>\n\n\n\n
Run the following commands to check a user’s current permissions<\/p>\n\n\n\n
SHOW GRANTS FOR 'username'@'localhost';<\/code><\/pre>\n\n\n\n
If you need any assistance in setting up MySQL user and Database on your server, our technical experts<\/span><\/a> are available<\/span> anytime to help you.<\/p>\n","protected":false},"excerpt":{"rendered":"
MySQL is an open-source database management system for storing, organising, and retrieving data. It includes a number of options for granting individual users access within tables and databases. On our server management plan, our experts will cover MySQL setup, optimisation and database migrations. Create User in MySQL Login to MySQL server with below command Now, […]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,257,68],"tags":[46,48,371],"class_list":["post-6440","post","type-post","status-publish","format-standard","hentry","category-blog","category-mysql","category-server-management","tag-mysql-server","tag-mysql-tuning-tips","tag-mysql-user-setup"],"yoast_head":"\nHow to Create User in MySQL and Grant Permission<\/title>\n<meta name=\"description\" content=\"Learn how to create a MySQL user and grant permissions step-by-step. Boost your DB security now \u2013 follow our quick guide!\" \/>\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.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create User in MySQL and Grant Permission\" \/>\n<meta property=\"og:description\" content=\"Learn how to create a MySQL user and grant permissions step-by-step. Boost your DB security now \u2013 follow our quick guide!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/\" \/>\n<meta property=\"og:site_name\" content=\"Server Management Services | Cloud Management | Skynats\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/skynats\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-27T11:13:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-28T06:46:45+00:00\" \/>\n<meta name=\"author\" content=\"Tony\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@skynatstech\" \/>\n<meta name=\"twitter:site\" content=\"@skynatstech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tony\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/how-to-create-user-in-mysql-and-grant-permission\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/how-to-create-user-in-mysql-and-grant-permission\\\/\"},\"author\":{\"name\":\"Tony\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/person\\\/1398d4641035daa52ed8b827e0aafdeb\"},\"headline\":\"How to Create User in MySQL and Grant Permission\",\"datePublished\":\"2021-05-27T11:13:38+00:00\",\"dateModified\":\"2025-05-28T06:46:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/how-to-create-user-in-mysql-and-grant-permission\\\/\"},\"wordCount\":207,\"publisher\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\"},\"keywords\":[\"mysql server\",\"mysql tuning tips\",\"mysql user setup\"],\"articleSection\":[\"Blog\",\"MySQL\",\"server management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/how-to-create-user-in-mysql-and-grant-permission\\\/\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/how-to-create-user-in-mysql-and-grant-permission\\\/\",\"name\":\"How to Create User in MySQL and Grant Permission\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#website\"},\"datePublished\":\"2021-05-27T11:13:38+00:00\",\"dateModified\":\"2025-05-28T06:46:45+00:00\",\"description\":\"Learn how to create a MySQL user and grant permissions step-by-step. Boost your DB security now \u2013 follow our quick guide!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/how-to-create-user-in-mysql-and-grant-permission\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.skynats.com\\\/blog\\\/how-to-create-user-in-mysql-and-grant-permission\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/how-to-create-user-in-mysql-and-grant-permission\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Create User in MySQL and Grant Permission\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\",\"name\":\"Server Management Services | Cloud Management | Skynats\",\"description\":\"Server Management and Cloud Management\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\",\"name\":\"Skynats Technologies\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Sknats-Logo-New-whole.png\",\"contentUrl\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Sknats-Logo-New-whole.png\",\"width\":989,\"height\":367,\"caption\":\"Skynats Technologies\"},\"image\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/skynats\",\"https:\\\/\\\/x.com\\\/skynatstech\",\"https:\\\/\\\/www.instagram.com\\\/skynatstech\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/skynats-technologies\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCvTAjrFJ4_E2MJKwlDHomlg\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/person\\\/1398d4641035daa52ed8b827e0aafdeb\",\"name\":\"Tony\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f90e801961478d690f50507d9e19eeecebabab8ab7dfdab7d2d2431114c6acd9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f90e801961478d690f50507d9e19eeecebabab8ab7dfdab7d2d2431114c6acd9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f90e801961478d690f50507d9e19eeecebabab8ab7dfdab7d2d2431114c6acd9?s=96&d=mm&r=g\",\"caption\":\"Tony\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Create User in MySQL and Grant Permission","description":"Learn how to create a MySQL user and grant permissions step-by-step. Boost your DB security now \u2013 follow our quick guide!","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.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/","og_locale":"en_US","og_type":"article","og_title":"How to Create User in MySQL and Grant Permission","og_description":"Learn how to create a MySQL user and grant permissions step-by-step. Boost your DB security now \u2013 follow our quick guide!","og_url":"https:\/\/www.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/","og_site_name":"Server Management Services | Cloud Management | Skynats","article_publisher":"https:\/\/www.facebook.com\/skynats","article_published_time":"2021-05-27T11:13:38+00:00","article_modified_time":"2025-05-28T06:46:45+00:00","author":"Tony","twitter_card":"summary_large_image","twitter_creator":"@skynatstech","twitter_site":"@skynatstech","twitter_misc":{"Written by":"Tony","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/#article","isPartOf":{"@id":"https:\/\/www.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/"},"author":{"name":"Tony","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/person\/1398d4641035daa52ed8b827e0aafdeb"},"headline":"How to Create User in MySQL and Grant Permission","datePublished":"2021-05-27T11:13:38+00:00","dateModified":"2025-05-28T06:46:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/"},"wordCount":207,"publisher":{"@id":"https:\/\/www.skynats.com\/blog\/#organization"},"keywords":["mysql server","mysql tuning tips","mysql user setup"],"articleSection":["Blog","MySQL","server management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/","url":"https:\/\/www.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/","name":"How to Create User in MySQL and Grant Permission","isPartOf":{"@id":"https:\/\/www.skynats.com\/blog\/#website"},"datePublished":"2021-05-27T11:13:38+00:00","dateModified":"2025-05-28T06:46:45+00:00","description":"Learn how to create a MySQL user and grant permissions step-by-step. Boost your DB security now \u2013 follow our quick guide!","breadcrumb":{"@id":"https:\/\/www.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.skynats.com\/blog\/how-to-create-user-in-mysql-and-grant-permission\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.skynats.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Create User in MySQL and Grant Permission"}]},{"@type":"WebSite","@id":"https:\/\/www.skynats.com\/blog\/#website","url":"https:\/\/www.skynats.com\/blog\/","name":"Server Management Services | Cloud Management | Skynats","description":"Server Management and Cloud Management","publisher":{"@id":"https:\/\/www.skynats.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.skynats.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.skynats.com\/blog\/#organization","name":"Skynats Technologies","url":"https:\/\/www.skynats.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/08\/Sknats-Logo-New-whole.png","contentUrl":"https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/08\/Sknats-Logo-New-whole.png","width":989,"height":367,"caption":"Skynats Technologies"},"image":{"@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/skynats","https:\/\/x.com\/skynatstech","https:\/\/www.instagram.com\/skynatstech\/","https:\/\/www.linkedin.com\/company\/skynats-technologies","https:\/\/www.youtube.com\/channel\/UCvTAjrFJ4_E2MJKwlDHomlg"]},{"@type":"Person","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/person\/1398d4641035daa52ed8b827e0aafdeb","name":"Tony","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f90e801961478d690f50507d9e19eeecebabab8ab7dfdab7d2d2431114c6acd9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f90e801961478d690f50507d9e19eeecebabab8ab7dfdab7d2d2431114c6acd9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f90e801961478d690f50507d9e19eeecebabab8ab7dfdab7d2d2431114c6acd9?s=96&d=mm&r=g","caption":"Tony"}}]}},"_links":{"self":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/6440","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/comments?post=6440"}],"version-history":[{"count":1,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/6440\/revisions"}],"predecessor-version":[{"id":14970,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/6440\/revisions\/14970"}],"wp:attachment":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/media?parent=6440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/categories?post=6440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/tags?post=6440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}