Share this page:
phpMyAdmin is a tool for managing MySQL servers using a web UI in your browser. It makes it possible to view and edit the contents of a MySQL database. phpMyAdmin is written in PHP, and it needs a web server and a MySQL database to be installed on a server in order to work. If these things haven't been installed on your server already, follow this tutorial on setting up a LAMP server.
Type this command to install phpMyAdmin:
The installer will prompt to see which web server needs to be configured. In this case, choose Apache.
Next, you will be prompted to see if you want the database to be automatically configured to work with phpMyAdmin. Choose 'yes'.
Choose a password that phpMyAdmin can use to connect to the database server. I used 'appassword':
Enter it again to confirm your password:
Apache's main configuration file needs to be edited in order to include settings from phpMyAdmin's configuration file. Open it in nano with this command:
Scroll down to the end of the file and add the following line:
Restart Apache with this command:
Now visit the phpMyAdmin home page in a browser by visiting http://server's IP address/phpmyadmin/, in my case this is http://192.168.1.50/phpmyadmin/. Log in with the root password for the database server, mypassword. Now you can begin exploring phpMyAdmin:
Click on the phpmyadmin database on the left hand side of the page and look at the tables used by phpMyAdmin: