Since managing a MySQL database through a command line is tedious we will be installing a web-based GUI so we can access MySQL through any web browser on any computer.
On many Unix machines you’d have to go to the phpMyAdmin homepage and download the files there, decompress them and set up a config files before you could get to managing your database. If you’re setting up several machines to work in a cluster you have better things to do with your time. This is why I love Debian/Ubuntu distrobutions.
apt-get install phpmyadmin
During the install process you will be asked which version of Apache you are running. Ubuntu Server Edition uses Apache 2.2, so it wont be automatically configured for you. After the install process completes you will need to configure Apache 2.2, so in your favourite text editor open up /etc/apache2/apache2.conf and search for the word include. Add a new line next to its first match like this:
Include /etc/phpmyadmin/apache.conf
Save the file, exit to your command line and restart Apache with the following command:
/etc/init.d/apache2 restart
Your phpMyAdmin installation is now ready to use. Point your browser to http://domain/phpmyadmin/ and log in with your mySQL username and password. It’s that simple!
A seasoned Senior Solutions Architect with 18 years of experience in technology design and implementation. Renowned for innovative solutions and strategic insights, he excels in driving complex projects to success. Outside work, he is a passionate fisherman and fish keeper, specializing in planted tanks.