The best way would be to create a database for each Joomla
installation. (That is what I do.)
I find this method to be the safest.
1) Before installing Joomla, create a MySQL database for your new
Joomla install.
2) Create a MySQL user and give that user permissions
3) Install Joomla. During the install process give the name, user, and
password for the database you created in steps 1 and 2.
You can use PHPMyAdmin to create the MySQL database or use commands like
these:
mysql> create database joomlasite;
mysql> use joomlasite;
mysql> grant all on joomlasite to "joomlauser" identified by
"joomlapassword";
Using this method you can use the default "jos_" prefix for the joomla
tables.
You can have separate Joomla installations pointing to a common database
by giving separate installations different table prefixes. (The first
could be "jos1_", the second "jos2_", etc.
This is useful if your hosting agent only allows you a minimal number of
databases. Since you are self hosting, you can make as many databases
as you need.
Paul Peacock wrote:
so here's a basic question:
if I want to have mySQL manage multiple joomla sites on the same
server, do I need to setup multiple databases. If so, what is the
best way to manage that.
On Tue, Sep 28, 2010 at 12:11 PM, McKay, Curtis <cmc...@bths201.org
<mailto:cmc...@bths201.org>> wrote:
This list… ;-)
Anyway, couple comments:
Unless you have zero experience with linux I’d probably recommend
using a linux distro for your Joomla box since most websites, this
list, and others offering help use linux and therefore you might
be able to get better help if your setup matches to majority of
installs.
For Joomla you’ll need php installed, since you’ll have php and
mysql, installing phpmyadmin to do your mysql management is pretty
much a no brainer.
Curtis McKay
Network Administrator
Belleville Township High School District 201
cmc...@bths201.org <mailto:cmc...@bths201.org>
*From:* tech-geeks-boun...@tech-geeks.org
<mailto:tech-geeks-boun...@tech-geeks.org>
[mailto:tech-geeks-boun...@tech-geeks.org
<mailto:tech-geeks-boun...@tech-geeks.org>] *On Behalf Of *Paul
Peacock
*Sent:* Tuesday, September 28, 2010 12:05 PM
*To:* Tech-Geeks Mailing List
*Subject:* [tech-geeks] mysql help
I am getting started working with mySQL for a new installation of
Joomla in a Windows server. What are my best resources for help?
Thanks.
Paul Peacock
Lexington High School
| Subscription info at http://www.tech-geeks.org |
------------------------------------------------------------------------
| Subscription info at http://www.tech-geeks.org |
| Subscription info at http://www.tech-geeks.org |
