The complete installation of apache2, php and MySQL and connect

Question

The complete installation of apache2, php and MySQL and connect

to it using php:

sudo apt install apache2
sudo ufw allow OpenSSH
sudo ufw allow in "Apache Full"
sudo ufw enable
sudo apt install mysql-server

sudo mysql_secure_installation
//set pass and y y y y

sudo apt install php libapache2-mod-php php-mysql

then after all above done
log into your user in database as root user
sudo mysql -u root -p
//write the MySQL pass

then next create user

GRANT ALL PRIVILEGES ON *.* TO 'bgram'@'localhost' IDENTIFIED BY 'bgram12345';

next log into it using the password above

sudo mysql -u bgram -p

then create simple database

CREATE DATABASE bgram;
USE bgram;
exit;

//set the permission
sudo chmod -R 777 /var/www

creat a file in var/www for example db.php

open it and paste

<?php
$host="127.0.0.1";
$user="bgram"; //your username
$password="bgram12345"; // your username pass
$database="bgram"; //your test db
$connect= mysqli_connect($host, $user, $password, $database);
if(mysqli_connect_errno()) //if everythings goes wrong will be error
{ die("cannot connect to database field:". mysqli_connect_error()); }
?>

done .
now you have php,apache, MySQL and connection between the now

#apache2 #php #mysql

thank you guys for helping.
@il_muflone @C0rn3j