mysql user permissions, please help
Anyway, i want a user to only be able to see and edit his own databases, so this is what i did
i created a mysql user, and give him no access rights
i then setup a database permission, so that he could alter, edit, and do everythign he needs to do to his database.
that works great. he only see's his database, and know one elses.
Problem is, i want users to be able to create databases. but how do i do this, where do i set the permissions, in the user database?
if so what permissions do i give that user, to be able to create a database, but at the same time, not letting him see other peoples databases
Thanx
