{"id":2345,"date":"2019-09-15T11:13:06","date_gmt":"2019-09-15T11:13:06","guid":{"rendered":"https:\/\/ekozel.com\/?p=2345"},"modified":"2020-11-28T05:47:07","modified_gmt":"2020-11-28T10:47:07","slug":"install-debian-10-with-php-7-and-mysql-8-phpmyadmin","status":"publish","type":"post","link":"https:\/\/ekozel.com\/2019\/09\/15\/install-debian-10-with-php-7-and-mysql-8-phpmyadmin\/","title":{"rendered":"Install Debian 10 with PHP 7 and MySQL 8 + phpMyAdmin"},"content":{"rendered":"\n

sudo: command not found<\/h2>\n\n\n\n

After installation of Debian 10 and you try to install a package you might get the message: bash: sudo: command not found<\/em><\/p>\n\n\n\n

To install sudo, run the following:<\/p>\n\n\n\n

su<\/code><\/p>\n\n\n\n

apt-get install sudo<\/code><\/p>\n\n\n\n

Give the user the right to run sudo<\/p>\n\n\n\n

usermod -aG sudo username<\/code><\/p>\n\n\n\n

Log out the user to refresh the group permissions of the user<\/p>\n\n\n\n

Reference: https:\/\/chewett.co.uk\/blog\/477\/sudo-command-not-found-debian-fixed\/<\/p>\n\n\n\n

Install the firewall ufw on Debian<\/h2>\n\n\n\n

Run the package installer:<\/p>\n\n\n\n

sudo apt-get install ufw<\/code><\/p>\n\n\n\n

Enable the firewall<\/p>\n\n\n\n

sudo ufw enable<\/code><\/p>\n\n\n\n

Reference: https:\/\/www.tecmint.com\/how-to-install-and-configure-ufw-firewall\/<\/p>\n\n\n\n

Install the Apache Web Server<\/h2>\n\n\n\n

Update the local package index to reflect the latest upstream changes:<\/p>\n\n\n\n

sudo apt update<\/code><\/p>\n\n\n\n

Install the apache2 package<\/p>\n\n\n\n

sudo apt install apache2<\/code><\/p>\n\n\n\n

Configure the firewall for port 80<\/p>\n\n\n\n

sudo ufw allow in 'WWW Full'<\/code><\/p>\n\n\n\n

On your local computer you can check \u2018localhost\u2019 in the browser to see if Apache is running.<\/p>\n\n\n\n

To test the install from another computer find the IP address of the server with:<\/p>\n\n\n\n

ip addr show<\/code><\/p>\n\n\n\n

Reference: https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-install-the-apache-web-server-on-debian-9<\/p>\n\n\n\n

Install MYSQL 8.0<\/h2>\n\n\n\n

MySQL 8.0 packages are available on the official MySQL Dev apt repository<\/p>\n\n\n\n

sudo apt -y install wget
wget https:\/\/repo.mysql.com\/\/mysql-apt-config_0.8.13-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb<\/code><\/p>\n\n\n\n

sudo apt update
sudo apt -y install mysql-server<\/code><\/p>\n\n\n\n

Reference: https:\/\/computingforgeeks.com\/how-to-install-mysql-8-0-on-debian\/<\/p>\n\n\n\n

Install PHP7<\/h2>\n\n\n\n

sudo apt update 
sudo apt upgrade<\/code><\/p>\n\n\n\n

sudo apt install php libapache2-mod-php php-gd php-mysqlnd<\/code><\/p>\n\n\n\n

Create a PHP Info page to see if it is all working.<\/p>\n\n\n\n

sudo nano \/var\/www\/html\/info.php<\/code><\/p>\n\n\n\n

Type in:<\/p>\n\n\n\n

<?php phpinfo(); ?><\/code><\/p>\n\n\n\n

Enter ctrl+x, y and enter<\/p>\n\n\n\n

In your browser go to your https:\/\/webserver\/info.php<\/p>\n\n\n\n

Install phpMyAdmin<\/h2>\n\n\n\n

Log in to MySQL<\/p>\n\n\n\n

mysql -u root -p<\/code><\/p>\n\n\n\n

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'PASSWORD';<\/code><\/p>\n\n\n\n

Update server’s package index<\/p>\n\n\n\n

sudo apt update<\/code><\/p>\n\n\n\n

sudo apt install php-mbstring php-zip php-gd<\/code><\/p>\n\n\n\n

wget https:\/\/files.phpmyadmin.net\/phpMyAdmin\/4.9.0.1\/phpMyAdmin-4.9.0.1-all-languages.tar.gz<\/code><\/p>\n\n\n\n

tar xvf phpMyAdmin-4.9.0.1-all-languages.tar.gz<\/code><\/p>\n\n\n\n

sudo mv phpMyAdmin-4.9.0.1-all-languages\/ \/usr\/share\/phpmyadmin<\/code><\/p>\n\n\n\n

sudo mkdir -p \/var\/lib\/phpmyadmin\/tmp<\/code><\/p>\n\n\n\n

sudo chown -R www-data:www-data \/var\/lib\/phpmyadmin<\/code><\/p>\n\n\n\n

sudo cp \/usr\/share\/phpmyadmin\/config.sample.inc.php \/usr\/share\/phpmyadmin\/config.inc.php<\/code><\/p>\n\n\n\n

sudo nano \/usr\/share\/phpmyadmin\/config.inc.php<\/code><\/p>\n\n\n\n

Add a 32 character blowfish_secret<\/p>\n\n\n\n

$cfg['blowfish_secret'] = 'RANDOMSTRINGHERE'; \/* YOU MUST FILL IN THIS FOR COOKIE AUTH! *\/<\/code><\/p>\n\n\n\n

At the bottom of the file add<\/p>\n\n\n\n

$cfg['TempDir'] = '\/var\/lib\/phpmyadmin\/tmp';<\/code><\/p>\n\n\n\n

Configuring Apache to Serve phpMyAdmin<\/h3>\n\n\n\n

Create new file<\/p>\n\n\n\n

sudo nano \/etc\/apache2\/conf-available\/phpmyadmin.conf<\/code><\/p>\n\n\n\n

Add the following code:<\/p>\n\n\n\n

# phpMyAdmin default Apache configuration\n\nAlias \/phpmyadmin \/usr\/share\/phpmyadmin\n\n<Directory \/usr\/share\/phpmyadmin>\n    Options SymLinksIfOwnerMatch\n    DirectoryIndex index.php\n\n    <IfModule mod_php5.c>\n        <IfModule mod_mime.c>\n            AddType application\/x-httpd-php .php\n        <\/IfModule>\n        <FilesMatch \".+\\.php$\">\n            SetHandler application\/x-httpd-php\n        <\/FilesMatch>\n\n        php_value include_path .\n        php_admin_value upload_tmp_dir \/var\/lib\/phpmyadmin\/tmp\n        php_admin_value open_basedir \/usr\/share\/phpmyadmin\/:\/etc\/phpmyadmin\/:\/var\/lib\/phpmyadmin\/:\/usr\/share\/php\/php-gettext\/:\/usr\/share\/php\/php-php-gettext\/:\/usr\/share\/javascript\/:\/usr\/share\/php\/tcpdf\/:\/usr\/share\/doc\/phpmyadmin\/:\/usr\/share\/php\/phpseclib\/\n        php_admin_value mbstring.func_overload 0\n    <\/IfModule>\n    <IfModule mod_php.c>\n        <IfModule mod_mime.c>\n            AddType application\/x-httpd-php .php\n        <\/IfModule>\n        <FilesMatch \".+\\.php$\">\n            SetHandler application\/x-httpd-php\n        <\/FilesMatch>\n\n        php_value include_path .\n        php_admin_value upload_tmp_dir \/var\/lib\/phpmyadmin\/tmp\n        php_admin_value open_basedir \/usr\/share\/phpmyadmin\/:\/etc\/phpmyadmin\/:\/var\/lib\/phpmyadmin\/:\/usr\/share\/php\/php-gettext\/:\/usr\/share\/php\/php-php-gettext\/:\/usr\/share\/javascript\/:\/usr\/share\/php\/tcpdf\/:\/usr\/share\/doc\/phpmyadmin\/:\/usr\/share\/php\/phpseclib\/\n        php_admin_value mbstring.func_overload 0\n    <\/IfModule>\n\n<\/Directory>\n\n# Authorize for setup\n<Directory \/usr\/share\/phpmyadmin\/setup>\n    <IfModule mod_authz_core.c>\n        <IfModule mod_authn_file.c>\n            AuthType Basic\n            AuthName \"phpMyAdmin Setup\"\n            AuthUserFile \/etc\/phpmyadmin\/htpasswd.setup\n        <\/IfModule>\n        Require valid-user\n    <\/IfModule>\n<\/Directory>\n\n# Disallow web access to directories that don't need it\n<Directory \/usr\/share\/phpmyadmin\/templates>\n    Require all denied\n<\/Directory>\n<Directory \/usr\/share\/phpmyadmin\/libraries>\n    Require all denied\n<\/Directory>\n<Directory \/usr\/share\/phpmyadmin\/setup\/lib>\n    Require all denied\n<\/Directory><\/code><\/pre>\n\n\n\n
sudo a2enconf phpmyadmin.conf<\/code><\/p>\n\n\n\n
sudo systemctl reload apache2<\/code><\/p>\n\n\n\n
Log into phpMyAdmin: https:\/\/localhost\/phpmyadmin<\/p>\n\n\n\n
Create database phpmyadmin<\/p>\n\n\n\n
Click operations tab – follow links to create tables for phpmyadmin database<\/p>\n\n\n\n
Source: https:\/\/www.digitalocean.com\/community\/tutorials\/how-to-install-phpmyadmin-from-source-debian-10<\/a><\/p>\n\n\n\n
Install VSTFTPD<\/h2>\n\n\n\n
sudo apt update
sudo apt install vsftpd<\/code><\/p>\n\n\n\n
sudo nano \/etc\/vsftpd.conf<\/code><\/p>\n\n\n\n
Set the following in the vsftpd.conf file:<\/p>\n\n\n\n
anonymous_enable=NO
local_enable=YES
local umask=022
userlist_enable=YES
userlist_file=\/etc\/vsftpd.user_list
userlist_deny=NO<\/p>\n\n\n\n
Add ufw exceptions<\/p>\n\n\n\n
sudo ufw allow 20:21\/tcp
sudo ufw allow 30000:31000\/tcp
sudo systemctl restart vsftpd<\/code><\/p>\n\n\n\n
Add the users that are allowed to access vsftpd to the vsftpd.userlist (one per line)<\/p>\n\n\n\n
sudo nano \/etc\/vsftpd.user_list<\/code><\/p>\n\n\n\n
The following is ONLY for dev environment<\/em><\/strong><\/p>\n\n\n\n
Add current user to group that owns \/var\/www\/html folder<\/p>\n\n\n\n
sudo usermod -a -G GROUPNAME USERNAME<\/code><\/p>\n\n\n\n
Reboot system<\/p>\n\n\n\n
Change group permissions to rwx<\/p>\n\n\n\n
sudo chmod -R g+rwx \/var\/ww\/html<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"
sudo: command not found After installation of Debian 10 and you try to install a package you might get the message: bash: sudo: command not found To install sudo, run the following: su apt-get install sudo Give the user the right to run sudo usermod -aG sudo username Log out the user to refresh the group […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"templates\/template-full-width.php","format":"standard","meta":[],"categories":[1],"tags":[],"yoast_head":"\nInstall Debian 10 with PHP 7 and MySQL 8 + phpMyAdmin - Ewout Alexander Kozel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ekozel.com\/2019\/09\/15\/install-debian-10-with-php-7-and-mysql-8-phpmyadmin\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"kozel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ekozel.com\/2019\/09\/15\/install-debian-10-with-php-7-and-mysql-8-phpmyadmin\/\",\"url\":\"https:\/\/ekozel.com\/2019\/09\/15\/install-debian-10-with-php-7-and-mysql-8-phpmyadmin\/\",\"name\":\"Install Debian 10 with PHP 7 and MySQL 8 + phpMyAdmin - Ewout Alexander Kozel\",\"isPartOf\":{\"@id\":\"https:\/\/ekozel.com\/#website\"},\"datePublished\":\"2019-09-15T11:13:06+00:00\",\"dateModified\":\"2020-11-28T10:47:07+00:00\",\"author\":{\"@id\":\"https:\/\/ekozel.com\/#\/schema\/person\/6a1492e8788678b531eefdd0ac4661cf\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ekozel.com\/2019\/09\/15\/install-debian-10-with-php-7-and-mysql-8-phpmyadmin\/\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ekozel.com\/#website\",\"url\":\"https:\/\/ekozel.com\/\",\"name\":\"Ewout Alexander Kozel\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ekozel.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/ekozel.com\/#\/schema\/person\/6a1492e8788678b531eefdd0ac4661cf\",\"name\":\"kozel\",\"sameAs\":[\"https:\/\/kozel.wpengine.com\"],\"url\":\"https:\/\/ekozel.com\/author\/kozel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Install Debian 10 with PHP 7 and MySQL 8 + phpMyAdmin - Ewout Alexander Kozel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ekozel.com\/2019\/09\/15\/install-debian-10-with-php-7-and-mysql-8-phpmyadmin\/","twitter_misc":{"Written by":"kozel","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ekozel.com\/2019\/09\/15\/install-debian-10-with-php-7-and-mysql-8-phpmyadmin\/","url":"https:\/\/ekozel.com\/2019\/09\/15\/install-debian-10-with-php-7-and-mysql-8-phpmyadmin\/","name":"Install Debian 10 with PHP 7 and MySQL 8 + phpMyAdmin - Ewout Alexander Kozel","isPartOf":{"@id":"https:\/\/ekozel.com\/#website"},"datePublished":"2019-09-15T11:13:06+00:00","dateModified":"2020-11-28T10:47:07+00:00","author":{"@id":"https:\/\/ekozel.com\/#\/schema\/person\/6a1492e8788678b531eefdd0ac4661cf"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ekozel.com\/2019\/09\/15\/install-debian-10-with-php-7-and-mysql-8-phpmyadmin\/"]}]},{"@type":"WebSite","@id":"https:\/\/ekozel.com\/#website","url":"https:\/\/ekozel.com\/","name":"Ewout Alexander Kozel","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ekozel.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ekozel.com\/#\/schema\/person\/6a1492e8788678b531eefdd0ac4661cf","name":"kozel","sameAs":["https:\/\/kozel.wpengine.com"],"url":"https:\/\/ekozel.com\/author\/kozel\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/posts\/2345"}],"collection":[{"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/comments?post=2345"}],"version-history":[{"count":0,"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/posts\/2345\/revisions"}],"wp:attachment":[{"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/media?parent=2345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/categories?post=2345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ekozel.com\/wp-json\/wp\/v2\/tags?post=2345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}