Ubuntu 18.04 phpMyAdmin
Installation Process
LAMP Stack
The Linux Apache MySQL and PHP Stack, better known as LAMP, provides all the services for hosting a website using the programming language PHP. Depending on the system, MariaDB might substitute MySQL.
The simplest way to install LAMP is with the all-in-one package via 'tasksel'; if not already installed, run 'sudo apt install tasksel'.
- In a terminal type 'sudo tasksel' and press <Enter>;
- Navigate down to 'LAMP server' and press <Enter>;
- The 'Installing packages' process will download and install the packages for you;
- On Ubuntu 16.04 you will get prompted for a MySQL 'root' user password;
- On Ubuntu 18.04, once installation is complete, run 'sudo mysql_secure_installation' to specify a MySQL 'root' user password;
- Answer "Y";
- Select "1" for Medium or "2" for Strong as suits your security needs;
- Enter password and then re-enter to confirm;
- Answer "Y" to password strength (or otherwise specify a new password that matches the security requirements selected);
- Answer "Y" to remote anonymous user accounts;
- Select appropriate answer depending on whether you wish to connect to MySQL from an external connection or not;
- Select whether you want to remove the 'test' database or not;
- Answer "Y" to reload the privileges;