how to solve user access denied for select queries in mysql

Question

Kapil Gaur · Answer

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.

Laxmidhar Sahoo · Answer

Go through the link may help you https://www.tutorialspoint.com/mysql/mysql-administration.htm

Sirisha K · Answer

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 Gaur · Answer

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 K · Answer

Is these queries helpful to workbench?

how to solve user access denied for select queries in mysql

Answers (5)