While many people need the functionality of a database management system like MySQL, they may feel complicated interacting with the system pop-ups from the MySQL prompt.
phpMyAdmin was created so that users can interact with MySQL through a web interface. In this tutorial, we’ll learn how to install phpMyAdmin so that you can easily use it to control your databases from an Ubuntu 16.04 Linux system, with this tutorial you will learn how to install and secure phpMyAdmin step by step.
1. Update all of your Linux packages, running the below code on “Terminal”.
sudo apt-get update
2. Install “phpMyAdmin” by running the below command on “Terminal”.
sudo apt-get install phpmyadmin php-mbstring php-gettext
Press Y and click enter to continue.
3. The “Terminal”, will start to prompt for configuration, starting with asking which apache do you want, select “apache2”.
4. During the installation process, another prompt will appear asking to use “dbconfig-common” to setup the database, click “Yes” on it.
5. Then you have to enter a password for Administrator’s database.
The installation process puts phpMyAdmin Apache configuration file inside the “/etc/apache2/conf-enabled/ directory”, where it will be automatically read.
6. Run the below 2 commands, to prepare for the next steps.
sudo phpenmod mcrypt
sudo phpenmod mbstring
7. Restart your Apache server by the below code.
sudo systemctl restart apache2
8. Now you can access the web interface of your PHP by entering your IP or domain name on the web-browser followed by “/phpmyadmin”, for example “127.x.x.1/Avoiderrors.net/phpmyadmin”.
9.You can now log into the interface using “root” username and the administrative password you set up during MySQL installation process, Enjoy your new PHPMyAdmin server.
You now have phpMyAdmin configured well and ready to use on your Ubuntu 16.04 Linux server, Using this interface, you can simply create databases and users and tables, etc.., and do the usual operations such as deleting and editing structures and data.