PhpMyAdmin: Difference between revisions

Revision as of 11:10, 5 July 2011

What is phpMyAdmin?

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

Set up phpMyAdmin on Alpine Linux

This document will be a very quick c/p guide to setup phpMyAdmin on Alpine linux. What we will setup is the following:

Lighttpd with PHP
Mysql
phpMyAdmin

Install lighttpd, PHP and MySql

Basic Installation

For installing the additional packages first activate community packages and update the package index

Install the required packages:

# apk add lighttpd php82 fcgi php82-cgi

Configure Lighttpd

Edit lighttpd.conf (/etc/lighttpd/lighttpd.conf) and uncomment the line:

Contents of /etc/lighttpd/lighttpd.conf

...
include "mod_fastcgi.conf"
...

Edit mod_fastcgi.conf (/etc/lighttpd/mod_fastcgi.conf), find and change /usr/bin/php-cgi to /usr/bin/php-cgi82.

Contents of /etc/lighttpd/mod_fastcgi.conf

...
"bin-path" => "/usr/bin/php-cgi82" # php-cgi
...

Start `lighttpd` service and add it to default runlevel

# rc-service lighttpd start # rc-update add lighttpd default

Install extra packages:

apk add mysql mysql-client php-mysql php-mysqli

Configuring MySql

/usr/bin/mysql_install_db --user=mysql /etc/init.d/mysql start && rc-update add mysql default /usr/bin/mysqladmin -u root password 'password'

Installing phpMyAdmin

Download

cd /tmp wget http://ufpr.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.3/phpMyAdmin-3.4.3-all-languages.tar.gz

Unpack

tar zxvf phpMyAdmin-3.4.3-all-languages.tar.gz

Change Folder Name

mv phpMyAdmin-3.4.3-all-languages /etc/phpmyadmin

Change Folder Permissions

chmod -R 777 /etc/phpmyadmin/

Make Symlink to the phpMyAdmin folder

ln -s /etc/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin

Log on your phpMyAdmin

Browse to: http://WEBSERVER_IP_ADDRESS/phpmyadmin and logon to phpMyAdmin using your MySQL user and password.

@@ Line 16: / Line 16: @@
 Install extra packages:
- apk add mysql mysql-client php-mysql php-mysqli
+{{Cmd|apk add mysql mysql-client php-mysql php-mysqli}}
 == Configuring MySql ==
- /usr/bin/mysql_install_db --user=mysql
+{{Cmd|<nowiki>/usr/bin/mysql_install_db --user=mysql
- /etc/init.d/mysql start && rc-update add mysql default
+/etc/init.d/mysql start && rc-update add mysql default
- /usr/bin/mysqladmin -u root password 'password'
+/usr/bin/mysqladmin -u root password 'password'</nowiki>}}
 == Installing phpMyAdmin ==
-'''Install phpMyAdmin'''
 Download
- cd /tmp
+{{Cmd|cd /tmp
- wget http://ufpr.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.3.5/phpMyAdmin-3.3.5-all-languages.tar.gz
+wget http://ufpr.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.4.3/phpMyAdmin-3.4.3-all-languages.tar.gz}}
 Unpack
- tar zxvf phpMyAdmin-3.3.5-all-languages.tar.gz
+{{Cmd|tar zxvf phpMyAdmin-3.4.3-all-languages.tar.gz}}
 Change Folder Name
- mv phpMyAdmin-3.3.5-all-languages /etc/phpmyadmin
+{{Cmd|mv phpMyAdmin-3.4.3-all-languages /etc/phpmyadmin}}
-Change Folder Persmissions
+Change Folder Permissions
-  chmod -R 777 /etc/phpmyadmin/
+{{Cmd|chmod -R 777 /etc/phpmyadmin/}}
 Make Symlink to the phpMyAdmin folder
-  ln -s /etc/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin
+{{Cmd|ln -s /etc/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin}}
 == Log on your phpMyAdmin ==
-Browse to: http://WEBSERVER_IP_ADDRESS/phpmyadmin and logon to phpMyAdmin using MySQL user and password.
+Browse to: http://WEBSERVER_IP_ADDRESS/phpmyadmin and logon to phpMyAdmin using your MySQL user and password.
-And enjoy this nice and useful tool.
-== License ==
-'''phpMyAdmin License'''
-phpMyAdmin is released under GNU General Public License, version 2.
-This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.
-This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.