Please tell me in phpmyadmin - the fields in some tables in my database can be changed, while others can not.

I understand they are just for reading ? How do I put the tables I need to change (write)?

    2 answers 2

    MySQL allows you to manage the rights of database users at the server level, a specific database and individual tables (with indication of specific fields).

    You can create a user who can perform SELECT only in the website database for the users table (and limit the selection to only the name and id fields) and allow him only UPDATE the name field of the users table.

    Privilege

    • I can not find such a sign in phpmyadmin - caramel ua
    • Through root I executed such commands in mysql - GRANT ALL PRIVILEGES ON *. * TO 'my_user' @ 'localhost'; FLUSH PRIVILEGES; - did not help - caramel ua
    • And what is the impossibility of changing values? - Vladimir Serykh
    • Well, for example, in phpmyadmin, the value of the fields of some tables can be changed - and these in question are not allowed. Through the site too - info is shown - but it cannot be updated - caramel ua

    The problem was solved by the following line

     ALTER TABLE tablename ADD newid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

    the mistake was

    This selection does not contain a unique column.