Allowing the creation of MYSQL databases by a user

rustyz82 · 06-25-2006, 12:38 PM

I was wondering if its possible on a Cent OS system to grant a non privledged user the ability to create mysql databases, add himself to the databases he has created and manipulate them via the shell.
Without them having the ability to modify the existing databases on the system. Is there a way to do this?

vls · 06-25-2006, 12:46 PM

Quote:

Originally Posted by rustyz82

I was wondering if its possible on a Cent OS system to grant a non privledged user the ability to create mysql databases, add himself to the databases he has created and manipulate them via the shell.
Without them having the ability to modify the existing databases on the system. Is there a way to do this?

Yes sir,
http://dev.mysql.com/doc/refman/5.0/...anagement.html

rustyz82 · 06-25-2006, 01:25 PM

Its on a shared hosting server.. does mysql automaticaly prefix a database name with the users userid? I know when cpanel does it, it does do that.

rustyz82 · 06-25-2006, 02:49 PM

Also I am using MySQL 4.1.19 right now, is it still possible or would I need to upgrade to mysql 5? I ask because the documentation you linked is for MySQL 5.

vls · 06-25-2006, 09:21 PM

If you do it by hand you'll need to name the database explicitly or write a shell script to do it for you, e.g. CREATE DATABASE id_dbname;

It's the same as far as the docs go. There's a link to the 4 version docs on the little toolbar on the site.

rustyz82 · 06-26-2006, 01:11 AM

Ok then thats not what i'm looking for. I want the user to be able to log into his shell account, type mysql -u=username -p=password and from the mysql prompt create and work with his own databases, without endangering any of the other databases on teh server.