{"id":426,"date":"2019-05-02T17:54:24","date_gmt":"2019-05-02T12:24:24","guid":{"rendered":"http:\/\/www.itsupportwale.com\/blog\/?p=426"},"modified":"2026-02-17T15:58:03","modified_gmt":"2026-02-17T10:28:03","slug":"creating-a-backup-user-with-read-only-permission-for-mysql-db","status":"publish","type":"post","link":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/","title":{"rendered":"Creating a backup user with read-only permission for MySQL DB"},"content":{"rendered":"\n<p>Why do we need to create a user with read-only permission? Most people use &#8220;<strong>mysqldump<\/strong>&#8221; for taking the backup of MySQL. And when we automate the backup process the password of the user is saved in a file (Ex. script or mysql.inf ). If our backup user is a superuser and something went wrong in our backup script then we may face some data loss or corruption issue.<\/p>\n\n\n\n<p>For taking a backup of mysql we must use a separate user who has read-only permissions. So that we can always back up our database with safety.<\/p>\n\n\n\n<p>We will discuss two ways of creating the backup user with read-only permission. First with the use of MySQL command in the terminal and the second is from PhpMyAdmin GUI.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Create a user with Mysql Command<\/h2>\n\n\n\n<p>We all love to work in the terminal. It is always fun to work with commands. For creating a backup-only user use the below command.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>> GRANT SELECT, LOCK TABLES ON *.* TO 'MYBACKUPUSER'@'%' IDENTIFIED BY 'MYPASSWORD';<\/code><\/pre>\n\n\n\n<p>In the above command, we are giving Select and Lock Tables permission on all of the present databases to our backup user.<\/p>\n\n\n\n<p>You can limit it to the specific database. For this, you have to first create the user and then give the permissions to that user like this.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>> CREATE USER 'MYBACKUPUSER'@'%' IDENTIFIED BY 'MYPASSWORD';\n> GRANT SELECT, LOCK TABLES ON 'MYDATABASE'.* TO 'backup'@'%';<\/code><\/pre>\n\n\n\n<p>That&#8217;s it. Now you can use this user for taking the backup of your Mysql Databases.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Create a user with PhpMyAdmin GUI<\/h2>\n\n\n\n<p>If you are not familiar with the command line interface then you can also create this user using PhpMyAdmin GUI interface. PhpMyAdmin is the most used GUI interface for Administrating Mysql Databases.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>You can download PhpMyAdmin from this Link:  <a href=\"https:\/\/www.phpmyadmin.net\/downloads\/\">DOWNLOAD<\/a><\/p><\/blockquote>\n\n\n\n<p>So let&#8217;s Begin. First, Login to the PhpMyAdmin interface and go to the <strong>User Account<\/strong> tab and click on &#8220;<strong>Add user account<\/strong>&#8220;. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"789\" height=\"552\" src=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-add-user-account.jpg\" alt=\"phpmyadmin-add-user-account\" class=\"wp-image-433\" srcset=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-add-user-account.jpg 789w, https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-add-user-account-300x210.jpg 300w, https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-add-user-account-768x537.jpg 768w\" sizes=\"auto, (max-width: 789px) 100vw, 789px\" \/><\/figure>\n\n\n\n<p>After that fill the required information. you can generate a secure random password for your user here but do not remember to copy it and save in some safe place.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"473\" src=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-fill-user-details.jpg\" alt=\"phpmyadmin-fill-user-details\" class=\"wp-image-434\" srcset=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-fill-user-details.jpg 698w, https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-fill-user-details-300x203.jpg 300w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/figure>\n\n\n\n<p>No Click on &#8220;<strong>GO<\/strong>&#8220;.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"517\" height=\"274\" src=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-create-user.jpg\" alt=\"phpmyadmin-create-user\" class=\"wp-image-435\" srcset=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-create-user.jpg 517w, https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-create-user-300x159.jpg 300w\" sizes=\"auto, (max-width: 517px) 100vw, 517px\" \/><\/figure>\n\n\n\n<p>Now in the <strong>User Account<\/strong> tab, you can see the newly created user. With the name which you have given in the last step.<\/p>\n\n\n\n<p>Now click on &#8220;<strong>Edit privileges<\/strong>&#8221; and go to the <strong>DATABASE<\/strong> tab.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"760\" height=\"445\" src=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-edit-privileges.jpg\" alt=\"phpmyadmin-edit-privileges\" class=\"wp-image-436\" srcset=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-edit-privileges.jpg 760w, https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-edit-privileges-300x176.jpg 300w\" sizes=\"auto, (max-width: 760px) 100vw, 760px\" \/><\/figure>\n\n\n\n<p>Here you have to select those databases whose backups are taken by this user. You can select multiple databases at once with Pressing CTRL key and clicking on the database. After selecting the database click on the <strong>GO<\/strong> button.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"426\" src=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-select-db-and-go-1024x426.jpg\" alt=\"phpmyadmin-select-db-and-go\" class=\"wp-image-437\" srcset=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-select-db-and-go-1024x426.jpg 1024w, https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-select-db-and-go-300x125.jpg 300w, https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-select-db-and-go-768x320.jpg 768w, https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-select-db-and-go.jpg 1110w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Now tick on <strong>SELECT<\/strong> and <strong>LOCK TABLES<\/strong> Options and click on <strong>GO<\/strong> button.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"522\" src=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-select-permission-ang-go-1024x522.jpg\" alt=\"phpmyadmin-select-permission-ang-go\" class=\"wp-image-438\" srcset=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-select-permission-ang-go-1024x522.jpg 1024w, https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-select-permission-ang-go-300x153.jpg 300w, https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-select-permission-ang-go-768x391.jpg 768w, https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-select-permission-ang-go.jpg 1081w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>At the end click on &#8220;<strong>reload the privileges<\/strong>&#8221; link in the <strong>User Accounts<\/strong> tab.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"586\" height=\"199\" src=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-reload-privileges.jpg\" alt=\"phpmyadmin-reload-privileges\" class=\"wp-image-439\" srcset=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-reload-privileges.jpg 586w, https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/phpmyadmin-reload-privileges-300x102.jpg 300w\" sizes=\"auto, (max-width: 586px) 100vw, 586px\" \/><\/figure>\n\n\n\n<p>That&#8217;s it, Your MySQL backup user with read-only permission is ready to take the backup of your MySQL databases.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Summary:<\/h3>\n\n\n\n<p>Mysql is the most used open-source relational database management system. Every single Server Administrator should know how to taking care of the databases in Mysql. Using this method you can back up your databases without any security issues.<\/p>\n\n\n\n<p>You can share your views and suggestions on this article in the comment section. Happy Learning ..!!<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Also Learn: &#8220;<a href=\"https:\/\/itsupportwale.com\/blog\/backup-all-mysql-databases-with-a-mysql-backup-script\/\">Backup all MySQL Databases with a MySQL Backup Script<\/a>&#8220;<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Why do we need to create a user with read-only permission? Most people use &#8220;mysqldump&#8221; for taking the backup of MySQL. And when we automate the backup process the password of the user is saved in a file (Ex. script or mysql.inf ). If our backup user is a superuser and something went wrong in &#8230; <a title=\"Creating a backup user with read-only permission for MySQL DB\" class=\"read-more\" href=\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/\" aria-label=\"Read more  on Creating a backup user with read-only permission for MySQL DB\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":441,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[218,2],"tags":[195,194,193,189,190,196,213,141,204,205,206,200,202,203,209,214,201,192,212,216,207,215,208,198,211,199,210,191,188,197],"class_list":["post-426","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql-db","category-tutorials","tag-backup-user-with-read-only-permission","tag-create-mysql-backup-user","tag-create-user-in-phpmyadmin","tag-creating-a-user-in-mysql","tag-database-user","tag-give-permission-to-user-in-phpmyadmin","tag-how-to-create-mysql-backup-user","tag-mysql","tag-mysql-backup-all-databases","tag-mysql-backup-automation","tag-mysql-backup-best-practices","tag-mysql-backup-command","tag-mysql-backup-command-linux","tag-mysql-backup-database-command-line","tag-mysql-backup-database-user-permissions","tag-mysql-backup-only-user","tag-mysql-backup-tools","tag-mysql-backup-user","tag-mysql-backup-user-accounts","tag-mysql-backup-user-password","tag-mysql-backup-user-privileges","tag-mysql-backup-user-rights","tag-mysql-backup-users-and-grants","tag-mysql-beginners-tutorial","tag-mysql-create-backup-user","tag-mysql-database-tutorial","tag-mysql-user-for-backup-permissions","tag-mysql-user-permission","tag-phpmyadmin","tag-select-permission-to-all-tables-in-database-in-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating a backup user with read-only permission for MySQL DB - ITSupportWale<\/title>\n<meta name=\"description\" content=\"We will discuss two ways of creating the backup user with read-only permission. First with the use of the terminal and the second is from PhpMyAdmin GUI.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a backup user with read-only permission for MySQL DB - ITSupportWale\" \/>\n<meta property=\"og:description\" content=\"We will discuss two ways of creating the backup user with read-only permission. First with the use of the terminal and the second is from PhpMyAdmin GUI.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/\" \/>\n<meta property=\"og:site_name\" content=\"ITSupportWale\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Itsupportwale-298547177495978\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-02T12:24:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-17T10:28:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/mysql-backup-user-poster.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"616\" \/>\n\t<meta property=\"og:image:height\" content=\"357\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Techie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Techie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/\"},\"author\":{\"name\":\"Techie\",\"@id\":\"https:\/\/itsupportwale.com\/blog\/#\/schema\/person\/8c5a2b3d36396e0a8fd91ec8242fd46d\"},\"headline\":\"Creating a backup user with read-only permission for MySQL DB\",\"datePublished\":\"2019-05-02T12:24:24+00:00\",\"dateModified\":\"2026-02-17T10:28:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/\"},\"wordCount\":522,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/itsupportwale.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/mysql-backup-user-poster.jpg\",\"keywords\":[\"backup user with read-only permission\",\"create mysql backup user\",\"create user in phpmyadmin\",\"creating a user in mysql\",\"database user\",\"give permission to user in phpmyadmin\",\"how to create mysql backup user\",\"mysql\",\"mysql backup all databases\",\"mysql backup automation\",\"mysql backup best practices\",\"mysql backup command\",\"mysql backup command linux\",\"mysql backup database command line\",\"mysql backup database user permissions\",\"mysql backup only user\",\"mysql backup tools\",\"mysql backup user\",\"mysql backup user accounts\",\"mysql backup user password\",\"mysql backup user privileges\",\"mysql backup user rights\",\"mysql backup users and grants\",\"Mysql beginners tutorial\",\"mysql create backup user\",\"Mysql database tutorial\",\"mysql user for backup permissions\",\"mysql user permission\",\"phpmyadmin\",\"Select permission to all tables in database in mysql\"],\"articleSection\":[\"mysql server\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/\",\"url\":\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/\",\"name\":\"Creating a backup user with read-only permission for MySQL DB - ITSupportWale\",\"isPartOf\":{\"@id\":\"https:\/\/itsupportwale.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/mysql-backup-user-poster.jpg\",\"datePublished\":\"2019-05-02T12:24:24+00:00\",\"dateModified\":\"2026-02-17T10:28:03+00:00\",\"description\":\"We will discuss two ways of creating the backup user with read-only permission. First with the use of the terminal and the second is from PhpMyAdmin GUI.\",\"breadcrumb\":{\"@id\":\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#primaryimage\",\"url\":\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/mysql-backup-user-poster.jpg\",\"contentUrl\":\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/mysql-backup-user-poster.jpg\",\"width\":616,\"height\":357,\"caption\":\"mysql-backup-user-poster\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/itsupportwale.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating a backup user with read-only permission for MySQL DB\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/itsupportwale.com\/blog\/#website\",\"url\":\"https:\/\/itsupportwale.com\/blog\/\",\"name\":\"ITSupportWale\",\"description\":\"Tips, Tricks, Fixed-Errors, Tutorials &amp; Guides\",\"publisher\":{\"@id\":\"https:\/\/itsupportwale.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/itsupportwale.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/itsupportwale.com\/blog\/#organization\",\"name\":\"itsupportwale\",\"url\":\"https:\/\/itsupportwale.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/itsupportwale.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2023\/09\/cropped-Logo-trans-without-slogan.png\",\"contentUrl\":\"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2023\/09\/cropped-Logo-trans-without-slogan.png\",\"width\":1119,\"height\":144,\"caption\":\"itsupportwale\"},\"image\":{\"@id\":\"https:\/\/itsupportwale.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Itsupportwale-298547177495978\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/itsupportwale.com\/blog\/#\/schema\/person\/8c5a2b3d36396e0a8fd91ec8242fd46d\",\"name\":\"Techie\",\"sameAs\":[\"https:\/\/itsupportwale.com\",\"iswblogadmin\"],\"url\":\"https:\/\/itsupportwale.com\/blog\/author\/iswblogadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a backup user with read-only permission for MySQL DB - ITSupportWale","description":"We will discuss two ways of creating the backup user with read-only permission. First with the use of the terminal and the second is from PhpMyAdmin GUI.","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:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/","og_locale":"en_US","og_type":"article","og_title":"Creating a backup user with read-only permission for MySQL DB - ITSupportWale","og_description":"We will discuss two ways of creating the backup user with read-only permission. First with the use of the terminal and the second is from PhpMyAdmin GUI.","og_url":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/","og_site_name":"ITSupportWale","article_publisher":"https:\/\/www.facebook.com\/Itsupportwale-298547177495978","article_published_time":"2019-05-02T12:24:24+00:00","article_modified_time":"2026-02-17T10:28:03+00:00","og_image":[{"width":616,"height":357,"url":"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/mysql-backup-user-poster.jpg","type":"image\/jpeg"}],"author":"Techie","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Techie","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#article","isPartOf":{"@id":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/"},"author":{"name":"Techie","@id":"https:\/\/itsupportwale.com\/blog\/#\/schema\/person\/8c5a2b3d36396e0a8fd91ec8242fd46d"},"headline":"Creating a backup user with read-only permission for MySQL DB","datePublished":"2019-05-02T12:24:24+00:00","dateModified":"2026-02-17T10:28:03+00:00","mainEntityOfPage":{"@id":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/"},"wordCount":522,"commentCount":0,"publisher":{"@id":"https:\/\/itsupportwale.com\/blog\/#organization"},"image":{"@id":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#primaryimage"},"thumbnailUrl":"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/mysql-backup-user-poster.jpg","keywords":["backup user with read-only permission","create mysql backup user","create user in phpmyadmin","creating a user in mysql","database user","give permission to user in phpmyadmin","how to create mysql backup user","mysql","mysql backup all databases","mysql backup automation","mysql backup best practices","mysql backup command","mysql backup command linux","mysql backup database command line","mysql backup database user permissions","mysql backup only user","mysql backup tools","mysql backup user","mysql backup user accounts","mysql backup user password","mysql backup user privileges","mysql backup user rights","mysql backup users and grants","Mysql beginners tutorial","mysql create backup user","Mysql database tutorial","mysql user for backup permissions","mysql user permission","phpmyadmin","Select permission to all tables in database in mysql"],"articleSection":["mysql server","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/","url":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/","name":"Creating a backup user with read-only permission for MySQL DB - ITSupportWale","isPartOf":{"@id":"https:\/\/itsupportwale.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#primaryimage"},"image":{"@id":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#primaryimage"},"thumbnailUrl":"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/mysql-backup-user-poster.jpg","datePublished":"2019-05-02T12:24:24+00:00","dateModified":"2026-02-17T10:28:03+00:00","description":"We will discuss two ways of creating the backup user with read-only permission. First with the use of the terminal and the second is from PhpMyAdmin GUI.","breadcrumb":{"@id":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#primaryimage","url":"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/mysql-backup-user-poster.jpg","contentUrl":"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2019\/05\/mysql-backup-user-poster.jpg","width":616,"height":357,"caption":"mysql-backup-user-poster"},{"@type":"BreadcrumbList","@id":"https:\/\/itsupportwale.com\/blog\/creating-a-backup-user-with-read-only-permission-for-mysql-db\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/itsupportwale.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Creating a backup user with read-only permission for MySQL DB"}]},{"@type":"WebSite","@id":"https:\/\/itsupportwale.com\/blog\/#website","url":"https:\/\/itsupportwale.com\/blog\/","name":"ITSupportWale","description":"Tips, Tricks, Fixed-Errors, Tutorials &amp; Guides","publisher":{"@id":"https:\/\/itsupportwale.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/itsupportwale.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/itsupportwale.com\/blog\/#organization","name":"itsupportwale","url":"https:\/\/itsupportwale.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/itsupportwale.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2023\/09\/cropped-Logo-trans-without-slogan.png","contentUrl":"https:\/\/itsupportwale.com\/blog\/wp-content\/uploads\/2023\/09\/cropped-Logo-trans-without-slogan.png","width":1119,"height":144,"caption":"itsupportwale"},"image":{"@id":"https:\/\/itsupportwale.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Itsupportwale-298547177495978"]},{"@type":"Person","@id":"https:\/\/itsupportwale.com\/blog\/#\/schema\/person\/8c5a2b3d36396e0a8fd91ec8242fd46d","name":"Techie","sameAs":["https:\/\/itsupportwale.com","iswblogadmin"],"url":"https:\/\/itsupportwale.com\/blog\/author\/iswblogadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/itsupportwale.com\/blog\/wp-json\/wp\/v2\/posts\/426","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itsupportwale.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itsupportwale.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itsupportwale.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/itsupportwale.com\/blog\/wp-json\/wp\/v2\/comments?post=426"}],"version-history":[{"count":9,"href":"https:\/\/itsupportwale.com\/blog\/wp-json\/wp\/v2\/posts\/426\/revisions"}],"predecessor-version":[{"id":4688,"href":"https:\/\/itsupportwale.com\/blog\/wp-json\/wp\/v2\/posts\/426\/revisions\/4688"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/itsupportwale.com\/blog\/wp-json\/wp\/v2\/media\/441"}],"wp:attachment":[{"href":"https:\/\/itsupportwale.com\/blog\/wp-json\/wp\/v2\/media?parent=426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itsupportwale.com\/blog\/wp-json\/wp\/v2\/categories?post=426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itsupportwale.com\/blog\/wp-json\/wp\/v2\/tags?post=426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}