PhpMyAdmin

From SlackWiki
Jump to: navigation, search

phpMyAdmin

Install

Download phpMyAdmin from phpMyAdmin.net and put it in /usr/src/sourcepkg. Extract and add a symbolic link for later use in our config.

cd /var/www
tar jxvf /usr/src/source/phpMyAdmin-XXX.tar.bz2
ln -sf phpMyAdmin-XXX phpMyAdmin

apache1 running under Slackware <12

Make a directory for the config files and create the phpMyAdmin config file for apache.

mkdir /etc/apache/conf.d
touch /etc/apache/conf.d/phpMyAdmin.conf
vi /etc/apache/conf.d/phpMyAdmin.conf

Add alias to apache (like at apache-2) and add these lines to phpMyAdmin.conf

Alias /phpMyAdmin /var/www/phpMyAdmin

<Location /phpMyAdmin>
#    Order deny,allow
#    Deny from all
#    Allow from 127.0.0.1
#    Allow from ::1
#    Allow from .example.com
</Location>

and append to the httpd.conf

echo 'Include /etc/apache/conf.d/phpMyAdmin.conf' >> /etc/apache/httpd.conf

httpd (apache2) under Slackware 12

Create the phpMyAdmin config file and edit it.

touch /etc/httpd/phpMyAdmin.conf
jed /etc/httpd/phpMyAdmin.conf

Add an alias to httpd (since the phpMyAdmin directory isn't in var/www/htdocs) and change the Directory rules.

#
# phpMyAdmin - MySQL Database Administration Tool
#

Alias /phpMyAdmin /var/www/phpMyAdmin

<Directory /var/www/phpMyAdmin>
#  AllowOverride None
#  Options None
  Order allow,deny
  Allow from all
</Directory>

Edit httpd.conf to use our new config and append at the end.

# Uncomment the following line to enable phpMyAdmin support:
#
Include /etc/httpd/phpMyAdmin.conf

Configuration

Restart apache

/etc/apache/rc.httpd restart

Go to your browser and open http://localhost/phpMyAdmin

If you have set a password for your MySQL root user, you will have an error

Edit /var/www/phpMyAdmin/config.inc.php:

Change to something unique:

$cfg['blowfish_secret'] = ;

Change:

$cfg['Servers'][$i]['auth_type']     = 'config';

To:

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

refresh the browser

Finished.