Installing mysql and phpmyadmin

Installing mysql and phpmyadmin

To install mysql run the command

sudo apt-get install mysql-server mysql-client php5-mysql

you will need to confirm the installation, and also set a root admin password for use by mysql

To install phpmyadmin:

1. Go to http://www.phpmyadmin.net
2. Download the zip file (I would suggest downloading to /home/pi

3. Extract the zip file and rename the directory to "phpmyadmin"
4. Copy the directory "phpmyadmin" to /var/www

You can now check to see that its working by going to http://raspberrypi/phpmyadmin/

In preparation for doing some stuff in python connected to mysql you will need to run the following commands

sudo apt-get install libmysqlclient18
and then
sudo apt-get install python-mysqldb