Erik: Copy from old

Erik — Sat, 06 Jun 2009 21:21:37 GMT

Copy from old

New page

= phpMyAdmin =

== Install ==
Download ''phpMyAdmin'' from [http://www.phpmyadmin.net phpMyAdmin.net] and put it in ''/usr/src/sourcepkg''.
Extract and add a symbolic link for later use in our config.

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

=== apache1 running under Slackware <12 ===
Make a directory for the config files and create the phpMyAdmin config file for apache.

<pre>
mkdir /etc/apache/conf.d
touch /etc/apache/conf.d/phpMyAdmin.conf
vi /etc/apache/conf.d/phpMyAdmin.conf
</pre>

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

<pre>
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>
</pre>

and append to the httpd.conf

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

=== httpd (apache2) under Slackware 12 ===
Create the phpMyAdmin config file and edit it.

<pre>
touch /etc/httpd/phpMyAdmin.conf
jed /etc/httpd/phpMyAdmin.conf
</pre>

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

<pre>
#
# 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>
</pre>

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

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

== Configuration ==
Restart apache
<pre>
/etc/apache/rc.httpd restart
</pre>

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.

[[Category:Tutorials]]

PhpMyAdmin - Revision history

Erik: Copy from old