At the mysql prompt, do one of the following steps: To give the user access to the database from any host, type the following command: grant select on database_name. * to ‘read-only_user_name’@’%’ identified by ‘password’;To create a read-only database user account for MySQL do the following steps: First, login as a MySQL administrator from your terminal / command prompt using the following command: mysql -u root -p You’ll be prompted to enter the password. Type the password for the root account.

How do you make a database user read only?

In the Login-New dialog box, in the Select a page pane, click User Mapping. In the right pane, under Users mapped to this login, make sure that you have selected the database to read. Under Database role membership for the database, click db_datareader. This role gives the user read-only data access to the database.

How do I create a read only user in MySQL workbench?

Select a user under “users and privilege” and click the tab “schema privileges”. Click “add entry”, pick a host and schema. Then al you have to do is check the “select” privilege. This user has read only rights now.

How to read only using the MySQL client?

Read only using the MySQL Client right? Select a user under “users and privilege” and click the tab “schema privileges”. Click “add entry”, pick a host and schema. Then al you have to do is check the “select” privilege. This user has read only rights now.

How do I give a user access to a MySQL database?

Type the password for the root account. At the mysql prompt, do one of the following steps: To give the user access to the database from any host, type the following command: grant select on database_name.* to ‘read-only_user_name’@’%’ identified by ‘password’;

How do I create a read-only database user account for MySQL?

To create a read-only database user account for MySQL do the following steps: First, login as a MySQL administrator from your terminal / command prompt using the following command: mysql -u root -p You’ll prompted to enter the password.

How to grant select privileges to a new user in MySQL?

Grant the SELECT privilege to user. GRANT SELECT ON kodejava.* TO ‘report’@’%’; Execute the following command to make the privilege changes saved and take effect. Type quit to exit from the MySQL shell. Now we can try the newly created user account. Start by login with the new user account and provide the corresponding password.