I own a site where I sell a PHP script that works with a backend MySQL database. So customers will typically login to their cPanel, Plesk, Ensim, whatever and create a new MySQL database. Then they will add the db values to the cfg file, and then upload their PHP files to their server. And finally, they will point their browser to the setup.php file and it will create the tables for them. Simple, right?

Well, I have a new customer who has paid for the "installed" version. So I need to set it up for him. Problem is that this customer does not appear to have a control panel supplied to him by his host. When he asked his host where he logs in to manage his database, they replied:

There is no url to get to the database, it is a MySQL database.
The password is xxxx, dbname is the database name. To access the database, you'll need to write a script or run
mysql on the UNIX command line.

I'm the worst when it comes to Linux. So how do I do this? I should mention that they appear to provide one database for him, no more. So I assume I have to add the tables to the existing db? And then just run my setup.php file? And if I have to do it from the command line, don't I need shell access?

I'm so confused... :confused: :confused:

Vito

Vito,

If you need easy access to the DB I'd look into uploading a copy of phpMyAdmin:

http://phpmyadmin.sourceforge.net

Provide the DB name and password and you'll have full access to run queries, backup, and modify data.

Alternately you can create the database through a php file, most popular forum softwares like phpBB do this nowadays. Little more hassle but would provide a nice addition to your setup.php file :)

Sincerely,

-Matt

This is the wrong forum for this question (I know, but I need to solve the problem now), but could I pay you to write that file? I agree, it would be a good addition to the product...

If you can write it for me, please send me a PM.

Vito

If he has only one database, wouldn't all you need to do is put the info into the config file as usual? If he can't create a new database anyway, then you would just use the existing one like you said.

Oh, OK. Like I said, this stuff just escapes me for some reason.

All right, that makes sense. So in my config file I assume I just add the database name, user and password. I will try that.

Thanks.

Vito

See PM. I'm not much of a pay-for-work guy, but we could work something out :)

-Matt

use TELNET