Change user privileges in MariaDB?
Hi,
I have spent all day trying to revoke access to a couple of tables im MariaDB MySQL phpadmin. There is no clear way to do this. Apparently the functionality was removed years ago (according to this thread: )
Did it ever manage to get re-installed? Is there anywhere we can activate it? This is crucial for us and many others who have to let 3rd party developers into our systems. We need to be able to protect tables such as _users and others that contain sensitive information/settings. How on earth do we go about doing this now?
I want to revoke access for specific users in my Joomla database so creating a new database user in cpanel isn't the answer. This was apparently very achievable in the past.
I have tried accessing as root@localhost and running the REVOKE query via pyhmyadmin but it produces errors i.e. I used various things for example like:
REVOKE ALL PRIVILEGES, GRANT OPTION ON mytable FROM 'user'@localhost';
How would I achieve a simple thing like this?
Kind regards
Please sign in to leave a comment.
Comments
0 comments