Skip to main content
2 of 3
added 33 characters in body
Up_One
  • 1.6k
  • 10
  • 15

Use this script to help you create the grant script syntax : Run a root od mysql admin user.

  select 'grant all privileges on ', table_name, 'to 
someuser@somehost;' from information_schema.tables where table_schema = 'database name' and 
table_name not in ('table without access', 'table without access');

This will create an output that you can run after.

Up_One
  • 1.6k
  • 10
  • 15