{"id":1685,"date":"2015-01-27T22:02:14","date_gmt":"2015-01-27T22:02:14","guid":{"rendered":"https:\/\/qbytes.cloud\/?p=1685"},"modified":"2015-01-27T22:02:14","modified_gmt":"2015-01-27T22:02:14","slug":"add-mysql-user-grant-permissions-database","status":"publish","type":"post","link":"https:\/\/www.qbytes.cloud\/index.php\/2015\/01\/27\/add-mysql-user-grant-permissions-database\/","title":{"rendered":"How to Create a MySQL User: Remove a MySQL User, Show a MySQL User"},"content":{"rendered":"\n

This article shows how to create a MySQL user, remove a MySQL user and to show a list of MySQL users.<\/p>\n\n\nRead more: How to Create a MySQL User: Remove a MySQL User, Show a MySQL User<\/span><\/a>\n\n

Grant all privileges on a database to a single user:
\n

<\/p>\n<p>mysql&gt; CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'new_password';<\/p>\n<p><\/pre><\/p>\n
<br>\nmysql&gt; GRANT ALL ON my_db.* TO 'new_user'@'localhost';<br>\n<\/pre><\/p>\n
Or…<\/p>\n
<br>\nmysql&gt; GRANT ALL PRIVILEGES ON database_name.* to 'new_user'@'localhost' IDENTIFIED BY 'password';<br>\n<\/pre><\/p>\n
Remove a USer from Mysql<\/p>\n
Review a List of MySQL Users
\n
<\/p>\n<p>mysql&gt; SELECT User,Host FROM mysql.user;<\/p>\n<p><\/pre><\/p>\n
Remove a MySQL User
\nTo remove a user from MySQL, we again use the DROP command.<\/p>\n
It only takes one simple command to delete a user in MySQL, but BEWARE; dropping a user can not be undone! The command is as follows:
\n
<\/p>\n<p>mysql&gt; DROP USER 'testuser'@'localhost';<\/p>\n<p><\/pre><\/p>\n
If a user of the name testuser does not exist, then you\u2019ll receive this error:
\n
<\/p>\n<p>mysql&gt; ERROR 1396 (HY000): Operation DROP USER failed for 'testuser'@'localhost'<\/p>\n<p><\/pre><\/p>","protected":false},"excerpt":{"rendered":"
This article shows how to create a MySQL user, remove a MySQL user and to show a list of MySQL users. Grant all privileges on a database to a single user: <\/p> <p>mysql&gt; CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'new_password';<\/p> <p> <br> mysql&gt; GRANT ALL ON my_db.* TO 'new_user'@'localhost';<br> Or… <br> mysql&gt; GRANT ALL PRIVILEGES ON … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[],"class_list":["post-1685","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/1685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/comments?post=1685"}],"version-history":[{"count":0,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/1685\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/media?parent=1685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/categories?post=1685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/tags?post=1685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}