Install phpMyAdmin on Ubuntu Server 20.10

By

 Install phpMyAdmin on Ubuntu Server 20.10 :- 

Step 1: Install Apache

sudo apt update

sudo apt install apache2


sudo systemctl stop apache2.service

sudo systemctl start apache2.service

sudo systemctl enable apache2.service


http://localhost


Step 2: Install MariaDB

sudo apt install mariadb-server mariadb-client


sudo systemctl stop mariadb.service

sudo systemctl start mariadb.service

sudo systemctl enable mariadb.service



sudo mysql_secure_installation

When prompted, answer the questions below by following the guide.

Enter current password for root (enter for none): Just press the Enter

Set root password? [Y/n]: Y

New password: Enter password

Re-enter new password: Repeat password

Remove anonymous users? [Y/n]: Y

Disallow root login remotely? [Y/n]: N

Remove test database and access to it? [Y/n]:  Y

Reload privilege tables now? [Y/n]:  Y

Restart MariaDB server


sudo systemctl restart mariadb.service


sudo mysql


Then run the commands below to change to disable mysql_native_password module..


USE mysql;

UPDATE user SET plugin='' WHERE user ='root';

The save your changes 


FLUSH PRIVILEGES;

EXIT;


sudo systemctl restart mariadb.service


sudo mysql -u root -p  


(Any error type this :-   

shell> mysql -u root 

shell> mysql -u root -p

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'aryan';  ]) 



GRANT ALL PRIVILEGES ON *.* TO 'superadmin'@'localhost' IDENTIFIED BY 'aryan';


Step 3: Install PHP 7.4 and Related Modules


Run the commands below to add the below third party repository to upgrade to PHP 7.4


sudo apt-get install software-properties-common

sudo add-apt-repository ppa:ondrej/php


Then update and upgrade to PHP 7.4

sudo apt update


Next, run the commands below to install PHP 7.4 and related modules.

sudo apt install php7.4 libapache2-mod-php7.4 php7.4-common php7.4-gmp php7.4-curl php7.4-intl php7.4-mbstring php7.4-xmlrpc php7.4-mysql php7.4-gd php7.4-bcmath php7.4-xml php7.4-cli php7.4-zip


After installing PHP 7.4, run the commands below to open PHP default config file for Apache2.

sudo nano /etc/php/7.4/apache2/php.ini


Then make the changes on the following lines below in the file and save. The value below are great settings to apply in your environments.


file_uploads = On

allow_url_fopen = On

short_open_tag = On

memory_limit = 256M

upload_max_filesize = 100M

max_execution_time = 360

max_input_vars = 1500

date.timezone = Asia/Kolkata


Step 4: Install phpMyAdmin

sudo apt install phpmyadmin


When prompted to choose the webserver, selecat apache2 and continue.

 [*] apache2 

When prompted again to allow debconfig-common to install a database and configure select No.

<No>     



sudo -H gedit /etc/apache2/apache2.conf

Then add the following line to the end of the file:

Include /etc/phpmyadmin/apache.conf


Then restart apache:


/etc/init.d/apache2 restart


http://localhost/phpmyadmin

user name : root

password  : aryan

Location: Unnamed Road, Telangana 508116, India

Comments

Post a Comment

Popular posts from this blog

How to install and configure OSSEC server and client

By
How to install and configure OSSEC server and client sudo timedatectl set-timezone Asia/Calcutta Asia/Calcutta   1. sudo apt-get update && sudo apt-get upgrade -y 2. sudo apt-get install build-essential libevent-dev zlib1g-dev libssl-dev unzip wget -y 3. sudo apt-get install libpcre2-dev 4. sudo apt-get install libsystemd-dev 5. wget https://github.com/ossec/ossec-hids/archive/3.7.0.tar.gz 6. tar -xvzf 3.7.0.tar.gz 7. cd ossec-hids-3.7.0 8. sudo ./install.sh 9. sudo /var/ossec/bin/ossec-control start   Configure OSSEC nano /var/ossec/etc/ossec.conf Update below <global>     <email_notification>yes</email_notification>     <email_to>root@localhost</email_to>     <smtp_server>127.0.0.1</smtp_server>     <email_from>ossecm@localhost</email_from> </global>   <global>     <emai...
Read more

How to install nuke in windows 10 and windows 11,Installing Nuke on Windows, Install Nuke on Windows

By
  SINGLE MACHINE 1.Install Your Foundry Product 2.Install FLT7 (If you already have our rlm server working and running , jump to step 8)  3.Stop Foundry License Server 4.Copy the cracked rlm.foundry.exe over the original one (C:\Program Files\The Foundry\LicensingTools7.1\bin\RLM\rlm.foundry.exe)  5.Edit xf_foundry.lic replacing desktop 1234567890123456 (host name, Mac-Address)  You can get those informations using rlmutil.exe , a simple dos window ipconfig/all   or you can start Foundry License Utility and choose Diagnostics and Run Diagnostics, you will find your hostname, your mac address (System ID)     PORT is by default 5053 if you dont put any (dont forget to delete the word PORT then if you dont want to specify one) . If you need more infos read RLM manual. 6.Copy the xf_foundry.lic to C:\ProgramData\The Foundry\RLM or C:\Program Files\The Foundry\LicensingTools7.1\bin\RLM\ 7.Restart RLM Server you can do that from services or just with Fo...
Read more

Autodesk Maya 2024 Install Windows 11

By
 1) Install Autodesk Application - Do Not Start it yet  2) Install the Autodesk network license manager (v11.18.0) from crack folder (NLM.msi Update 8)      -Default install is "C:\Autodesk\Network License Manager"     -Stop any running instance (lmgrd, adskflex) if you have one     -Replace adskflex.exe by cracked one   3) Replace the version.dll - \Program Files (x86)\Common Files\Autodesk Shared\AdskLicensing\Current\AdskLicensingAgent\ 4) Edit lic.dat and change HOSTNAME and MAC to suit your configuration (if you are not sure start LMTOOLS Utility and go to     System Settings, your HOSTNAME and MAC will be listed)    You can change vendor port too and add your previous licenses of course :)    Save lic.dat where you want (we suggest to "C:\Autodesk\Network License Manager" folder) 5) You have 2 options:     1)Start Network License Manager manually :     Run the license manager w...
Read more