jd2007 Posted August 7, 2007 Share Posted August 7, 2007 for e.g., if i want to access all my databases, i type my password and access them...what if another users wants to create databases of his own, can he use a different password ? how to do it ? Quote Link to comment https://forums.phpfreaks.com/topic/63663-can-different-users-have-different-mysql-databses-on-one-computer/ Share on other sites More sharing options...
effigy Posted August 7, 2007 Share Posted August 7, 2007 Each user should have their own account in MySQL. In order for them to create databases and tables they need the CREATE privilege, which can be granted via GRANT. Quote Link to comment https://forums.phpfreaks.com/topic/63663-can-different-users-have-different-mysql-databses-on-one-computer/#findComment-317514 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.