Apache, php, mySQL and phpMyAdmin install on Debian

See also here for Slackware configuration.

To install and configure apache, MySQL and phpMyAdmin

1st, we need to install some stuff...

UPDATE: Get install scripts here [requires password]

Install Apache

sudo apt install wget 

sudo apt install apache2 

Check status;

systemctl status apache2

Install php

sudo apt install php php-cgi php-mysqli php-pear php-mbstring php-gettext libapache2-mod-php php-common php-phpseclib php-mysql -y

php-gettext is questionable (needs checking)

Check php version;

php --version

Install mysql or mariadb

sudo apt install mariadb-server mariadb-client -y

Check status;

systemctl status mariadb

Now to secure MariaDB;

sudo mysql_secure_installation

answer as follows;

 Set root password? [Y/n] – y

 Remove anonymous users? [Y/n] – y
 Disallow root login remotely? [Y/n] – y
 Remove test database and access to it? [Y/n] – y
 Reload privilege tables now? [Y/n] – y

NOTE: To enable connecting from a remote host, we must either comment out bind-address in the my.cnf file or whichever file contains the [mysqld] section.

On Debian, this was found to be /etc/mysql/mariadb.conf.g/50-server.cnf

This used to be a matter of commenting out SKIP="--skip-networking" in a similar config file or in the case of my Slackware installs, it would have resided in the start up script /etc/rc.d/rc.mysql

Create a new DB user;

Firstly, login to database;

sudo mysql -u root

If your root user has a password, do;

sudo mysql -u root -p

CREATE DATABASE 'DB_name';

SHOW DATABASES;

To add a user;

CREATE USER 'user'@localhost IDENTIFIED BY 'password';

SELECT User FROM mysql.user;

GRANT ALL PRIVILEGES ON *.* TO 'user'@localhost IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON 'DB_name'.* TO 'user'@localhost;

FLUSH PRIVILEGES;

SHOW GRANTS FOR 'user'@localhost;

To remove a user;

DROP USER 'user'@localhost;

See my post here 

and also

https://packages.debian.org/search?keywords=libmysql%2B%2B-dev&searchon=names&suite=all&section=all

for information on libmysql++-dev or /usr/include/mysql++.h

Download and install phpMyAdmin

wget -P Downloads https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.tar.gz

keyring thing if that floats your boat and all that;

 wget -P Downloads https://files.phpmyadmin.net/phpmyadmin.keyring

 cd Downloads

 gpg --import phpmyadmin.keyring

 wget -P Downloads https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.tar.gz.asc

 cd Downloads [may not be required]

 gpg --verify phpMyAdmin-latest-all-languages.tar.gz.asc

sudo mkdir /var/www/html/phpMyAdmin

cd Downloads [may not be required]

sudo tar xvf phpMyAdmin* --strip-components=1 -C /var/www/html/php*

sudo cp /var/www/html/phpMyAdmin/config.sample.inc.php /var/www/html/phpMyAdmin/config.inc.php

sudo vim /var/www/html/phpMyAdmin/config.inc.php

Find $cfg['blowfish_secret'] = ''; and edit it adding a password like;

$cfg['blowfish_secret'] = 'my_password';

It's also worth noting that if the database is running on an IP that's not 127.0.0.1 then we should also change this in the config.inc.php file

 

sudo chmod 644 /var/www/html/phpMyAdmin/config.inc.php

sudo chown -R www-data:www-data /var/www/html/php*

I also like to rename config.sample.inc.php

mv /var/www/html/phpMyAdmin/config.sample.inc.php /var/www/html/phpMyAdmin/config.sample.inc.OLD.php

There was an issue on Debian whereby I could login to phpmyadmin and see the database tables but could not actually see any of the data, even though the tables contained data. when running a query against said tables, there was an error, similar to Connection for controluser as defined in your configuration failed.

This was resolved by running;

 

 dfgk-reconfigure phpmyadmin 

 

source

Finally restart Apache:

sudo systemctl restart apache2

---

Source