Install phpmyadmin in Ubuntu 9.04

PhpMyAdmin is a graphical user interface tool to manage mysql database. It's very popular and used by many web hosting providers around the world. This tutorial is a guide on how to install phpmyadmin in Ubuntu 9.04. Prerequisite is you need to have mysql server already installed in your system. The instructions are in step by step, however, it's not in proper order. You need to read it first and make your own notes after finished reading it.

Open command line terminal and install phpMyAdmin using apt-get:

[email protected]:~# apt-get install phpmyadmin
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
phpmyadmin: Depends: php5-mcrypt but it is not going to be installed
E: Broken packages

Let's check why php5-mcrypt is not going to be installed. We can do this by trying to install php5-mcrypt using apt-get:

[email protected]:~# apt-get install php5-mcrypt
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
php5-mcrypt: Depends: libltdl3 (>= 1.5.2-2) but it is not installable
E: Broken packages

Now we got libltdl3 (>= 1.5.2-2) but it is not installable dependencies message.

All right now something is not right. If you get the same dependencies messages as above, let's check everything required to install phpmyadmin. First check whether we have php5 installed in our Ubuntu system:

[email protected]:~# apt-get install php5

For a complete php5 installation in Ubuntu, you can check the following tutorial: How to install php5 in Ubuntu 9.04.

Next step is we need to install libltdl3 package. Get it from Debian website. When you finished download the file, install it using dpkg command. Here is the command example:

[email protected]:~# dpkg --install /home/kkcjlab/Desktop/libltdl3_1.5.26-4+lenny1_i386.deb
(Reading database ... 198567 files and directories currently installed.)
Preparing to replace libltdl3 1.5.26-4+lenny1 (using .../libltdl3_1.5.26-4+lenny1_i386.deb) ...
Unpacking replacement libltdl3 ...
Setting up libltdl3 (1.5.26-4+lenny1) ...

Processing triggers for libc6 ...
ldconfig deferred processing now taking place
[email protected]rver:~#

We can now install php5-mcrypt which is needed to install phpmyadmin.

[email protected]:~# apt-get install php5-mcrypt
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed:
php5-mcrypt
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 12.9kB of archives.
After this operation, 45.1kB of additional disk space will be used.
WARNING: The following packages cannot be authenticated!
php5-mcrypt
Install these packages without verification [y/N]? Y
Get:1 http://packages.dotdeb.org stable/all php5-mcrypt 5.2.13-0.dotdeb.1 [12.9kB]
Fetched 12.9kB in 1s (9006B/s)
Selecting previously deselected package php5-mcrypt.
(Reading database ... 198466 files and directories currently installed.)
Unpacking php5-mcrypt (from .../php5-mcrypt_5.2.13-0.dotdeb.1_i386.deb) ...
Setting up php5-mcrypt (5.2.13-0.dotdeb.1) ...

[email protected]:~#

Everything is ready to begin the phpmyadmin installation. Use apt-get command to install phpmyadmin as in the example below:

Note:
During installation process, you need to configure phpmyadmin password and mysql password. See the screenshots below phpmyadmin installation example.

[email protected]:~# apt-get install phpmyadmin
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
dbconfig-common
The following NEW packages will be installed:
dbconfig-common phpmyadmin
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 4101kB of archives.
After this operation, 15.4MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Get:1 http://my.archive.ubuntu.com jaunty-updates/main dbconfig-common 1.8.40ubuntu1 [488kB]
Get:2 http://my.archive.ubuntu.com jaunty-updates/universe phpmyadmin 4:3.1.2-1ubuntu0.2 [3613kB]
Fetched 4101kB in 41s (98.9kB/s)
Preconfiguring packages ...
Selecting previously deselected package dbconfig-common.
(Reading database ... 198469 files and directories currently installed.)
Unpacking dbconfig-common (from .../dbconfig-common_1.8.40ubuntu1_all.deb) ...
Selecting previously deselected package phpmyadmin.
Unpacking phpmyadmin (from .../phpmyadmin_4%3a3.1.2-1ubuntu0.2_all.deb) ...
Processing triggers for man-db ...
Setting up dbconfig-common (1.8.40ubuntu1) ...

Setting up phpmyadmin (4:3.1.2-1ubuntu0.2) ...
dbconfig-common: writing config to /etc/dbconfig-common/phpmyadmin.conf

Creating config file /etc/dbconfig-common/phpmyadmin.conf with new version

Creating config file /etc/phpmyadmin/config-db.php with new version
granting access to database phpmyadmin for [email protected]: success.
verifying access for [email protected]: success.
creating database phpmyadmin: success.
verifying database phpmyadmin exists: success.
populating database via sql... done.
dbconfig-common: flushing administrative password
* Reloading web server config apache2 [ OK ]

[email protected]:~#

Here are phpmyadmin package configuration screenshots:

Configuring phpmyadmin

Configuring database's administrative user:

Configuring database admiistrative user image

Provide password for phpmyadmin to register with the database server:

Image

Confirm password for phpmyadmin:

Confirm password for phpmyadmin image

That's all. To test the newly installed phpmyadmin, open web browser and type localhost/phpmyadmin in the url. You should get the phpmyadmin login page as screenshot below:

phpmyadmin login page image

phpmyadmin login page

That's all.

Add new comment