I am sure this has been discussed in here but I dodnt find anything through the search.

But anyways I am interested in hearing what people found was best to allowing customers, or other accounts on the Raq4i to use MySQL

I have gotten some scripts running that assist in creating databases but just seems a lot of work to do for a customer or client etc...?

any other methods?

Have a look at phpMyAdmin on freshmeat.

This lets you control your MySQL installation through a browser, including access authority, definition of new databases, tables, importing of text files into a table, etc

I have found phpMyAdmin very easy to set-up and so far have not needed to go back to the command line to do anything in MySQL since I installed it.

Cheers
Mark

Do you have a link?

What exactly do you need? I have a tiny php script that creates the db, the user and sets pass quickly. Not sure if you want more of a phpmyadmin type of 'control the db' once it is created or create the whole thing in the first place?

I just wanted to see if myphpadmin was worth it. I have a PHP script also that I enter the users's email, database name, password and username, it sets it up and email's them the info.

I got it at:
http://www.raqzone.com/tools.htm

The MySQL Account Creator!

In regard to editing the actual databases I use Webmin.

Originally posted by ljprevo
Do you have a link?
Have a look at http://freshmeat.net/projects/phpmyadmin/

Originally posted by Avanti

Have a look at http://freshmeat.net/projects/phpmyadmin/

Thanks Avanti

Great... I appreciate all the help... phpadmin script is great, as well as the one that ljprevo listed....

However now I have a customer stating that he can add, change and delete other databases on the server?

What can I do to stop this?

Originally posted by ljprevo
I just wanted to see if myphpadmin was worth it. I have a PHP script also that I enter the users's email, database name, password and username, it sets it up and email's them the info.

I got it at:
http://www.raqzone.com/tools.htm

The MySQL Account Creator!

In regard to editing the actual databases I use Webmin.

AWESOME!!!! I love this littel script!!

now, can anybody tell me how to setup phpmyadmin to let the user of the newly created DB use it???

Thanks,

Quite simple to install. Just follow the included instruction.

I just had to set one variable in php.ini I think it was the magic_quote thing.

Originally posted by k9brian

However now I have a customer stating that he can add, change and delete other databases on the server?

What can I do to stop this?

You need to edit the config file supplied with phpMyAdmin - if you don't specify the database, the user will be able to see all other databases.

Changes are that you gave a copy of the config file which contained the root user id, with no database supplied. Make sure that his user id is used, and that his database is specified ... The phpMyAdmin documentation is quite clear on this.

rgrds,

Johan

Originally posted by afriq


You need to edit the config file supplied with phpMyAdmin - if you don't specify the database, the user will be able to see all other databases.

Changes are that you gave a copy of the config file which contained the root user id, with no database supplied. Make sure that his user id is used, and that his database is specified ... The phpMyAdmin documentation is quite clear on this.

rgrds,

Johan

Thanks I was thinking about doing it that way...but that means that I have to give each customer thier own copy of phpmyadmin....

can I use the advance authentication in phpmyadmin to let more than one user log into it and access only thier database?

Sorry if I wasn't clear the first time,

Try the following article ... central copy of phpMyAdmin for multiple users (http://articles.areontheweb.com/phpMyAdmin/)

I haven't done it myself yet - but this should point you in the right direction ...

That is possibly the ugliest page I've ever seen, I have a premodified version of phpMyAdmin that does the same thing if you want me to upload it, you can have it..

Originally posted by The Prohacker
That is possibly the ugliest page I've ever seen, I have a premodified version of phpMyAdmin that does the same thing if you want me to upload it, you can have it..

What's keeping you ;-)

www.virix.com.kg/phpMyAdmin.zip

Have at it, you shouldn't have to change anything in the config.inc.php... If you enter a wrong pw and user, it will show as line errors...

Originally posted by The Prohacker
Have a go at it, you shouldn't have to change anything in the config.inc.php... If you enter a wrong pw and user, it will show as line errors... [/B]

thanks - will give it a try ...

Here is the quick and dirty low-down for a single multiple-user installation of phpmyadmin:

(This of course assumes that phpmyadmin already works fine for root. If it doesn't, phpmyadmin isn't even set up, so read its INSTALL file.)

- Log in as root
- Access the 'mysql' database on the left, and click 'user' table
- Find and click "INSERT". It's kind of hiding, but it's there. If you can't find it, click "BROWSE" and then "INSERT NEW ROW."
- Enter the hostname (probably "localhost")
- Enter the username the database will be accessed as.
- For the Password field, select PASSWORD from the drop down box, and then type in the password to be used to access the database.
- Click Save.
- Click the "db" table of the "mysql" database.
- Click "INSERT" again, or "BROWSE" and then "INSERT NEW ROW."
- Enter the hostname (probably "localhost").
- Enter the database name.
- Enter the username that will access the database.
- Click "Yes" or "Y" for all the permissions (unless this user is specifically not allowed certain permissions -- if you aren't sure, select them all).
- Click Save.
- Click on "HOME" at the upper left corner.
- Create the new database.
- Log into your shell and run "mysqladmin -u root -p reload" and type in the password for root. This will make mysql notice the new user. This step is only required when adding a new user.
- Log out of phpmyadmin as root and try to log in as the new user you just created. If all went well, the login will succeed and the new user has access to his/her database only.

If that doesn't work, RTFM. :) It's quite tricky to get at first, but after doing it 50 times, it kind of comes natural. I hope I didn't miss anything!

Edited grammar, typing too fast today...

Besides phpMyAdmin, there is a product called "Netbuilder" that I found out about recently. It seems to be more sophisticated, and more user-friendly, than phpMyAdmin, but it is not free (I guess you can't have everything :) ).

I'm not sure how advanced of an offering you wanted, but if phpMyAdmin is not enough, or too difficult for your customers, Netbuilder might be a solution.

I found it at www.vansam.com.