phpMyAdmin is a MySQL web administration tool, which allow us to administrate MySQL database in graphical interface (from your browser) and available for Ubuntu 11.04 (natty narwhal) or 10.10 (Maverick Meerkat) or 10.04 (Lucid Lynx) or any other Linux distros. Since phpMyAdmin is written in PHP (Hypertext Preprocessor (Surprised! it’s a recursive acronym), The most popular scripting language, used for server side processing); of course it’s an open source (and Free!) and cross platform application, so you can also use it on Windows NT based operating system such as Windows XP or 7; or Mac OS X.
phpMyAdmin is specially useful for beginners because it allows them to create, modify, delete or update – tables, field and rows, users permissions and settings etc in much simpler (as compared to command line interface) way. For Ubuntu phpmyadmin is the best (probably) tool for managing and controlling MySQL database.
What You can do with phpMyAdmin ?
- browse databases and tables
- “create, copy, rename, alter and drop” tables and databases
- perform table maintenance
- execute SQL statements/queries
- manage MySQL users and privileges
- search globally in databases
- create and read dumps of tables or databases …
Installing phpMyAdmin on Ubuntu 10.04/10.10/11.04
Open Terminal (CTRL+ALT+T) and type the following command(s) to install phpMyAdmin (on your computer running Ubuntu or other debian based Linux distribution). Remember you need to install MySQL and Apache first, see there – installing mysql on ubuntu 11.04 or install Apache server on ubuntu. or installing php on ubuntu; more simply install the LAMP (Linux+Apache+MySQL+PHP) package from synaptic package manager. Then phpmyadmin : –
sudo apt-get install phpmyadmin
Alternative Method : Open Synaptic package manager, search for ‘phpmyadmin’, check the box for installation and click on Apply button (don’t forget to select yes for dependencies, I mean dependent libraries or program) to install the selected programs.
Login to phpMyAdmin to start administrating MySQL
Open any browser such as Google Chrome or Mozilla Firefox and type the following URL in the address bar (or click here )
Then, you will get a window like this –
Next, enter the login information – i.e MySQL username and password
>> ‘root’ as username
>> ‘password’ as the password that you entered while installing MySQL
That’s all..Now you are ready to rock with phpMyAdmin.
Recommended References :