SHOW DATABASES – Enables the account to see database names by issuing the SHOW DATABASE statement.SELECT statements require the SELECT privilege only if they actually access tables. SELECT -Enables rows to be selected from tables in a database.DROP – Enables use of statements that drop (remove) existing databases, tables, and views.DELETE – Enables rows to be deleted from tables in a database.ALTER_TABLE also requires the CREATE and INSERT privileges. ALTER – Enables use of the ALTER_TABLE statement to change the structure of tables.INSERT – Enables rows to be inserted into tables in a database.CREATE – Enables use of statements that create new databases and tables.ALL, ALL PRIVILEGES – These privilege specifiers are shorthand for “all privileges available at a given privilege level” (except GRANT OPTION).We suggest this other article about managing mysql users. For this reason, it is best to use CREATE USER and GRANT for adding users and privileges. The table can be queried and although it is possible to directly update it. The ‘ers’ table contains information about users that have permission to access the MySQL server and their global privileges. UPDATE – allows the user to update table rows.SELECT – allows the user to read the database.INSERT – allows the user to insert rows into a specific MySQL table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |