Table of Contents
The database manager: phpMyAdmin
← All database/MySQL tutorials
After having installed a database server such as MySQL, you'll need to administer your website's various databases. phpMyAdmin is the reference to manage MySQL databases via a web interface.
1. Installation
Launch the following command in SSH:
aptitude install phpmyadmin
The installation will begin, packets will be downloaded and installed, following which a window like the one below will ask on what kind of Apache server you wish phpMyAdmin to be installed.
Select the one corresponding to your server and submit.
It's important to remember to secure your “root” user for your MySQL server, since it will be possible to connect to phpMyAdmin with this user.
2. Connecting to the interface
To connect to your phpMyAdmin interface, go to the following address:
http://www.example.com/phpmyadmin or http://your_servers_ip/phpmyadmin