Anyone every install this script to automaticlly create MySQL databases and users?

http://www.raqsupport.net/utilities

[Edited by syanet on 03-02-2001 at 06:15 PM]

Just wondering if anyone has ever tested this script out and how does it work?

No - But I've used phpMyAdmin, which is the bees knees

Hi there,

I could not help notice the visitors in our tracking system. PHPMyAdmin is a great database administration tool. The major problem about it, is that is takes app. 3-5 minutes to make a new user database for a web hosting customer - or you will have to enter the sql for it manually. With this small script it takes app. 5 seconds (very simple script indeed).

We use it ourself on our own servers and on several of our customers servers as well. The only thing that it does is executing the following sql statements via php.

1: CREATE DATABASE $name
2: GRANT ALL PRIVILEGES ON $name.* TO $name@localhost IDENTIFIED BY '$password'
3: GRANT ALL PRIVILEGES ON $name.* TO $name@\"%\" IDENTIFIED BY '$password"

If you have just a little experience with MySQL you will recognise these sql statements. All that is added is the variables and the nessesary php stuff to make it browser based.

It will not kill your server, belive me :)

Best

Martin Jensen
Mermaid Consulting I/S // http://www.raqsupport.net

Why would it take 3-5 minutes to type 3 simple queries into phpmyadmin? :sickface:

So after installation, just stick the signup form on a page and any other users on the server should be able to signup for their own Databases as they wish?

I wouldn't recommend allowing them to sign up for DB's at will. This will create problems if a malicous user finds out about it. It's totally up to you of course I am a bit on the paranoid side so I try to monitor or limit what a user can and cant do freely.

Regards
X-treme

Ps. I also use PHPMYADMIN and it takes me approx 5 secs to setup a new user and db.

Good point. Is there a way this script can be modified to allow a user to signup at will, but only for a limit of say 2 databases? Maybe require their username for the server and cross refrence it somehow to prevent signing up for alot.

There is an add on script for phpMyAdmin which does user stuff - Search the boards or the web, I'm sure you'll find it...

Let me know if any of you found it. Please ... Thank you...

I wasnt aware there was an add-on for users. If anyone finds it let me know I would like to take a look at it myself.

Syanet,
I am not fimilar with the script in question but you can limit the number of DB's and who has access to to them using PhpMyAdmin.

X-treme

Well if you want the add on, you can download it at www.planetdps.com/useradmin.zip - I can't remeber how I got it, but all the details are on the file... I'll leave it there for a week or so - Note : I did not write this or anything so don't ask! I also take no credit for this, and appologise to whom ever sent it to me if this is a bad move :)

This addon rocks !!!

can someone tell me what the right way is to add a database in phpmyadmin and assign a user/password so a client can use that database?

Year really.

I added a db and user.

But when I try to use the db, mysql does not recognize the user.

I have to go into ssh and grant privileges. Then it works.

WEird.