MySQL   view as chat

(Part of the detailed Step-by-Step Installation Guide for setting up the Server)

Provides database back-end for LAMP applications

Security: configured to use a different user account for each application - this account can only access that application's database(s). User account has same name as application.

sudo apt-get install mysql-server

Configure root password:

mysqladmin -u root password notthisbutsomethingsecure

Install phpMyAdmin to allow for easier administration:

sudo apt-get install phpmyadmin libapache2-mod-php5
sudo vi /etc/apache2/sites-available/phpmyadmin

(paste in contents of attached file)

sudo ln -s /etc/apache2/sites-available/phpmyadmin /etc/apache2/sites-enabled
sudo /etc/init.d/apache2 restart

Continue with the rest of the detailed Step-by-Step Installation Guide

Last edited by: Fran
Attachments: phpmyadmin