Posted by craig on 08/28/05 04:01

This is on a linux FC3 system
To create the first database here is what I did:
Under linux I created a user "mysql"
As a root user I executed from a command line:
#/usr/local/bin/mysql_installdb -user=mysql

This created two database in my usr/local/var
(1) mysql & (2) test

To run the mysql (server) I use the following command
#/usr/local/bin/mysqd_safe --usr=mysql --log &

This database is supporting a php blog.

I want to support another php blog on the same machine.

Before I tried anything I wanted to see if I could get some feed back on
how I would do this.

I created another linux user I called "wwt"
If I follow the methods used above then this will have me running two
mysql servers (yes/no) is this even possible or even make sense?
If not what should I be doing?

[Back to original message]