Install phpMyAdmin on Debian, Ubuntu & Mint with Apache Web Server
Installing phpMyAdmin in Ubuntu 14.04 / Debian 7.6/ Linux Mint 17
Follow the below steps to install phpMyAdmin to above listed Linux distribution.
phpMyAdmin is a free opensource software which helps user to manage/administrate of MySQL database in Web. It supports MySQL, MariaDB and Drizzle.
phpMyAdmin Features
- Web based Interface
- Most of MySQL features are supported
- Browse/create/modify/Drop databases, tables
- Execute & Edit SOL-statement
- Manage MySQL users and privileges
- Manage stored procedures and triggers
- Import/Export data from CSV and SQL
- Export data to various formats such as CSV, SQL, XML, PDF, etc,..
- Administering multiple servers
- For more details about Features, visit phpMyAdmin official Features page
- phpMyAdmin home page
1) Update your system upto date
Use the below commands to keep your system upto date.
[email protected]:~$ sudo apt-get update && upgrade
2) phpMyAdmin installation
Use the below command to install phpMyAdmin.
[email protected]:~$ sudo apt-get install phpMyAdmin
3) Web Server Selection
Use UP/DOWN arrow mark to Choose your Web Server then hit Space Bar to toggle, then press Tab and hit Space Bar to move forward.
4) Configuring Database for phpMyAdmin
By default it is highlighting Yes to configure new database for phpMyAdmin, then hit Space Bar to move forward.
5) Creating Database for phpMyAdmin
Enter your MySQL root Password to create a new database for phpMyAdmin, then hit Space Bar to move forward.
6) Setting up phpMyAdmin password
Create the password for phpMyAdmin to access over the web, then hit Space Bar to move forward.
7) Confirming phpMyAdmin password
Re-Enter the password once again to confirm the phpMyAdmin password, then hit Space Bar to move forward.
8) Accessing phpMyAdmin
Open your web browser and navigate to http://localhost/phpmyadmin or http://your-server-ip-address/phpmyadmin or http://127.0.0.1/phpmyadmin and Enter your database password to access it.
Now, i can manage all my MySQL databases using phpMyAdmin.
We are preparing all articles in-depth to understand by all level/stage Linux administrators. If the article is useful for you, then please spend less than a minute to share your valuable comments in our commenting section.
Please stay tune with us…Good Luck.