{"id":5177,"date":"2014-07-01T04:36:04","date_gmt":"2014-06-30T20:36:04","guid":{"rendered":"https:\/\/webhostinggeeks.com\/howto\/?p=5177"},"modified":"2023-09-18T15:59:42","modified_gmt":"2023-09-18T15:59:42","slug":"how-to-install-phpmyadmin-on-ubuntu-14-04","status":"publish","type":"post","link":"https:\/\/webhostinggeeks.com\/howto\/how-to-install-phpmyadmin-on-ubuntu-14-04\/","title":{"rendered":"How to Install phpMyAdmin on Ubuntu 14.04"},"content":{"rendered":"

phpMyAdmin is an open-source software tool, written in PHP, designed to manage and administer MySQL databases via web browsers. It is one of the most widely used tools for managing MySQL databases. To ensure its optimal functioning, you need to install and configure Apache, PHP, and the PHP MySQL.<\/p>\n

This guide will walk you through the steps to install phpMyAdmin on an Ubuntu<\/a> 14.04 virtual private server (VPS) and dedicated server. Before we begin, it’s assumed that you have already prepared your Apache web server and MySQL database server. If not, you can refer to our guide on Apache<\/a> and dedicated server<\/a> to get started.<\/p>\n

Step 1: Installing phpMyAdmin<\/h2>\n
\r\nehowstuff@ubuntu14:~$ sudo apt-get install phpmyadmin -y\r\n<\/pre>\n
This command installs phpMyAdmin on your server. The ‘-y’ option is used to automatically answer ‘yes’ to the prompts that may appear during the installation process.<\/p>\n
Step 2: Configuring Apache<\/h2>\n
\r\nehowstuff@ubuntu14:~$ sudo vi \/etc\/phpmyadmin\/apache.conf\r\n<\/pre>\n
This command opens the Apache configuration file for phpMyAdmin. You need to add the following configuration:<\/p>\n
\r\n# phpMyAdmin default Apache configuration\r\nAlias \/phpmyadmin \/usr\/share\/phpmyadmin\r\n<Directory \/usr\/share\/phpmyadmin>\r\n Options FollowSymLinks\r\n DirectoryIndex index.php\r\n Require ip 127.0.0.1 192.168.0.0\/24\r\n <IfModule mod_php5.c>\r\n AddType application\/x-httpd-php .php\r\n php_flag magic_quotes_gpc Off\r\n php_flag track_vars On\r\n php_flag register_globals Off\r\n php_admin_flag allow_url_fopen Off\r\n php_value include_path .\r\n php_admin_value upload_tmp_dir \/var\/lib\/phpmyadmin\/tmp\r\n php_admin_value open_basedir \/usr\/share\/phpmyadmin\/:\/etc\/phpmyadmin\/:\/var\/lib\/phpmyadmin\/:\/usr\/share\/php\/php-gettext\/:\/usr\/share\/javascript\/\r\n <\/IfModule>\r\n<\/Directory>\r\n<\/pre>\n
This configuration sets up the necessary parameters for phpMyAdmin to function correctly with Apache.<\/p>\n
Step 3: Restarting Apache<\/h2>\n
\r\nehowstuff@ubuntu14:~$ sudo \/etc\/init.d\/apache2 restart\r\n<\/pre>\n
This command restarts the Apache server to apply the changes made in the configuration file.<\/p>\n
Step 4: Accessing phpMyAdmin<\/h2>\n
You can now access phpMyAdmin by navigating to “http:\/\/IP_address\/phpmyadmin\/” in your web browser and logging in with your MySQL credentials.<\/p>\n
\"phpmyadmin<\/p>\n
Commands Mentioned<\/h2>\n