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
Attachments: | phpmyadmin |