How To Install phpMyAdmin On Windows
HTML-код
- Опубликовано: 4 окт 2024
- phpMyAdmin is a free and open-source administration tool for managing MySQL and MariaDB databases. It provides an easy-to-use web interface that allows you to manage your databases, tables, and data. In this tutorial, we'll guide you through the process of installing phpMyAdmin on Windows.
Step 1: Download phpMyAdmin
The first step is to download the latest version of phpMyAdmin from the official website. Choose the version that's compatible with your operating system.
Step 2: Extract the Files
Once the download is complete, extract the contents of the zip file to the "htdocs" folder in your XAMPP installation directory. This folder is usually located at "C:\xampp\htdocs".
Step 3: Rename the Folder
The extracted folder name may contain the version number of phpMyAdmin, so it's a good idea to rename it to something simpler, such as "phpmyadmin". This will make it easier to access in your web browser.
Step 4: Configure phpMyAdmin
Next, open the "config.sample.inc.php" file in the phpMyAdmin folder with a text editor, such as Notepad. Then, make a copy of the file and rename it to "config.inc.php". Open the "config.inc.php" file and find the line that starts with "$cfg['Servers'][$i]['auth_type']". Change the value from "cookie" to "config", and add a username and password for the MySQL user that phpMyAdmin will use to access your databases. Save and close the file.
Step 5: Test the Installation
Launch your web browser and go to "localhost/phpmyadmin". If everything is working correctly, you should see the phpMyAdmin login page. Enter the username and password you specified in the "config.inc.php" file, and you should be able to access your databases and start managing them.
Congratulations! You have successfully installed phpMyAdmin on your Windows computer. Now, you can start using it to manage your MySQL and MariaDB databases.
XAMPP is a popular software package that provides a complete web development environment for Windows users. It includes Apache, MySQL, PHP, and Perl, all in one easy-to-install package. In this tutorial, we'll guide you through the process of installing and configuring XAMPP on Windows 10 or Windows 11.
Step 1: Download XAMPP
The first step is to download XAMPP from the official website. Choose the version that's compatible with your operating system.
Step 2: Install XAMPP
Once the download is complete, run the installer and follow the on-screen instructions. Choose the components you want to install, and make sure to select "Apache" and "MySQL" during the installation process.
Step 3: Configure Apache and MySQL
After the installation is complete, launch XAMPP control panel and start Apache and MySQL services. Then, click on the "Config" button next to Apache and select "Apache (httpd.conf)". This will open the Apache configuration file. Search for "Listen" and change the port to 80 or any other available port. Save the changes and close the file.
Next, click on the "Config" button next to MySQL and select "my.ini". This will open the MySQL configuration file. Look for the line "bind-address" and change it to "127.0.0.1". Save the changes and close the file.
Step 4: Test the Installation
Launch your web browser and go to "localhost". If everything is working correctly, you should see the XAMPP welcome page. You can also test PHP by creating a new file with ".php" extension in the "htdocs" folder, and then accessing it through "localhost/filename.php".
Congratulations! You have successfully installed and configured XAMPP on your Windows 10 or Windows 11 computer. Now, you can start developing your web applications locally.
thanks man i was depressed cause i stop learning WordPress cause this small point
It is XAMPP installation guide. PhpMyAdmin begins @7min but there is no information how to really install it standalone (with any HTTP server and PHP).
yeah comments are just bots or newbies
Hey bluff master, its XAMPP installation not phpmyadmin installation. Don't fool around the people, correct the video title.
Yes bro true they fooled us 🤡
Great Video, you are a life saver!!
Thank you sir, your a life saver
Thanks a lot, really useful for newbies!
Thanks a lot, really useful for newbies! , Man u really help me a lot thank u 🙏🙏, Great Video, you are a life saver!!
At 10:56 why does it also show 443 in addition to port 8080?
I am unable to start sql server. Inspite of it, I am able to see my phpMyAdmin with apache server.
Error: MySQL shutdown unexpectedly.
01:53:22 م [mysql] This may be due to a blocked port, missing dependencies,
01:53:22 م [mysql] improper privileges, a crash, or a shutdown by another method.
01:53:22 م [mysql] Press the Logs button to view error logs and check
01:53:22 م [mysql] the Windows Event Viewer for more clues
01:53:22 م [mysql] If you need more help, copy and post this
01:53:22 م [mysql] entire log window on the forums
i have the same problem did u fix it?
Did you guys found the solution for the same, Please reply@@aliammar5941
I have same problem
@@aliammar5941 there is a "log" button
click that, for anyone seeing this now, then you will see more details and then you can google those details
Is it possible to run phpMyAdmin as a separated program instead of running it on the browser?
Man u really help me a lot thank u 🙏🙏
Thanks Really Helpfull
In step 3, does it need to rename htdocs to phpMyAdmin? and how to add username and password in step 4?
Peak educational content, thanks
very informative
MySQL is not starting so how to install only db of MySQL sir
I don't see the relational view tab. so I can't create a foreign key
thanks man!! helped a lot
thank you sir, you are amazing !!!
What are the credentials to sign in to phpmyadmin, because in my laptop it is not allowing me to the home page of php without credentials
If you already have a DB the credentials are the same that you use to access mysql/mariadb. Try root as user and blank as pwd.
For php administration use the credentials that you created in the installation.
Thanks for the video!
Thanks sir your video help me more
I just want to thank you for ur help
Ok i really really thanks you brother ❤️❤️
is it safe to allow access on public networks?
The start puttun unpressable for mysql
Thanks , very clear
great video TID
omg it work huhuhuuuu god bless you brother
Thank you :)
Thank you very much
thanx a lot !!
thanks a lot sir
Thank you sir
Iat the point of installing, It is not tick mark at php and apache
same with me... please help
soo good!! thanks a lot!
Thank you so much.
Very helpful! Thank you
Thank you very much❤❤❤❤❤
i thought this is supposed to be a phpmyadmin video
Thank you
Thanks 💯😊
Thanks Alot
Alhamdulilah 🎉
thanks a lot man
helpful tnx
kudos
god bless u
thanks man
misleading, xamp is configured with phpmyadmin already installed and is for lazy people
?
Thanks a lot, really useful for newbies!
Thank you very much
Thank you sir
thanks you
thank you so much