Setting up Apache, PHP, MySQL and PHPMyAdmin on Ubuntu 18.04

Hello and welcome to my first tutorial post here on Ti.

I know Ti isn't exactly a web development forum, but if any members are looking into PHP development sometime, I hope my tutorial on how to setup what's called a LAMP stack (Linux, Apache, MySQL, PHP) on Ubuntu 18.04 is useful.

Step #1: Open the terminal and type:

Quote:

---

sudo apt install lamp-server^

---

Step #2: Once Step 1 has finished, type

Quote:

---

sudo mysql_secure_installation

---

and follow the on-screen instructions to setup MySQL.

Step #3: Next we need to enter the MySQL Monitor

Quote:

---

sudo mysql

---

Step #4: Here we need to verify the root account plugin is currently set as auth_socket (which it is by default at the time of writing this tutorial), here we type:

Quote:

---

SELECT user,authentication_string,plugin,host FROM mysql.user;

---

Step #5: If it is set as auth_socket we need to change it to mysql_native_password using the following command, making sure to of course change the "password" with one of your choosing.

Quote:

---

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

---

Step #6 (optional): This step is entirely up to you, but if you want to verify Step 5 was successful you can re-enter the command from Step 4, this (if successful) should show the plugin for the root account changed to mysql_native_password.

Step #7: Here we need to flush the privileges then exit the MySQL Monitor

Quote:

---

FLUSH PRIVILEGES;

---

Quote:

---

exit

---

Step #8 (optional, but recommended for local web development):

Quote:

---

sudo apt install phpmyadmin

---

a prompt will appear asking to choose which web server is installed, press the [Space Bar] for apache2, then press the [Tab] key which will take you to the <OK> prompt, press [Enter] and wait for the next prompt which will be for db-config-common, here we just press the [Enter] key for <Yes> and enter the password used from Step #5.

Step #9: We need to give our self ownership of the http directory using the following command

Quote:

---

sudo chown -R username:username /var/www/html

---

where it says username twice that needs to be changed for the username of the account your using on Ubuntu.

Step #10: We're finished, here you can exit the terminal, open your favorite web browser and head to http://localhost/phpmyadmin/, login using the root account with the password from Step 5 and you should be logged in.

Good luck, happy coding, and thanks for reading my first tutorial.