Monday, December 14, 2020

mySQL: Give user access to everything

How to give a user access to everything in mySQL?

GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost';


And in SQL Server:

ALTER SERVER ROLE [sysadmin] ADD MEMBER [SQLLoginName]


Know what you need, and investigate alternatives, before "Granting The World".

No comments:

Post a Comment