MySQL 8 Cookbook

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:  localhost.
• You can restrict the access to the IP range. For example: 10.148.%.%. By giving %, the user can access from any host.
• * password: company_pass.
• * using mysql_native_password (default) authentication.
• You can ...