-- Grant all privileges including the grant option (basically an additional root user) GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'%' WITH GRANT OPTION; -- Grant all privileges GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'%'; -- Grant read-only privileges GRANT SELECT ON *.* TO 'newuser'@'%';