mySQL restrictions

kabir · 12-02-2003, 10:57 PM

hey i am using mandrake linux 9.2(not that it really matters) with webmin and usermin. I can not seem to figure out how to let users create a certain number of mySQL databases and have them only be able to view and have full access to the databases that they create. I would love you forever if you help me thanks!

tommytomato · 12-03-2003, 09:25 AM

your using webmin right ?

do you want a user to log in via webmin so he or she can add there own mysql databases, is that what your saying.. ???

tommytomato

kabir · 12-03-2003, 05:33 PM

exactly. I am using webmin to configure everything myself and people login throuigh the usermin (i think usermin is a module for webmin)

tommytomato · 12-03-2003, 05:38 PM

yes thats right, under webmin you can tick each box you want a user to have, but this is not a good idea.

create your user under user min, then tick the boxes you want
i haven't use webmin for awhile..

i'm sure other would agree...

tommytomato

kabir · 12-03-2003, 07:22 PM

but....in usermin is still doesnt let you set the number of Databases a user can have and i still havent figured out to let a user add a new database even when they have all permisisons.....any help?

tommytomato · 12-03-2003, 07:29 PM

wouldn't you have to create a user then add them to the mysql group ?

I'm not sure, i've only just start to play around with mysql via CLI

you may want to go to the mysql web site for the commands..

I've only done, how to drop a database and create and import a sql file into a database...

i have the doc here if you want them

tommytomato