I create a users in mysql and grant privilages of one databases but that account show me all databases and i easily delete other databases data.
Asked
Active
Viewed 188 times
0
-
When you log in as your new user from the command line (`mysql -u{username} -p`) and tell MySQL to show you the databases (`show databases;`), does it list all databases as well? If so, you probably granted privileges incorrectly. – mingos Dec 13 '17 at 11:12
-
yes this show all databases. – Husnain Khan Dec 13 '17 at 11:14
-
I would assume you granted the user access to `*.*` instead of `mydatabase.*`. Here's a question that might be helpful in your situation: https://stackoverflow.com/questions/1720244/create-new-user-in-mysql-and-give-it-full-access-to-one-database – mingos Dec 13 '17 at 11:16
-
thanks that help me. – Husnain Khan Dec 13 '17 at 12:50