phpMyAdmin Installation

[Nevil]

Hello FreeVPS Community,

in this tutorial I will teach you how to really install phpMyAdmin on any Linux Distro.


Let's start:

1. Open the official download page of phpMyAdmin which should always be: http://www.phpmyadmin.net/home_page/downloads.php

2. Select the package you want and click on it, and copy the "direct link" from Sourceforge.

3. Now in the terminal use this command:

Code:

wget "download link here"

Example: wget http://downloads.sourceforge.net/project...rror=voxel

4. After it has finished downloading use this command:

Code:

tar xvfz phpMyAdmin-3.4.9-english.tar.gz

*phpMyAdmin-3.4.9-english.tar.gz is only an example, you need to enter the name of the archive you downloaded!

5. After it has extracted all files use this command to rename the folder:

Code:

mv phpMyAdmin-3.4.9-english /var/www/html/phpmyadmin

*The path of your web server might be different than this example path.

6. Now cd to the folder of phpMyAdmin with this command:

Code:

cd /var/www/html/phpmyadmin

*Adjust the path to your webserver path!

7. Make a copy of the phpMyAdmin config file:

Code:

cp config.sample.inc.php config.inc.php

8. Modify the following to make it work online (accessable from your Internet and world wide):

Code:

$cfg['Servers'][$i]['auth_type']=’cookie’;

to

Code:

$cfg['Servers'][$i]['auth_type']=’http’;

9. Restart Apache, Lighttpd or whatever server technology you use.

10. You can now access it from your site http://domain.com/phpmyadmin


This is only the installation, be advised and secure it!

I redistributed it from my forum: http://forum.singul4rity.com/thread-241.html (Registration required to see tutorials section)

[Cody_Maverak]

This is a nice tutorial!

BTW, you don't have to do step 8. My phpMyAdmin on my webserver runs without that change just fine on the web. You also need to enter in a blowfish string of random letters and numbers for cookie encryption.

[kiwiboom]

Nice tutorial Murderwrecker! It doesn't work smoothly on Scientific Linux for me though, but I believe I made a mistake so I'll try to fix that manually.

[lifeone168]

If you can please add how to setting with phpmyadmin's config file in this tutorial.
The actually i have problem with this part too.

Thank for sharing good tutorial.

[Nevil]

Huh? The config file?

There is a part how to make it work in the tutorial from step 7.

The rest is up to you, edit entries to what you need them.

[tyaakow]

I so far used ubuntu server, and in oneiric I just ran
sudo apt-get install phpmyadmin (provided you have lamp stack installed),
it worked like a charm.
Haven't tried on other distros.

[Nevil]

Your command also works on Debian. For RHEL/CentOS/Fedora the command is "yum -y install phpmyadmin".

The big problem is that the installed versions are out of date mostly. PhpMyAdmin is more or less a unzip (extract) and use application/script.

I recommend installing by hand.

[Retry]

Nice tutorial, was kinda hard to do with this in Debian, cause I messed up a php-mysql thingy.
But nevertheless got it working.

[ReadyToGo]

You to can upload the PHP files by FTP to the directory, simple....

[Nevil]

Why would someone do this when he can wget the archive much faster from Sourceforge?

Where's the sense of transfering over 100 files via FTP?