Skip to main content

How to Create PhpMyAdmin for AWS Linux of Ubuntu Server

/=============================================================================================================================================


ANother way  

setting up phpMyAdmin on Ubuntu Server 22.04. Let's go step by step to get phpMyAdmin working correctly for you:

  1. Download phpMyAdmin: First, ensure that you have phpMyAdmin installed on your server. You can download it using the following command:

    bash
    sudo apt update
sudo apt install phpmyadmin

    During the installation, you will be asked to choose a web server. Select apache2 using the arrow keys and press Enter.

Now after this the most important work is to set it on URL for example on server's root URL or IP if you
have already deployed any python or node project and you want to access phpmyadmin outsite of that Document
Root then you have to use Allias for example your server url is 195.35.23.26 and you want to access it on

then you have to make changes in your default conf file like below <VirtualHost *:80> ServerName 195.35.23.26 DocumentRoot /root/homemapp # Rewrite rules for phpMyAdmin RewriteEngine On RewriteRule ^/phpmyadmin(/.*)?$ /usr/share/phpmyadmin$1 [L,QSA] # ProxyPass for Python project ProxyPass / http://127.0.0.1:8000/ ProxyPassReverse / http://127.0.0.1:8000/ <Directory /root/homemapp> Options Indexes FollowSymLinks MultiViews AllowOverride All Require all granted </Directory> <Directory /usr/share/phpmyadmin> Options Indexes FollowSymLinks MultiViews AllowOverride All Require all granted </Directory> </VirtualHost>


After this please Restart your Apache server 
sudo systemctl restart apache2



//=========================== ANother Ways =================

//============= node on ubuntu 22.01 server sudo apt update sudo apt install curl curl -fsSL https://deb.nodesource.com/setup_20.x | sudo -E bash - sudo apt install nodejs node -v sudo systemctl stop nginx sudo apt update sudo apt install apache2 //=========== Apache sudo apt update sudo apt update sudo apt install apache2 sudo systemctl start apache2 sudo systemctl enable apache2 sudo systemctl status apache2 //======== mysql sudo apt install mysql-server ls /etc/mysql sudo mkdir -p /etc/mysql sudo nano /etc/mysql/my.cnf put the following code in my.cnf [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 datadir = /var/lib/mysql log-error = /var/log/mysql/error.log [client] port = 3306 socket = /var/run/mysqld/mysqld.sock sudo mkdir -p /var/lib/mysql sudo mkdir -p /var/run/mysqld sudo chown -R mysql:mysql /var/lib/mysql sudo chown -R mysql:mysql /var/run/mysqld sudo chmod 755 /var/lib/mysql sudo chmod 755 /var/run/mysqld sudo systemctl start mysql // For making root with no password on terminal -> USE mysql; ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY ''; FLUSH PRIVILEGES; EXIT; -------------- DOne mySQL installation on Ubuntu22 server //========== isntall PHP properly before phpmyadmin //==================== PHPmyadmin Now its time to Install Phpmyadmin to use mysql on ubuntu sudo apt update sudo apt install phpmyadmin sudo mysql CREATE USER 'kilvish'@'localhost' IDENTIFIED BY 'Kil@123456'; GRANT ALL PRIVILEGES ON *.* TO 'kilvish'@'localhost' WITH GRANT OPTION; FLUSH PRIVILEGES; EXIT; //after exit mysql sudo nano /etc/apache2/conf-enabled/phpmyadmin.conf Alias /phpmyadmin /usr/share/phpmyadmin <Directory /usr/share/phpmyadmin> Options FollowSymLinks DirectoryIndex index.php <IfModule mod_authz_core.c> # Apache 2.4 <RequireAny> Require all granted </RequireAny> </IfModule> </Directory> sudo systemctl restart apache2 //------------ Now install php

Comments

Post a Comment

Popular posts from this blog

Part 15- What is Repeater (Networking Devices)- Computer Networking- CCNA

Repeater  hello friends i am Vasu Birla and today i am starting new segment of CCNA computer networking  its a Networking Devices. we will discuss every important Devices used in networks. Repeater is a first networking devices. What is Repeater  Repeater is a device that receives signals and re-transmits by amplifying or regenerating signals. Repeater has two port one is for receive signals from previous network and second port is for retransmit signals to the next extended network. Two Port Repeater Repeater is a device which is used to Regenerate or replicate signal (Pichhe se aa rahe signal ko regenerate karke ya amplify karke aage strong signals bhej sakte he) Analog and digital both type of signals can be retransmitted by repeater. Here there is difference between regeneration and amplifying.  Amplification means , received signals will be amplified as it is , whether there are impurities in signals  and Regeneration means repeate...
Post a Comment
Read more

GitHub Repo Collaboration Work on single project

 =============================================== To collaborate effectively with your friend on the same project, you should use Git branches to manage different lines of development. Here's a step-by-step procedure you can follow to streamline collaboration: 1. Create Separate Branches for Each Developer Create a New Branch for Your Friend: On your local repository, create a new branch for your friend. For example if your friend name is kilvish , if you want to create a branch named kilvish , you would run: make sure you would be on main branch already   command->  git checkout -b kilvish git push origin kilvish 2. Set Up Your Friend’s Environment( On your Friend's System )  at kilvish side  run ->  Clone the Repository (if not already done): If your friend hasn’t cloned the repository yet, they should do so: command ->  git clone https://github.com/Vasu-Birla/your-repo.git   // your your main clone line  Fetch All Bran...
Post a Comment
Read more

How to deploy NodeJS app on server with Apache2 and acess it with Server IP addresss - Node JS deploy project Live.

     hello friens , This is Vasu Birla , in previous post we have seen the deployement of NodeJS app on AWS instance server instance but AWS server is expensive than other servers . SO today we will use simple Ubuntu server for making Live out Project using Apache2 . At the end you will be abe to access your NodeJS app using server IP address from anywhere  .. 1.  Login to your server using SSH terminal . (in AWS part i already explained how to do this )     -> Open your putty in hostname put your server IP -      login with ssh username ->root and password     (if you dont have root username and pass ask your      provider or reset it from cpanel or hosting panel ) 2. after login - on terminal you can Put your project anywhere.     There are two ways to put your project folder on server location     (i) - > using Github - (very popular and easy to track your everyday code changes t...
Post a Comment
Read more