Limiting acces for a MySql user

[jadmin]

Hi,

I see that Direct Admin allows me to manage the type of acces rights of MySql users like SELECT or more, but how can I limit the user access tso some tables or view of the database?

I do not see how to do that in the DirectAdmin interface and apparently I do not have the rights to execute GRANT statements on the database.

Thanks for any help on this

 

[Arieh]

I suppose this isn't posible within DirectAdmin, however you can login as the da_admin user in e.g. phpmyadmin which should have access to make such modifications to user accounts. The default password is located in /usr/local/directadmin/scripts/setup.txt

 

[jadmin]

I suppose this isn't posible within DirectAdmin, however you can login as the da_admin user in e.g. phpmyadmin which should have access to make such modifications to user accounts. The default password is located in /usr/local/directadmin/scripts/setup.txt

Thanks for the info Arieh.

In the mean time I tried a more work intensive and less flexible approach: create a new database assign the appropriate rights to the users and create as many views as tables I need to grant limited access to.