Step 2a Raspberry Pi MySQL & PHPMyAdmin

We need to install Raspberry Pi with  MySQL & PHPMyAdmin extension to the web server so we can have the visual representation of MySQL

ins short For anyone who doesn’t know PhpMyAdmin is a free tool that has been designed to allow for easy administration of MYSQL.

If you’re unfamiliar with MySQL, this is a great way to get learning it. MySQL is a relational database management system and allows you to store & maintain data. It is one of the world’s most popular relational database system and is commonly included in most LAMP stacks.(XAMPP,ZAMPP etc.)

 

Installing Raspberry Pi MySQL

Firstly let’s install the MySQL server onto the Raspberry Pi.

You will be prompted to enter a password for the root user. Make sure you write this down as we will need to use this to access the MYSQL server and connect PHPMyAdmin to it.