Re: How setup MYSQL server to sup****t 2 different databases

forget it
#mysqladmin create xxx
is all I had to do

craig wrote:
> 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 sup****ting a www.blog.
> 
> I want to sup****t another www.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?