How to create a read-only MySQL user?

First, login as a MySQL administrator from your terminal / command prompt using the following command: <pre> mysql -u root -p</pre> You’ll prompted to enter the password. Type the password for the <code>root</code> account. Create a new MySQL user account. <pre> CREATE USER 'report'@'%' IDENTIFIED BY 'secret';</pre> The <code>%</code> in the command above means that user <code>report</code> can be used to connect from any host. You can limit the access by defining the host from where the user can connect. Omitting this information will only allow the user to connect from the same machine. <a href="https://medium.com/@nkaurelien/how-to-create-a-read-only-mysql-user-226e8e49a855">Visit Now</a>