How to give privileges to users in mysql
Handling mysql server through a third-party application is very easy and it has graphical user interface
adding users through the MySQL monitor is not difficult, especially if you
understand the security checkpoints used by MySQL.
some of the common privileges in mysql
Nice and easy tutorial for those are at their beginning stage learning mysql.
easy and formal steps for adding user with privileges and what rights you assign them with graphical and command line.
ALL—Gives the user all common privileges.
. INDEX—User can add or delete indexes.
. INSERT—User can add records to tables.
PROCESS—User can view and stop system processes; only trusted users should be able to do this.
. RELOAD—User can issue FLUSH statements; only trusted users should be able to do this.
. SELECT—User can select records from tables.
. SHUTDOWN—User can shut down the MySQL server; only trusted users should be able to do this.
. UPDATE—User can update (modify) records in tables.
. ALTER—User can alter (modify) tables, columns, and indexes.
. CREATE—User can create databases and tables.
. DELETE—User can delete records from tables.
DROP—User can drop (delete) tables and databases.
. FILE—User can read and write files; this privilege is used to import or dump