Graphically Managing MYSQL using phpMyAdmin

Since Joomla is a content management system or CMS for short, most of site settings are captured during the Joomla installation. During the Joomla Installation, you will be sequestered to supply MYSQL database information.

I thought I would share this real quick note on database management and MYSQL. After successfully managing to create users, databases, and grants, I was directed by a friend of mine to http://www.phpmyadmin.net/home_page/index.php.

For those of you who have a predilection towards Oracle, phpMyAdmin is the equivalent of Oracle Enterprise Manager. The interface allows you to quickly navigate through your database and associated objects. Enjoy!

How to Modify a Database Connection Setting in Joomla After the Initial Installation

On initial installation of Joomla, the installation guide requires the user to enter the database information. The joomla database configuration information that was captured is stored in the root of the joomla installtion folder in a file called configuration.php.

File Location
[joomla home]/configuration.php

Database Settings Section
/* Database Settings */
var $dbtype = 'mysql';
var $host = 'localhost';
var $user = 'jdemo';
var $password = 'jdemo';
var $db = 'jdemo';
var $dbprefix = 'jos_';

Incidentally, there are a number of other settings, such as ftp, mail, etc...

MYSQL Command Line Joomla Database Installation Tutorial

When installing Joomla, you will be prompted for database information. Here are the following steps that you need to complete in order launch joomla. In the following example, I will demonstrate create a database, user and grants.

1. Create user and assign Password
mysql> create user 'jdemo'@'localhost' identified by 'jdemo';
Query OK, 0 rows affected (0.00 sec)

2. Create Database
mysql> create database jdemo;
Query OK, 1 row affected (0.04 sec)

3. Grants
mysql> grant all on jdemo.* to 'jdemo'@'localhost';
Query OK, 0 rows affected (0.03 sec)

4. Validation
Close or exit out of mysql. Then, open a new instance of mysql using the following commands:

mysql -u jdemo -p
Enter password: *****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 753
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>


5. Joomla GUI Admin Database Set-up during Installation

After I validated the login worked, I proceeded with a fresh Joomla install. Based on the demonstration above, the following information should be used when installing Joomla.