Feb 21, 2017 #1 humpydumpy2000 IS-IT--Management Joined Aug 18, 2016 Messages 30 Location PH Hi all, How am I going to create a user that would allowed only to create, delete and view their own databases but not the main administrator database? Thanks a lot.
Hi all, How am I going to create a user that would allowed only to create, delete and view their own databases but not the main administrator database? Thanks a lot.
Feb 22, 2017 #2 ChrisHirst IS-IT--Management Joined Nov 23, 2001 Messages 8,049 Location GB GRANT ALL ON [database].* TO 'user@hostname'; https://dev.mysql.com/doc/refman/5.7/en/grant.html Chris. Indifference will be the downfall of mankind, but who cares? Time flies like an arrow, however, fruit flies like a banana. Never mind this jesus character, stars had to die for me to live. Upvote 0 Downvote
GRANT ALL ON [database].* TO 'user@hostname'; https://dev.mysql.com/doc/refman/5.7/en/grant.html Chris. Indifference will be the downfall of mankind, but who cares? Time flies like an arrow, however, fruit flies like a banana. Never mind this jesus character, stars had to die for me to live.