how to solve user access denied for select queries in mysql

Sirisha K

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo7y ago
Go through the link may help you

https://www.tutorialspoint.com/mysql/mysql-administration.htm
Sirisha K7y ago
I tried above query like below

GRANT SELECT ON database.* TO user@'10.240.225.78';

i'm unable run any queries in mysql workbench
Kapil Gaur7y ago
Yes you can use these queries in mysql workbench as well. But do check sometimes only DBA has previleges to grant privileges to other users mostly when we are in production environments.
Sirisha K7y ago
Is these queries helpful to workbench?
Kapil Gaur7y ago
I hope you have created yourself as a user. Now fire following queries in your mysql command prompt based on your requirement.
Enter the following if the database user already exists.:

GRANT SELECT ON database.* TO user@'localhost';

If you intend to create a brand new user, then run this:

GRANT SELECT ON database.* TO user@'localhost' IDENTIFIED BY 'password';

To enable more options, you would separate them with a comma. So to enable SELECT, INSERT, and DELETE your syntax would look like this:

GRANT SELECT, INSERT, DELETE ON database TO username@'localhost' IDENTIFIED BY 'password';

Once you have given the desired privileges for your user, you will need to run this command within the MySQL command prompt:

FLUSH PRIVILEGES;

To see a list of the privileges that have been granted to a specific user:

select * from mysql.user where User='username';
These are enough queries for you to get going. Tell me if this help you.