Hello everyone, I hope someone will help me.
I am having problem with the users updating and changing tables. First, I have one client app that has user management and list of users, also I have HeidiSQL platform in which those users are listed. But, my Heidi username is not one of those in the list, so I have other username for accessing DB. My all users on the list are admins in that client that I need.
When I try to update something in the tables in DB, it returns errors like SQL Error 1142, command denied to user..
My question is how I change permissions, does it matter that my users are not the same? I guess my DB username is also admin.
How do I change permissions, privileges?
Thank you, I hope you get the question. I am pretty much new in this..
Racc