MySQL Admin Software

[Bradley]

Can I use mysql admin software to connect to my server? Because I want to have a user that can only write on 1 table and not read anything. I don't seem to see them options in php mysql admin.


Thanks

Bradley

[AndrewT]

Sorry, our servers do not accept remote MySQL connections.

You could of course write your own script on the server to allow this action, however.

[Bradley]

You could of course write your own script on the server to allow this action, however.

Ok, thats great. Thanks Andrew.

[ZYV]

I think you have to look up for this mySQL user's permissions in cPanel. I am not sure you can limit user to reading a specific table via cPanel interface, but you can at least revoke most of INSERT, UPDATE priveleges etc. and then maybe issue a custom command like GRANT ... ON database.table ... .