Hello
I'm trying to create a table in my database where all users in it can grant and revoke privileges in other tables in the database, have created this table and named it super_user_admin, but each time i try to write the sql syntax i always get a message pointing to an error i cant see in line 2, below is my syntax
grant all
on customer_account,music,movies,orders,wish_list
to super_user_admin@localhost identified by 'password';
can anyone see any error in this syntax? PLS I'M DESPERATE 🙁