LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   How to allow each user can create its own data base? (https://www.linuxquestions.org/questions/linux-server-73/how-to-allow-each-user-can-create-its-own-data-base-928012/)

px87 02-06-2012 11:15 PM

How to allow each user can create its own data base?
 
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 (Post 4595647)
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.


All times are GMT -5. The time now is 05:20 AM.