Create user, permissions Create user, permissions humpydumpy2000 (IS/IT--Management) (OP) 22 Feb 17 02:39 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. RE: Create user, permissions ChrisHirst (IS/IT--Management) 22 Feb 17 12:35 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.