phpMyAdmin allows you to manage MySQL Servers easily from any popular web browser. Instead of connecting to MySQL server from the command line or console every time you wish to make a change, use your web browser and connect to it, then make the change there. It will allow you edit, drop, modify database tables and data within your browser.
Most online hosts will make this available to you when managing websites or blogs online. It’s a very efficient and reliable tool to manage your WordPress blog database with, and this brief tutorial is going to show you how to install it in Ubuntu 12.04.
- Install phpMyAdmin in Ubuntu 12.04
- Manage your database server (MySQL)
To get started, press Ctrl – Alt – T on your keyboard to open the terminal. When it opens, run the commands below to install it.
sudo apt-get install phpMyAdmin
Then choose the web server you want to associate with this tool. It will mostly be apache2
After that, select ‘Yes’ to allow phpMyAdmin package create a database.
When prompted for the database administrator’s password, enter it. If you don’t know it, then you must reset it.
On the next screen, will you be prompted to create a password for phpMyAdmin user which was just created. Enter and confirm one. It can be the same as your database admin password.
After installing, open any web browser and connect to it by typing http://localhost/phpmyadmin.
Login and enjoy!