{"id":3549,"date":"2019-10-25T03:15:10","date_gmt":"2019-10-25T03:15:10","guid":{"rendered":"http:\/\/blog.hostinger.io\/hostinger-tutorials\/?p=3549"},"modified":"2026-10-15T04:49:50","modified_gmt":"2026-10-15T04:49:50","slug":"how-create-mysql-user-and-grant-permissions","status":"publish","type":"post","link":"\/ng\/tutorials\/how-create-mysql-user-and-grant-permissions\/","title":{"rendered":"How to create a MySQL user and grant privileges"},"content":{"rendered":"

To create a MySQL user, connect to your MySQL server with an account that has the required permissions, use the CREATE USER<\/code> command, and assign database privileges with GRANT<\/code>. You can then check the user’s access with SHOW GRANTS<\/code>, remove permissions with REVOKE<\/code>, or delete the account with DROP USER<\/code>.<\/p>

In this tutorial, you’ll learn how to create and manage MySQL users through the command line, grant only the permissions they need, and restrict access to specific databases.<\/p>

\"\"<\/a><\/figure>

\n\n\n\n\n<\/p>

Prerequisites for creating a MySQL user<\/h2>

Before creating a MySQL user, make sure you have a running MySQL server, command-line access, and an administrative account with permission to create users and grant privileges.<\/p>

This tutorial uses a Linux VPS. Connect to your server through SSH, then access MySQL with an administrative account. For a password-based root account, use:<\/p>

mysql -u root -p<\/pre>
Depending on your server’s authentication setup, you may need to use sudo mysql<\/code> instead.<\/p>
If you use Hostinger Web or Cloud hosting, you can create and manage database users through Websites → Dashboard → Databases → Management<\/strong>, without running these administrative SQL commands.<\/p>
How to create a MySQL user and grant privileges<\/h2>
Just as you start using MySQL, you’ll be given a username and a password. These initial credentials will grant you root<\/strong> access or full control of all your databases and tables.<\/p>
However, there are times when you’ll need to give the database access to someone else without granting them full control.<\/p>
For instance, you hire developers to maintain your databases, but you don’t want to provide them with the ability to delete or modify any sensitive information.<\/p>
In that case, you should give them the credentials of a non-root user. This way, you can keep track of what the developers can and cannot do with your data.<\/p>
In this part, we will explain how to create a user account in MySQL with all privileges to your database. In a practical sense, it’s not wise to give full control to a non-root user. However, it’s still a good entry-point to learn about user privileges.<\/p>
To create a new user account in MySQL, follow these steps:<\/p>
    \n
  1. Access command line and enter MySQL server:\n
    mysql<\/pre>\n<\/li>\n\n\n\n
  2. The script will return this result, which verifies that you are accessing a MySQL server.\n
    mysql><\/pre>\n<\/li>\n\n\n\n
  3. Then, execute the following command: 
    CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'strong_password';<\/code><\/pre><\/li>\n<\/ol>
      \n
    1. new_user<\/strong> is the name we’ve given to our new user account and the IDENTIFIED BY ‘password’<\/strong> section sets a passcode for this user. You can replace these values with your own, inside the quotation marks.<\/li>\n\n\n\n
    2. In order to grant all privileges of the database for a newly created user, execute the following command: 
      GRANT SELECT, INSERT, UPDATE ON example_db.* TO 'new_user'@'localhost';<\/code><\/pre><\/li>\n<\/ol>
      Replace new_user<\/code> with your preferred username and strong_password<\/code> with a secure password.<\/p>
      The localhost<\/code> value restricts the account to local connections. If an application connects from another server, specify its hostname or IP address instead. Using 'new_user'@'%'<\/code> matches connections from any host, so prefer a specific host whenever possible.<\/p>
      If you’re running a setup script that may execute more than once, you can use CREATE USER IF NOT EXISTS<\/code> to avoid an error when the account already exists. This won’t change an existing account’s password or permissions.<\/p>
      This grants the user permission to read, add, and update records in example_db<\/code> without giving access to other databases. Replace the database name and privileges according to your application’s needs.<\/p>
      If the account requires all privileges within a particular database, use GRANT ALL PRIVILEGES ON example_db.*<\/code> instead of granting privileges globally with *.*<\/code>.<\/p>
      Once that is done, your new user account has the same access to the database as the root user.<\/p>
      How to grant specific MySQL privileges<\/h2>
      In this part, we will explain how to grant privileges separately for a user account in MySQL.<\/p>
      When specifying the database name and table name, separate them with a . (period) and no spaces. This will give the root user fine-grain control over certain data.<\/p>
      Also, replace the PERMISSION_TYPE<\/strong> value with the kind of access you want to grant to your new user account.<\/p>
      Here are the most used commands in MySQL:<\/p>