Difference between revisions of "PhpMyAdmin"

From Alpine Linux
Jump to: navigation, search
m (update to phpmyadmin 4.1.8)
m (Installing phpMyAdmin: update)
Line 21: Line 21:
  
 
{{Cmd|cd /usr/share/webapps
 
{{Cmd|cd /usr/share/webapps
wget http://files.directadmin.com/services/all/phpMyAdmin/phpMyAdmin-4.1.8-all-languages.tar.gz}}
+
wget http://files.directadmin.com/services/all/phpMyAdmin/phpMyAdmin-4.3.8-all-languages.tar.gz}}
  
 
Unpack the archive and remove the archive
 
Unpack the archive and remove the archive
  
{{Cmd|tar zxvf phpMyAdmin-4.1.8-all-languages.tar.gz
+
{{Cmd|tar zxvf phpMyAdmin-4.3.8-all-languages.tar.gz
rm phpMyAdmin-4.1.8-all-languages.tar.gz}}
+
rm phpMyAdmin-4.3.8-all-languages.tar.gz}}
  
 
Rename the folder
 
Rename the folder
  
{{Cmd|mv phpMyAdmin-4.1.8-all-languages phpmyadmin}}
+
{{Cmd|mv phpMyAdmin-4.3.8-all-languages phpmyadmin}}
 
   
 
   
 
Change the folder permissions
 
Change the folder permissions

Revision as of 07:18, 30 January 2015

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

For installing the additional packages first activate community packages:

vi /etc/apk/repositories

Uncomment the following:

http://pkg.example.com/alpine/v3.11/community

Update the packagelist:

apk update

Install the additional packages:

apk add lighttpd php7-common php7-iconv php7-json php7-gd php7-curl php7-xml php7-mysqli php7-imap php7-cgi fcgi php7-pdo php7-pdo_mysql php7-soap php7-xmlrpc php7-posix php7-mcrypt php7-gettext php7-ldap php7-ctype php7-dom

Configure Lighttpd

Edit lighttpd.conf

vi /etc/lighttpd/lighttpd.conf

Uncomment line:

include "mod_fastcgi.conf"


Edit mod_fastcgi.conf

vi /etc/lighttpd/mod_fastcgi.conf

Edit the section:

/usr/bin/php-cgi

To:

/usr/bin/php-cgi7

Start lighttpd service and add to needed 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

Create a directory named webapps

mkdir -p /usr/share/webapps/

Download the source code

cd /usr/share/webapps wget http://files.directadmin.com/services/all/phpMyAdmin/phpMyAdmin-4.3.8-all-languages.tar.gz

Unpack the archive and remove the archive

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

Rename the folder

mv phpMyAdmin-4.3.8-all-languages phpmyadmin

Change the folder permissions

chmod -R 777 /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: http://WEBSERVER_IP_ADDRESS/phpmyadmin and logon to phpMyAdmin using your MySQL user and password.