Creating users

So far, you have used only the root user to connect to MySQL and execute statements. The root user should never be used while accessing MySQL, except for administrative tasks from localhost. You should create users, restrict the access, restrict the resource usage, and so on. For creating new users, you should have the CREATE USER privilege that will be discussed in the next section. During the initial set up, you can use the root user to create other users.

How to do it...

Connect to mysql using the root user and execute CREATE USER command to create new users.

mysql> CREATE USER IF NOT EXISTS 'company_read_only'@'localhost' 
IDENTIFIED WITH mysql_native_password 
BY 'company_pass' 
WITH MAX_QUERIES_PER_HOUR 500 
MAX_UPDATES_PER_HOUR 100;

You might get the following error if the password is not strong.

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

The preceding statement will create users with:

• * Username: company_read_only.
• * access only from...