blob: 7896b2a8c0d522e7074965e492bed92304fbc000 [file] [log] [blame]
Title: phpMyAdmin Installation & Configuration
Notice: Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements. See the NOTICE file
distributed with this work for additional information
regarding copyright ownership. The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License. You may obtain a copy of the License at
.
http://www.apache.org/licenses/LICENSE-2.0
.
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
<div class="docnote">
phpMyAdmin is a free and optional tool which allows MySQL to be administered using a web
browser. It makes administering the VCL database easier. This tool can be installed on
the VCL web server.
</div>
1. Download phpMyAdmin
a. Check the version of PHP installed on the web server (you may need to perform step
1a of [VCL 2.3.2 Web Code Installation][1] to install httpd and php first):
:::BashLexer
php -v
* Use phpMyAdmin 2.x if the version of PHP is < 5.2:
<pre class="docnote">
PHP 4.3.2 (cgi), Copyright (c) 1997-2003 The PHP Group
</pre>
* Use phpMyAdmin 3.x if the version of PHP is 5.x:
<div><pre class="docnote">
PHP 5.3.11 (cli) (built: May 8 2012 15:53:27)
</pre></div>
b. Download the appropriate version of phpMyAdmin from:
<pre>
[http://www.phpmyadmin.net/home_page/downloads.php][2] for 3.x series
[http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/][3] for 2.x series
</pre>
* Extract the phpMyAdmin package:
:::BashLexer
tar xf phpMyAdmin-2.11.11.3-english.tar.bz2
* Move the phpMyAdmin directory to the web server directory:
:::BashLexer
mv phpMyAdmin-2.11.11.3-english /var/www/html/phpmyadmin
* Follow the installation instructions in: /var/www/html/phpmyadmin/Documentation.txt
<pre class="docnote">
The instructions must be followed in order to secure phpMyAdmin
</pre>
If you receive 403-Forbidden errors after installing phpMyAdmin, the problem is likely caused by SELinux. Run the following command to correct the problem:
<pre class="docnote">
chcon -R -t httpd_sys_content_t /var/www/html/phpmyadmin
</pre>
* Configure the phpMyAdmin-VCL Table relationships:
After following the documentation on creating the phpMyAdmin Linked-tables
infrastructure, you can set up the VCL table relationships. The phpmyadmin.sql file is
provided in the mysql directory in the Apache VCL source code. It will add entries to the
pma_table_info table in the phpmyadmin database. These entries cause corresponding
information to be displayed when you hover over a value in the VCL database.
Import the SQL file into the phpmyadmin database:
:::BashLexer
mysql phpmyadmin < apache-VCL-2.3.2/mysql/phpmyadmin.sql
[1]: VCL232InstallGuide.html
[2]: http://www.phpmyadmin.net/home_page/downloads.php
[3]: http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/