Re: [cobalt-users] Help Needed: High Level Overview of PHP and MySQL on

[johan@xxxxxxxxxx]

Rusty,

> QUESTION:
> What is the procedure/process for allowing users of a
> RaQ 4i to create php apps that use MySQL? 

Let's 1st assume that you know how to enable PHP (obviously in the GUI interface
whilst creating a new site).  And mySQL is installed?  Ok, now on to your
question ...

> The confusion I have is how to extend this
> functionality to clients I host on some of my Raq 4i
> servers? Since they dont have admin (or even shell
> access), how do they create the mysql database that
> their php app will supposedly use?

You'll have to create the mysql database for them, and forward the name, userid
and password to the client.  Only the root mysql user (not to be confused with
the Unix root user) can create databases (if I'm not mistaken).

There are a couple of options available when it comes to the creation of the
databases:

- use the mysql interface in a telnet or SSH session
- use phpMyAdmin (highly recommended)
- or use a script that will create the database and user id in one go (e-mail me
for more info, or go to http://webhostingtalk.com and search for similar posts
in the Cobalt RaQ forum). 

The latter is by far the easiest - it will also take care of the user
permissions, etc.

Hope this helps,

Johan Pretorius

http://host24.com







---------------------------------------------
This message was sent using M-Web Airmail.
http://airmail.mweb.co.za/