mysql permission

[linux1880]

Can anyone tell me how to modify permission and what are the general permission in mysql, thanks.

 

[Terencentanio]

You can do it with the control panel? With cPanel you can choose. With DA it's set to "ALL" by default. Otherwise, no clue. Don't think phpMyAdmin can do it.

 

[Louis12]

You should be able to do it in cpanel. The privilleges are: ALL, ALTER, CREATE TEMPORARY TABLES, CREATE, DELETE, DROP, SELECT, INSERT, UPDATE, REFERENCES, INDEX and LOCK TABLES.

I do not know how to edit permissions via php, but in your cpanel you should be able to somewhere or another.

 

[C.Ingram]

GRANT <priv> [(columns)] ON <database|*>.<table|*> TO <user> IDENTIFIED BY '<password>';

<priv> is from the list Louis provided. You can also alter the tables in the "mysql" database.