loader
Navrangpura, Ahmedabad, Gujarat
Follow us :

This instruction is based on the assumption that you are installing phpMyAdmin on a system, sometimes known as a local system, that is not publicly available via the Internet. Installing phpMyAdmin on Ubuntu 20.04 or 22.04 requires the following steps:

Step 1: Update Your System
To update the Ubuntu package repository and installed packages, use the command line and utilize the apt package manager:

sudo apt update && sudo apt upgrade -y

2..1Step 2: Installing MySQL 

MySQL may be installed on Ubuntu 22.04 by utilizing the APT package repository. As of this writing, MySQL 8.0.28 is the version that is available in the Ubuntu repository by default.
If you haven’t updated the package index on your server lately, do so before installing it:

apt install mysql-server -y

1 Start the service and make the Mysql. service boot up automatically after installation.

Use the systemctl start command to make sure the server is up and running:

systemctl start mysql.service
systemctl enable mysql.service

Setp:3 Install PHP
PHP is a free and open-source server-side programming language that can be used to create a variety of different things, including apps, websites, and CRMs. PHP is a language used for server-side programming. It’s a fairly popular programming language with a wide range of applications. It can also be incorporated into HTML. PHP has remained one of the most popular programming languages in the development field because it can operate with HTML. The reason behind this is that PHP helps to make the HTML code simpler.

apt install php -y

Step: 4 Install phpMyAdmin 
To install phpMyAdmin and its dependencies, do the following command:

apt install phpmyadmin -y

1 When the installer asks to configure a web server automatically, you must select one. If Apache is used by the system, the apache2 option is already highlighted. To choose Apache2, press Space. To highlight OK, press Tab.

2 Press Enter to confirm the selection 

3 The installation makes phpmyadmin the default user. After entering a strong password, press Enter to access the phpmyadmin user.

4 Confirm the password and press Enter.

5 Press Enter to confirm the selection

Step: 5 Check your IP address

ifconfig

My Server IP

192.168.1.36

Open Firefox Web Browser And Search

192.168.1.36/phpmyadmin

PHPMyAdmin running

Step:6 Mysql Secure Installation Create Database And Create a User 

1 Mysql Secure Installation

mysql_secure_installation

Securing the MySQL server deployment.

Connecting to MySQL using a blank password.

VALIDATE PASSWORD COMPONENT can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD component?

Press y|Y for Yes, any other key for No: y

There are three levels of password validation policy:

LOW Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary file

Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG: 0

Skipping password set for root as authentication with auth_socket is used by default.
If you would like to use password authentication instead, this can be done with the “ALTER_USER” command.
See https://dev.mysql.com/doc/refman/8.0/en/alter-user.html#alter-user-password-management for more information.

By default, a MySQL installation has an anonymous user,
allowing anyone to log into MySQL without having to have
a user account created for them. This is intended only for
testing, and to make the installation go a bit smoother.
You should remove them before moving into a production
environment.

Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
Success.
Normally, root should only be allowed to connect from
‘localhost’. This ensures that someone cannot guess at
the root password from the network.

Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
Success.

By default, MySQL comes with a database named ‘test’ that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
Success.

By default, MySQL comes with a database named ‘test’ that
anyone can access. This is also intended only for testing,
and should be removed before moving into a production
environment.

Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y

Success.

All done! 

2 Create a Database 

mysql -r -p

Enter password: **** yure Password

CREATE DATABASE highsky_db;

Query OK, 1 row affected (0.04 sec)

SHOW DATABASES;
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| highsky_db         |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| sys                |
+--------------------+
6 rows in set (0.03 sec)

3 Create a Mysql User 

CREATE USER Harry@'%' IDENTIFIED BY 'harry@123';

Query OK, 0 rows affected (0.08 sec)

3 Grant privileges to the database user on the database.

GRANT ALL ON highsky_db.* TO Harry@'%';

Query OK, 0 rows affected (0.01 sec)

4  Flush privileges and exit the Mysql console.

FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.01 sec)

Exit And Restart MySQL And Enable

systemctl restart mysql.service
systemctl enable mysql.service

Step 7 Restart the Apache2 service after that to make the latest PHP configuration modifications.

systemctl restart apache2
systemctl enable apache2

Step 8 Open Firefox Web Browser And Search

Username: Harry

Password: harry@123

And Click Go

And Database

Author

by admin

bg

Subscribe to our Newslatter

Sign Up to Our Newsletter to Get Latest Updates & Services

mail box
logo-footer
HighSky IT Solutions Pvt. Ltd. is a leading IT training and certification programs in Red hat, RSCSA Cloud, Open-source, AWS, Devops and various domains.
Contact Info

2nd floor, Rohera Arcade, opp SOTC office, Near Navrangpura police station, Navrangpura, Ahmedabad -380009 Gujarat

Copyright ©2024 Design & Developed by HighSky IT