{"id":9840,"date":"2020-07-04T11:20:28","date_gmt":"2020-07-04T11:20:28","guid":{"rendered":"https:\/\/www.milesweb.in\/hosting-faqs\/?p=9840"},"modified":"2020-07-04T11:20:28","modified_gmt":"2020-07-04T11:20:28","slug":"create-a-mysql-user-and-grant-permissions","status":"publish","type":"post","link":"https:\/\/www.milesweb.in\/hosting-faqs\/create-a-mysql-user-and-grant-permissions\/","title":{"rendered":"Learn to Create a MySQL User and Grant Permissions via Command Line"},"content":{"rendered":"

MySQL is open-source database management software that enables users to store, manage, and retrieve data later. It offers multiple options to grant specific users permissions within the tables and databases.<\/p>\n

In this tutorial, you will learn to create a MySQL user and several commands to grant permissions, revoke them and delete existing users.<\/p>\n

At first ensure that you have installed MySQL.<\/p>\n

When you start using, you are provided with a username and a password. These credentials will help you to get root access or full control of all your databases and tables.<\/p>\n

But sometimes you will need to grant the database access to someone else without giving them complete control.<\/p>\n

Suppose you hire developers for your database management but don\u2019t want them to delete or modify any sensitive information.<\/p>\n

In this case, you will need to provide them with the credentials of a non-root user. With this, you can keep a watch on the activity developers are doing with your data.<\/p>\n

Create a New User Account in MySQL<\/h3>\n

At first, access the command line and enter your MySQL server using the below command:<\/p>\n

mysql<\/pre>\n
This will return the result below which confirms that you are accessing a MySQL server:<\/p>\n
mysql><\/pre>\n
Now execute the below command to create a new user:<\/p>\n
CREATE USER \u2018new_user\u2019@\u2018localhost\u2019 IDENTIFIED BY \u2018password\u2019;<\/pre>\n
Here the \u2018new_user\u2019<\/strong> represents the name of the user and IDENTIFIED BY \u2018password\u2019<\/strong> represents the password for that user. You can replace these values with your own.<\/p>\n
Execute the below command to grant all the privileges to the newly created user:<\/p>\n
GRANT ALL PRIVILEGES ON * . * TO 'new_user'@'localhost';<\/pre>\n
If you want the changes to take effect immediately, flush these privileges by running the below command:<\/p>\n
FLUSH PRIVILEGES;<\/pre>\n
Now, your new user account will have the same privileges as the root user has.<\/p>\n
Grant Privileges Separately for a MySQL User<\/h3>\n
It is important that you mention the database name and table name and separate them with a . (period) and without spaces. With this, the root user will have more control over particular data.<\/p>\n
Also, replace the PERMISSION_TYPE<\/strong> value with the type of access you want to give to the new user account.<\/p>\n
Below are the commonly used commands in MySQL:<\/p>\n