phpMyAdmin is a great web-based database management tool. It’s a free PHP application that makes managing MySQL or MariaDB databases easy even for new users and students. Instead of running database queries from the command line terminal, users can use phpMyAdmin via a web browser to manage the database.
For new students and users, phpMyAdmin provides a great starting point to managing databases. With this tool, users can quickly and easily create and delete databases, import and export, and do almost all tasks one can do via the command line terminal.
This brief tutorial is going to show students how to easily install phpMyAdmin on Ubuntu 17.04
Step 1: Update Ubuntu
To get started, logon to the Ubuntu server as a root user. Then run the commands below to update the server. It’s always recommended to update Ubuntu before installing packages.
sudo apt-get update && sudo apt-get dist-upgrade
Step 2: Install PHP, Apache2, MySQL
phpMyAdmin is a PHP based tool. It requires PHP, a web server as well as a database server.. usually MySQL or MariaDB and Apache2. To the commands below to install PHP and MySQL and Apache2.
sudo apt-get install apache2 php mysql-server
During the installation, you will be prompted to create and confirm a new password for MySQL root user. This is the account that you’ll use to manage the database server.
┌────────────────────┤ Configuring mysql-server-5.7 ├─────────────────────┐ │ While not mandatory, it is highly recommended that you set a password │ for the MySQL administrative "root" user. │ │ If this field is left blank, the password will not be changed. │ │ New password for the MySQL "root" user: <Ok> _______________________________________________________________________
Continue below to installing phpMyAdmin
Step 3: Install phpMyAdmin
Now that the required packages are installed, go and install phpMyAdmin. To do that, run the commands below
sudo apt-get install phpmyadmin
During the installation of phpmyadmin, you’ll be prompted to select a webserver to use with the tool. Please choose apache2 and continue.
┌────────────────────────┤ Configuring phpmyadmin ├─────────────────────────┐ │ Please choose the web server that should be automatically configured to │ run phpMyAdmin. │ │ Web server to reconfigure automatically: │ │ [*] apache2 │ [ ] lighttpd <Ok>
When prompted with the screen below during the installation, choose Yes.
┌────────────────────────┤ Configuring phpmyadmin ├─────────────────────────┐ │ The phpmyadmin package must have a database installed and configured │ before it can be used. This can be optionally handled with │ dbconfig-common. │ │ If you are an advanced database administrator and know that you want to │ perform this configuration manually, or if your database has already │ been installed and configured, you should refuse this option. Details on │ what needs to be done should most likely be provided in │ /usr/share/doc/phpmyadmin. │ │ Otherwise, you should probably choose this option. │ Configure database for phpmyadmin with dbconfig-common? │ │ <Yes> <No> │ └───────────────────────────────────────────────────────────────────────────┘
You’ll be prompted to create and confirm phpMyAdmin root user password. Please do.
When you’re done, you should be able to access the tool by browsing to the server hostname or IP address followed by phpmyadmin. Example below.
You should then see the login page for phpMyAdmin.
This post shows users an easy way to manage MySQL databases with phpMyAdmin. It’s a great way for new users and students to manage MySQL databases without learning the complex queries that are associated with database management.
So, if you need complete basic MySQL tasks, try phpMyAdmin.
You may also like this post: