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@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
