Mysql database permissions

Grant all permissions to user "test_user" on the new database "foss"

         mysql >  grant  all  on  foss.*  to  'test_user'@'localhost'   identified  by   'test_user_password';

                   foss  ---> database name   

                   foss.*  ----> [database name] . [table name]                  

Grant all permissions to user "test_user" on all databases

                   

         mysql >  grant  all  on  *.*  to  'test_user'@'localhost'   identified  by   'test_user_password';                       

                      all   ----> all permission

                      *.*  ----> [database name] . [table name]

How To Grant Different User Permissions

            Here is a short list of other common possible permissions that users can enjoy.

ALL PRIVILEGES- as we saw previously, this would allow a MySQL user all access to a designated database (or if no database is selected, across the system)

CREATE- allows them to create new tables or databases

DROP- allows them to them to delete tables or databases

DELETE- allows them to delete rows from tables

INSERT- allows them to insert rows into tables

SELECT- allows them to use the Select command to read through databases

UPDATE- allow them to update table rows

GRANT OPTION- allows them to grant or remove other users' privileges