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:Step #2: Once Step 1 has finished, typesudo apt install lamp-server^and follow the on-screen instructions to setup MySQL.sudo mysql_secure_installation
Step #3: Next we need to enter the MySQL MonitorStep #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:sudo mysqlStep #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.SELECT user,authentication_string,plugin,host FROM mysql.user;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.ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
Step #7: Here we need to flush the privileges then exit the MySQL MonitorFLUSH PRIVILEGES;Step #8 (optional, but recommended for local web development):exita 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.sudo apt install phpmyadmin
Step #9: We need to give our self ownership of the http directory using the following commandwhere it says username twice that needs to be changed for the username of the account your using on Ubuntu.sudo chown -R username:username /var/www/html
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.