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 ...