How to Install phpmyadmin Amazon ec2 Ubuntu

Install PHP MySQL on ubuntu ec2 instance. Here we will prove you stride-by-step on how to install PHP MySQL on ubuntu 18.04 AWS EC2.

Install phpmyadmin On Ubuntu Amazon EC2

Use the following steps to install, configure and admission phpmyadmin on ubuntu amazon ec2 server:

  • Connect Your AWS EC2 Case from SSH
  • Install phpmyadmin amazon ec2 ubuntu
  • Configure phpmyadmin in ubuntu ec2
  • Enable MySQL root Login for phpmyadmin ubuntu aws
  • Access phpmyadmin Amazon ec2
  • Restart Apache Web Server

Step 1 – Connect Your AWS EC2 Instance from SSH

Commencement of all, you need to connect your aws ec2 instance from ssh. If yous are new to connect aws ec2 case with windows, ubuntu and mac system. And then you tin read this tutoiral "How to Connect to ec2 Instance From Putty and SSH Last" to connect your ec2 instance from ssh.

Pace two – Install phpmyadmin amazon ec2 ubuntu

In this step, open up your ssh terminal and type the post-obit command to install PHPMyAdmin on ubuntu amazon ec2 web server: 

sudo apt install phpmyadmin

When you run this control. Then the selective selection bachelor for yous on the prompt wait like folloiwng:

When the get-go option is appear, you demand toselect apache2. At present information technology hasn't been selected.

Utilise space bar to select apache2 web server. Then printing Tab key that takes us to the Ok button. After that, press enter.

The side by side option is to configure the database for PHPMyAdmin with dbconfig-common. Select theYes option hither.

Afterward that, password configuration is appear on your concluding screen. And it is asked for login to phpmyadmin.So, y'all tin set your phpmyadmin access password here:

Footstep 3 – Configure phpmyadmin in ubuntu ec2

In this step, open up again your ssh final and run the post-obit command to configure phpmyadmin in apache2.conf file:

sudo nano /etc/apache2/apache2.conf

After that, add the following line into apache2.conf file and save it: 

Include /etc/phpmyadmin/apache.conf

Step 4 – Enable MySQL root Login for phpmyadmin ubuntu aws

Annotation that, By default root cannot login equally root user through phpMyAdmin.

And then, open up your ssh terminal and type the post-obit command to enable/allow mysql root login access for phpmyadmin on ubuntu aws spider web server:

sudo mysql -u root -p

Then type this following query:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password Past 'password';

Note that, Replace password past the root countersign you entered while installing MySql.

After that type following query to changes into effect:

FLUSH PRIVILEGES;

Step v – Restart Apache Web Server

After successfully installed PHP MySQL and configure these on ubuntu amazon ec2 instance.

Finally, Yous need to restart Apache 2 server by using the following command:

sudo service apache2 restart

Footstep half-dozen – Access phpmyadmin Amazon ec2

At present you tin login as root from phpMyAdmin. So, open your browser and type the beneath url with your ec2 server ip:

http://[SERVER_PUBLIC_IP]/phpmyadmin

So you lot will look like on your browser:

Recommended Tutorials

My name is Devendra Dode. I am a total-stack programmer, entrepreneur, and owner of Tutsmake.com. I like writing tutorials and tips that can help other developers. I share tutorials of PHP, Python, Javascript, JQuery, Laravel, Livewire, Codeigniter, Node JS, Limited JS, Vue JS, Athwart JS, React Js, MySQL, MongoDB, REST APIs, Windows, Xampp, Linux, Ubuntu, Amazon AWS, Composer, SEO, WordPress, SSL and Bootstrap from a starting phase. As well as demo example.

View all posts past Admin