How to allow each user can create its own data base?

px87 · 02-06-2012, 11:15 PM

Hi!

I've been googling a lot looking for the way to each user (created with webmin) can create databases in phpmyadmin and show only their own databases.

Do you know the way to do that?

Thanks!

Greetings.

sorry for my bad English :P

chrism01 · 02-06-2012, 11:36 PM

If that's MySQL, you use the CREATE USER ... cmd to create user's in the database, then use the GRANT ... cmd to give them the reqd privileges
http://dev.mysql.com/doc/refman/5.0/en/create-user.html
http://dev.mysql.com/doc/refman/5.0/en/grant.html

px87 · 02-07-2012, 11:11 PM

Quote:

Originally Posted by chrism01

If that's MySQL, you use the CREATE USER ... cmd to create user's in the database, then use the GRANT ... cmd to give them the reqd privileges
http://dev.mysql.com/doc/refman/5.0/en/create-user.html
http://dev.mysql.com/doc/refman/5.0/en/grant.html

Thanks chrism01! I'll try.

Greetins.