Install MySQL and PHPMyAdmin With XAMPP

This guide will show you how to install MySQL and PHPMyAdmin With XAMPP.

What is Xampp?

Xampp is a useful Apache distribution installer that will let you install phpMyAdmin, MySQL, as well as FileZilla and Apache.

What is MySQL?

MySQL is one of the most popular SQL relational database management systems (RDBMS).


Subscribe to my Newsletter


What is phpMyAdmin?

PhpMyAdmin is a software written in PHP used for the administration of MySQL.

How to Install MySQL and PHPMyAdmin

1. Install Xampp on your PC.

2. In your Xampp Control Panel, Start Apache and MySQL.

L’attribut alt de cette image est vide, son nom de fichier est xampp.jpg.

3. Open your browser and enter http://localhost/phpmyadmin.

L’attribut alt de cette image est vide, son nom de fichier est image-23.png.

Install Xampp on Mac OSX

Open Terminal

Install Homebrew

$ /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"

Install Xampp

$ brew install --cask xampp

How to Run phpMyAdmin in XAMPP

  1. Open the XAMPP control panel

  2. Start the MySQL Server

  3. Open phpMyAdmin in your Browser

    Open your browser and go to the localhost/phpmyadmin/ url.
    phpmyadmin

How to Open phpMyAdmin in XAMPP

To open phpMyAdmin in XAMPP, you need to access it from the same host that XAMPP is running on, using either the URL http://127.0.0.1 or http://localhost. Enter the http://localhost/phpmyadmin URL in your web browser. There you will be prompted to enter your username and password for the MySQL server. If you’re accessing phpMyAdmin for the first time, you will need to set a password for the “root” user before you can log in. Once you’ve logged in, you can access and manage your databases in phpMyAdmin.

Good to Know

TechWhat it is
XAMPPApache installer
phpMyAdminSQL tables management tool
MySQLSQL rdbms
FileZillaFTP management

Next

Now that you have installed MySQL and PHPMyAdmin with Xampp, we are going to create a MySQL database using Python.

4.2/5 - (11 votes)