Advance

5 Ways To Install PHPMyAdmin On Windows 10

5 Ways To Install PHPMyAdmin On Windows 10
0
(0)

Every website needs to interact with a data management system or the data itself, so it needs to use a database. PHPMyAdmin has become one of the most popular software platforms for managing classified data with MySQL and MariaDB databases around the web. This article will teach you 5 Ways To Install PHPMyAdmin On Windows 10. You can check out the packages offered on the Eldernode website if you intend to buy a Windows VPS server.

How to Install PHPMyAdmin On Windows 10

Recommended Article: Basic steps after purchase a Windows VPS Server

What is PHPMyAdmin? 

PHPMyAdmin is an open-source, free, and third-party software tool written in PHP that manages the MySQL database on the web. It allows you to manage databases, tables, columns, relationships, lists, users, permissions and etc through the user interface. This software is database control software and supports a wide range of operations in MySQL and MariaDB.

Requirements to Install PHPMyAdmin On Windows 10

1- Install Apache web server on Windows

2- Install MySQL database manager on Windows

3- Install PHP on Windows

Downloading PHPMyAdmin on Windows 10

In this section, you will learn how to download PHPMyAdmin on Windows 10. To do this, follow the steps below.

Navigate to the official PHPMyAdmin website to download the desired version of PHPMyAdmin on your Windows 10 system. Click on Download 5.2.0:

 

PHPMyAdmin-official-website

 

Once the download is completed, go to the downloaded folder and unzip the downloaded file. Then move it to the C:\Apache24\htdocs path.

In order for the tool to work correctly, you need to set up a few PHPMyAdmin files. Find the config.sample.inc.php file inside the folder of the program and rename it to config.inc.php.

Now edit the file using your desired text editor. To do this choose the following line:

cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

Then you should enter your desired value. Note that the value must be at least 32 characters long:

cfg['blowfish_secret'] = ''; /* k7b862qwq4ygj8a2hkczmd6spqsnspnkd */

 

PHP-enter-value

 

Remember to save the configuration file.

Remove the ; beginning of the extension and open the php.ini file which is located in the PHP folder. You should enable the following extensions that are required for the tool’s operation:

extension=php_mbstring.dll  extension=mysqli

Remember to save the configuration.

Lastly, restart the Apache server by pressing Win+R and running the command below:

services.msc

How to Log in to PHPMyAdmin on Windows 10

First, open the following URL in your web browser and enter your MySQL username and password:

http://localhost/phpmyadmin/

 

Login-PHPMyAdmin

 

Now you should see the dashboard. If you scroll down the page, the warning sign will appear:

 

PHPMyAdmin-warning

 

The reason for the warning is that the tool needs a database to work. You can import it from the same installation folder. So click on the Import menu, go to the C:\Apache24\htdocs\phpMyAdmin\sql path and choose create_tables.sql:

 

Import-Phpmyadmin-database - Install PHPMyAdmin On Windows 10

 

You should see a database named PHPMyAdmin.

After the database is created, click on the shown icon to exit the tool:

 

Exit-PHPMyAdmin - Install PHPMyAdmin On Windows 10

 

In this step, modify the values referred to the user that manipulates the database. It will enable the database and table storage parameters and eliminate the double slashes in front of them. Also, it adds localhost in the line corresponding to the user control and modifies the value controluser and controlpass with the user and the password of MySQL.

Finally, save the configuration and come back to the PHPMyAdmin.

Recommended Article: how to buy rdp bitcoin

Conclusion

PHPMyAdmin facilitates the management and administration of MySQL. In this article, we taught you 5 ways to install PHPMyAdmin on Windows 10. I hope this tutorial was useful for you and helps you to install PHPMyAdmin on Windows 10. If you have any questions or suggestions, you can contact us in the Comments section.

How useful was this post?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

View More Posts
Marilyn Bisson
Content Writer
Eldernode Writer
We Are Waiting for your valuable comments and you can be sure that it will be answered in the shortest possible time.

    Leave Your Comment

    Your email address will not be published.

    We are by your side every step of the way

    Think about developing your online business; We will protect it compassionately

    We are by your side every step of the way

    +8595670151

    7 days a week, 24 hours a day