How to Install PHPMyadmin on an Apache 2 Server
Apache Server running on Ubuntu Linux is one of the most popular free web server platforms available today and PHP is quickly gaining popularity as a programming language for web applications. PhpMyAdmin is a tool for managing the PHP environment on your web server and, while it is moderately challenging to install, it can be done with common Linux commands.
Other People Are Reading
Instructions
-
-
1
Update Ubuntu Linux by issuing the following command at the prompt:
sudo apt-get update
This will update your Ubuntu server with the most current software available.
-
2
Download and install the Apache 2 software by issuing the following command at the prompt:
sudo apt-get install apache2
This will locate the Apache 2 server software and install it for you.
-
-
3
Install PHP5 and the Apache PHP modules with the following command:
Sudo apt-get install php5 libapache2-mod-php5
-
4
Install MySQL server with the following command:
sudo apt-get install mysql-server mysql-client php5-mysql
This installs MySQL server, MySQL client and the PHP-mysql module. MySQL is installed with root as the user and no password.
-
5
To install phpMyAdmin, issue the following command at the prompt:
sudo apt-get install phpmyadmin
-
6
Include phpMyAdmin on your Apache 2 server by editing the file /etc/apache2/apache2.conf with the following command:
sudo gedit /etc/apache2/apache2.conf
Add the following line in the file and save it:
Include /etc/phpmyadmin/apache.conf
-
7
Change your MySQL root password with the following procedure:
sudo mysql --u root --p
This will put you into MySQL command mode so you can set up the password for root. Issue the following commands at the "mysql>" prompt:
use mysql;
update user set password=PASSWORD("NEWPASSWORD") where User='root';
flush privileges;
quit
-
8
Restart your Apache server with the following command:
sudo /etc/init.d/apache2 restart
-
9
Start a browser session and key "localhost/phpmyadmin" in the address bar and press "Enter." This should bring up the PhpMyAdmin screen. Enter "root" as the user. Enter the password you created and click on the "Go" button. This will take you to the phPMyAdmin administrative panel.
-
1
