PhpMyAdmin: Difference between revisions
m (phpMyAdmin < 5.0.2 has SQL injection vulnerabilities) |
(replace /etc/init.d with rc-service) |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
[ | [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. | ||
== Install lighttpd, PHP and MySql == | == Install lighttpd, PHP and MySql == | ||
| Line 10: | Line 10: | ||
{{Cmd|<nowiki>/usr/bin/mysql_install_db --user=mysql | {{Cmd|<nowiki>/usr/bin/mysql_install_db --user=mysql | ||
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>}} | ||
| Line 21: | Line 21: | ||
{{Cmd|cd /usr/share/webapps | {{Cmd|cd /usr/share/webapps | ||
wget | wget https://files.phpmyadmin.net/phpMyAdmin/5.2.1/phpMyAdmin-5.2.1-all-languages.tar.gz}} | ||
Unpack the archive and remove the archive | Unpack the archive and remove the archive | ||
{{Cmd|tar zxvf phpMyAdmin-5. | {{Cmd|tar zxvf phpMyAdmin-5.2.1-all-languages.tar.gz | ||
rm phpMyAdmin-5. | rm phpMyAdmin-5.2.1-all-languages.tar.gz}} | ||
Rename the folder | Rename the folder | ||
{{Cmd|mv phpMyAdmin-5. | {{Cmd|mv phpMyAdmin-5.2.1-all-languages phpmyadmin}} | ||
Change the folder permissions | Change the folder permissions | ||
{{Cmd|chmod -R | {{Cmd|chmod -R 755 /usr/share/webapps/}} | ||
Create a symlink to the ''phpmyadmin'' folder | Create a symlink to the ''phpmyadmin'' folder | ||
| Line 42: | Line 42: | ||
== Log on your phpMyAdmin == | == Log on your phpMyAdmin == | ||
Browse to: | 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
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
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.