FerdieQO
Well-known member
- Joined
- Jul 15, 2016
- Messages
- 222
- Points
- 28
phpMyAdmin is an open source software popular web platform for managing MySQL.
Before you proceed to install phpMyAdmin you need preinstalled LAMP server or LEMP on on Ubuntu.
We have two ways to install phpMyAdmin package is installed and running phpMyAdmin through a php script as usual. I will show both ways.
1. Install phpMyAdmin package
Run the following command
During the installation process you need to keep in mind:
- Select Apache2 server
- Choose Yes when asked Configure the database for phpmyadmin with dbconfig-common
- Enter the MySQL password when asked
- Enter the password to access phpMyAdmin
Once installed, additional configuration phpmyadmin installed on Apache
Add the following code to the end of file
Restart apache
Now you can access via the link phpMyAdmin http://your_IP_address/phpmyadmin
2. Install phpMyAdmin as a script
I usually use this way for two reasons:
- Only running then will use the memory -> save server resource
- Can customize the path of phpmyadmin -> more security
First you need to select the version you want to install phpMyAdmin homepage
Copy the link directly to the file extension is .tar.gz, eg 4.6.3 version is https://files.phpmyadmin.net/phpMyAdmin/4.6.3/phpMyAdmin-4.6.3-all-languages.tar.gz
In www directory contains content sites, run the following command (you can create a folder to store files)
Extract to the current folder
PhpMyAdmin is complete you will have folder-4.4.14-all-languages, to use you visit the link http: //your_ip_address/phpMyAdmin-4.6.3-all-languages. Of course you can change the name to whatever you want to use and more secure.
Before you proceed to install phpMyAdmin you need preinstalled LAMP server or LEMP on on Ubuntu.
We have two ways to install phpMyAdmin package is installed and running phpMyAdmin through a php script as usual. I will show both ways.
1. Install phpMyAdmin package
Run the following command
Code:
sudo apt-get install phpmyadmin
- Select Apache2 server
- Choose Yes when asked Configure the database for phpmyadmin with dbconfig-common
- Enter the MySQL password when asked
- Enter the password to access phpMyAdmin
Once installed, additional configuration phpmyadmin installed on Apache
Code:
sudo nano /etc/apache2/apache2.conf
Code:
include /etc/phpmyadmin/apache.conf
Code:
sudo service apache2 restart
2. Install phpMyAdmin as a script
I usually use this way for two reasons:
- Only running then will use the memory -> save server resource
- Can customize the path of phpmyadmin -> more security
First you need to select the version you want to install phpMyAdmin homepage
Copy the link directly to the file extension is .tar.gz, eg 4.6.3 version is https://files.phpmyadmin.net/phpMyAdmin/4.6.3/phpMyAdmin-4.6.3-all-languages.tar.gz
In www directory contains content sites, run the following command (you can create a folder to store files)
Code:
wget https://files.phpmyadmin.net/phpMyAdmin/4.6.3/phpMyAdmin-4.6.3-all-languages.tar.gz
Code:
tar -xzvf phpMyAdmin-4.6.3-all-languages.tar.gz