Ubuntu LAMP from scratch
A quick guide to rolling an Apache/PHP/MYSQL webserver.
Starting with a default Ubuntu Server installation.
Install all the things…
$ sudo apt-get update
$ sudo apt-get upgrade
$ sudo apt-get install apache2 mysql-server mysql-client
$ sudo apt-get install php libapache2-mod-php php-mysql
Configure firewall…
$ sudo ufw allow 80/tcp
$ sudo ufw allow 443/tcp
Configure MySQL…
$ sudo mysql_secure_installation
$ sudo mysql -u root -p
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'thepassword';
mysql> FLUSH PRIVILEGES;
Install phpMyAdmin
$ sudo apt-get install phpmyadmin php-gettext
sudo phpenmod mbstring
Kick it
$ sudo systemctl restart apache2
Browse to http://server/phpmyadmin/ (all lowercase).
Problem?
Reconfigure the phpMyAdmin databases and restart apache2 again.$ sudo dpkg-reconfigure phpmyadmin