Now you can login as root from phpMyAdmin. Note that, Replace password by the root password you entered while installing MySql.Īfter that type following query to changes into effect: FLUSH PRIVILEGES Step 5 – Restart Apache Web ServerĪfter successfully installed PHP MySQL and configure these on ubuntu amazon ec2 instance.įinally, You need to restart Apache 2 server by using the following command: sudo service apache2 restart Step 6 – Access phpmyadmin Amazon ec2 Then type this following query: ALTER USER IDENTIFIED WITH mysql_native_password BY 'password' So, open your ssh terminal and type the following command to enable/allow mysql root login access for phpmyadmin on ubuntu aws web server: sudo mysql -u root -p Note that, By default root cannot login as root user through phpMyAdmin. In this step, open again your ssh terminal and run the following command to configure phpmyadmin in nf file: sudo nano /etc/apache2/nfĪfter that, add the following line into nf file and save it: Include /etc/phpmyadmin/nf Step 4 – Enable MySQL root Login for phpmyadmin ubuntu aws So, you can set your phpmyadmin access password here: Step 3 – Configure phpmyadmin in ubuntu ec2 Select the Yes option here.Īfter that, password configuration is appear on your terminal screen. ![]() The next option is to configure the database for PHPMyAdmin with dbconfig-common. Then press Tab key that takes us to the Ok button. Use space bar to select apache2 web server. When the first option is appear, you need to select apache2. Then the selective option available for you on the prompt look like folloiwng: In this step, open your ssh terminal and type the following command to install PHPMyAdmin on ubuntu amazon ec2 web server: sudo apt install phpmyadmin Step 2 – Install phpmyadmin amazon ec2 ubuntu So you can read this tutoiral “How to Connect to ec2 Instance From Putty and SSH Terminal” to connect your ec2 instance from ssh. If you are new to connect aws ec2 instance with windows, ubuntu and mac system. Step 1 – Connect Your AWS EC2 Instance from SSHįirst of all, you need to connect your aws ec2 instance from ssh. Step 1 Installing phpMyAdmin To get started, we will install phpMyAdmin from the default Ubuntu repositories.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |