![]() Move the PHP index file to the first position after the DirectoryIndex specification, like this:ĭirectoryIndex index.php index.html index.cgi index.xhtml index.htm ![]() Sudo nano /etc/apache2/mods-enabled/dir.confĭirectoryIndex index.html index.cgi index.php index.xhtml index.htm Now, you need to configure dir.conf file by using the following sudo nano command: Sudo apt-get install php libapache2-mod-php php-mysql php-curl php-gd php-json php-zip php-mbstringĪfter successfully installed PHP on ubuntu amazon ec2 instance. So open your ssh terminal and type the following command: Now, install PHP with it’s common extensions. Now, Type exit on ssh terminal to get out of MySql: So, you will need to set the root password of the database and secure it using the following command :Īfter the password has been set you can check the whether MySQL is working correctly by logging into the database with the command : Then, secure MySql server by using the following command. Now, open your ssh terminal and type the following command to install MySql Server:Ĥ.2 – Securing MySQL server in Apache aws ec2 And, it will be looks like the Apache 2 page in the following picture: Step 3 – Install Apache 2 on ubuntu 18.04ģ.5 – Verify that the Apache service is runningģ.6 – Open Browser and type EC2 intance IPįinally, open your browser and type your AWS ec2 instance IP address. If you are new to connect aws ec2 instance with windows, ubuntu and mac system. In this step, you need to connect your aws ec2 instance from ssh terminal. Step 2 – Connecting your AWS EC2 Instance from SSH If you have already launch new ec2 instance, so you can move next step. We believe this guide will help you to manage your MySQL database better.First of all, you need to launch aws ec2 instance. For security reasons, never configure your websites to run using the root user of your MySQL database.Īlso, you should consider installing an SSL certificate to protect your phpMyAdmin login details from landing into the wrong hands especially if you are logged into to your server on a public network. You have now configured phpMyAdmin on your Ubuntu 18.04 server and managing your databases will be a breeze. If the details are correct, you will get the below phpMyAdmin User Interface and you can now manage your database by creating tables, adding fields, indexes, inserting, updating and deleting record. You should see a screen similar to the one belowĮnter your username and password to proceed. Remember to change the IP address with your public IP address associated with your Ubuntu 18.04 server or domain name. You can visit the url on your server to test the installation. If you followed the above steps, your phpMyAdmin installation should be successful. If you miss any of the steps below, you can reconfigure phpMyAdmin by running the command below: $ sudo dpkg-reconfigure phpmyadminĪlso if you want to completely remove phpMyAdmin and start all over, run the command below: $ sudo apt-get purge phpmyadmin You will be prompted to confirm the password one more time as shown below. Then press TAB and and Enter to proceed as shown below: Kindly type a strong password with a mix of lower case letters, upper case, numbers and symbols for security purposes. Next, create an application password for phpMyAdmin. ![]() Select ‘ Yes’ and press Enter to proceed. On the next screen, you will be prompted to configure a database that phpMyAdmin will use for administration purposes. Choose apache2, then click TAB and Enter to proceed as shown below: The first step prompts you to choose a server from apache2 and Lighttpd. You will be taken through a series of steps to configure your phpMyAdmin installation. $ sudo apt-get install mysql-server Step 1: Go to HostAdvice’s best PHP hosting, best VPS hosting, or best Linux Hosting to find the best rated web hosts in these categories. Special note: If you haven’t yet purchased a hosting plan, we recommend that you consult with HostAdvice’s expert and user reviews before doing so. You can run the command below to install MySQL on your Ubuntu 18.04 server if you haven’t done so. In this guide, we will show you how you can install phpMyAdmin on your Ubuntu 18.04 server Prerequisites MySQL and phpMyAdmin are the de facto standards for managing most modern web applications databases. MySQL is quickly replacing commercial database management system and is considered as one of the best database software for a production environment. This is where phpMyAdmin comes in to help you manage tables, columns, indexes, users, permissions and more using a graphical user interface. The portable web application can manage both MySQL and MariaDB.Įxecuting commands and managing MySQL database from the command line is not very intuitive especially if you are performing a lot of database tasks. PhpMyAdmin is one of the most popular open-source database administration software written in PHP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |