Best way to lock a whole mySQL table ?

[matthias_livecode_150811 at m-r-d.de]

You could set user permissions and allow only select.

https://simplebackups.com/blog/how-to-create-and-grant-permissions-to-a-mysql-user/

Regards,
Matthias

> Am 07.01.2024 um 21:45 schrieb jbv via use-livecode <use-livecode at lists.runrev.com>:
> 
> Hi list,
> I have a mySQL table with over a million rows and I would
> like to lock the data so that no inserts nor updates are
> possible, only reads via select commands.
> I have read the doc as well as numerous blogs, and as far
> as I understand, the following command
> LOCK TABLES myTable WRITE;
> locks the table and prevents other users from reading or
> writing to the table.
> But that's not what I need : I need to allow any user to
> read at any time, but prevent anyone to write at any time.
> Besides, I also need the lock to be effective in phpMyAdmin.
> And of course, I need to do that for 1 table only and not
> the other tables in the db.
> 
> How can I achieve that ? Does the solution have to do
> with the user privileges ?
> 
> Thank you in advance.
> jbv
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode