In the previous post we show you how to install LAMP, now is the time to be able to integrate a database manager, the popular phpMyAdmin. We’ll show you the simple steps you need to follow to install.
Let’s talk about phpmyadmin, it’s the most popular tool to manage our database MySQL and it is best opportunity to take some advantages we have our web server ready and running. phpmyadmin is handled in a web interface, so you have the facility to manage many tasks more easily, without having to know dificult commands. Allows you from creating the table schema to back it up.
To install phpmyadmin you only need to run the following command:
sudo apt-get update sudo apt-get install phpmyadmin
Important, this step will ask you to select the web server where the application would be installed, it is mandatory that you select with the spacebar “Apache” Server or your designate, not doing this will cause the files wont’t be copied correctly and then can not find the installed application.
Is recomendabe enable mcrypt php function for this run on the console:
sudo phpenmod mcrypt
Now that’s installed and everything should be running we must restart the Apache server:
sudo service apache2 restart
Ready! Now you can connect to your database from a web interface. You can do it in the link:
http: // localhost / phpmyadmin