Creating MySQL Databases for multiple Hosts or Domains

[martinroman]

Hi,
I use a Linux/Apache/MySQL "Virtual Server" where I can host up to 100 domains with or without MySQL access.
My problem is that I need to create two MySQL databases for domain abc.com and xyz.com through a Telnet session and I do not know where to start.
For domain abc.com I need to create a database called "catalog" with user=abc2003, password=esz30066. For domain xyz.com I need to create a database called "shopcart", user=xyzadmin, password=5655dmxw.

I have read that I have to use ports for each domain but I would like to see or receive a step by step example to solve this issue.

MySQL documentation is abundant but I could not find info about this issue in particular.

Thanks,

Martin

 

[sleipnir214]

First, telnet to the box.

Then run the command "mysql". That will take you into an interactive command-line app to issue commands to MySQL. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!