PhpMyAdmin: Difference between revisions

From Alpine Linux
No edit summary
(replace /etc/init.d with rc-service)
 
(15 intermediate revisions by 4 users not shown)
Line 1: Line 1:
== What is phpMyAdmin? ==
[https://www.phpmyadmin.net 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.  
 
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 ==
== Install lighttpd, PHP and MySql ==
Line 21: Line 10:


{{Cmd|<nowiki>/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
rc-service mysql start && rc-update add mysql default
/usr/bin/mysqladmin -u root password 'password'</nowiki>}}
/usr/bin/mysqladmin -u root password 'password'</nowiki>}}


== Installing phpMyAdmin ==
== Installing phpMyAdmin ==


Download
Create a directory named {{Path|webapps}}
 
{{Cmd|cd /tmp
wget http://files.directadmin.com/services/all/phpMyAdmin/phpMyAdmin-3.5.2.2-all-languages.tar.gz}}


Unpack
{{Cmd|mkdir -p /usr/share/webapps/}}
Download the source code


{{Cmd|tar zxvf phpMyAdmin-3.5.2.2-all-languages.tar.gz}}
{{Cmd|cd /usr/share/webapps
wget https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-all-languages.tar.gz}}


Create folder
Unpack the archive and remove the archive


{{Cmd|mkdir /usr/share/webapps/phpmyadmin/ -p }}
{{Cmd|tar zxvf phpMyAdmin-5.2.1-all-languages.tar.gz
rm phpMyAdmin-5.2.1-all-languages.tar.gz}}


Move to Folder
Rename the folder


{{Cmd|mv phpMyAdmin-3.5.2.2-all-languages/* /usr/share/webapps/phpmyadmin}}
{{Cmd|mv phpMyAdmin-5.2.1-all-languages phpmyadmin}}
   
   
Change Folder Permissions
Change the folder permissions


{{Cmd|chmod -R 777 /usr/share/webapps/phpmyadmin/}}
{{Cmd|chmod -R 755 /usr/share/webapps/}}


Make Symlink to the phpMyAdmin folder
Create a symlink to the ''phpmyadmin'' folder


{{Cmd|ln -s /usr/share/webapps/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin}}
{{Cmd|ln -s /usr/share/webapps/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin}}
Line 53: Line 42:
== Log on your phpMyAdmin ==
== Log on your phpMyAdmin ==


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


[[Category:PHP]]
[[Category:PHP]]
[[Category:SQL]]
[[Category:SQL]]

Latest revision as of 09:53, 17 November 2023

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.

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 rc-service mysql start && rc-update add mysql default /usr/bin/mysqladmin -u root password 'password'

Installing phpMyAdmin

Create a directory named webapps

mkdir -p /usr/share/webapps/

Download the source code

cd /usr/share/webapps wget https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-all-languages.tar.gz

Unpack the archive and remove the archive

tar zxvf phpMyAdmin-5.2.1-all-languages.tar.gz rm phpMyAdmin-5.2.1-all-languages.tar.gz

Rename the folder

mv phpMyAdmin-5.2.1-all-languages phpmyadmin

Change the folder permissions

chmod -R 755 /usr/share/webapps/

Create a symlink to the phpmyadmin folder

ln -s /usr/share/webapps/phpmyadmin/ /var/www/localhost/htdocs/phpmyadmin

Log on your phpMyAdmin

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