In this video, I'll show you how to properly install, run, and configure XAMPP on a MacOS so that you can run PHP code locally. The latest version of XAMPP o. XAMPP for Mac OS X is an essential application package for every web developer. In it you will find the Apache server, programming languages PHP and PERL and the database manage system MySQL. XAMPP is a free and open-source, cross-platform web server solution stack which is developed by Apache Friends. XAMPP supports most of the operating systems including Windows, MacOS and Ubuntu. It stands for Cross-Platform (X), Apache, MySQL, MariaDB, PHP and Perl which are also the main components of the stack package. If the xampp is install in your mac book just go the file path of cd /Applications/XAMPP/bin/./mysql -u root -p than it will ask for password if set than type else enter mysql is started now!!!!!!!!
XAMPP stack of software is an open-source localhost server providing a number of functionalities through the package of software it contains. The software, which is part of XAMPP is started/stopped using the XAMPP Control Panel. It is used for testing the projects and modifications offline before launching it on the global web. One such very important functionality provided by XAMPP is the creation of the MySQL database. This is done by using phpMyAdmin. The detailed explanation of what is phpMyAdmin and how to use it to create MySQL database with XAMPP will be discussed in this article.
phpMyAdmin
phpMyAdmin is a costless and open source software that provides the functionality of operating and managing MySQL over the internet. It provides an ease to the user to control and supervise the database with the help of a graphic user interface known as phpMyAdmin.This GUI is written in PHP programming language. Over time it has gained a lot of trust and demand for the purpose of finding a web-based MySQL administration solution. The user can operate upon MySQL via phpMyAdmin user interface while still directly executing SQL queries. The GUI allows the host to carry a number of manipulation operations on the database, such as editing, creating, dropping, amending, alteration of fields, tables, indexes, etc. It can also be used to manage access control over the data by giving privileges and permissions. phpMyAdmin has thus a vital role to play in handling and creating a database.
Steps To Create MySQL Database Using XAMPP
STEP 1- Navigate to XAMPP in your system or simply launch it by clicking the XAMPP Icon. The Control Panel is now visible and can be used to initiate or halt the working of any module.
STEP 2- Click on the 'Start' button corresponding to Apache and MySQL modules. Once it starts working, the user can see the following screen:
STEP 3- Now click on the 'Admin' button corresponding to the MySQL module. This automatically redirects the user to a web browser to the following address-
http://localhost/phpmyadmin
STEP 4- One can see a number of tabs such as Database, SQL, User Accounts, Export, Import, Settings, etc. Click on the 'Database' tab. Here you can see the Create option. Choose an appropriate name for the input field titled Database name. Things to keep in mind while selecting the name for the database are-
- The number of characters used should be equal to or less than 64.
- The name should comprise of letters, numbers and underscore.
- The DB name should not start with a number.
- It should be relevant to the topic for which it is being created.
Make sure the database is successfully created.
STEP 5- It is very important to create tables in order to store the information in a systematic manner. In this step, we will build tables for the created database. In the created Database (Login page in this case), click on the 'Structure' tab. Towards the end of the tables list, the user will see a 'Create Table' option. Fill the input fields titled 'Name' and 'Number of Columns' and hit the 'Go' button.
STEP 6- Now, we have to initialize our columns based on their type. Enter the names for each of your columns, select the type, and the maximum length allowed for the input field. Click on 'Save' in the bottom right corner. The table with the initialized columns has been created. You can create any number of tables for your database.
Controlling Access
In order to limit the audience in terms of users allowed to modify and read the data, you can set a password to the created database. In terms of default settings, the host's username is 'root' and there no password is provided. Follow the given steps to increase the privacy of your database:
STEP 1- Click on the 'User Accounts' tab at the top of the page.
STEP 2- Press 'Edit Privileges' under 'Actions' option corresponding the Username= 'root' and Hostname = 'localhost'
STEP 3- Click on the tab 'Change password' and type your password in the provided field. Retype the password to confirm it and then finally click on the 'Go.' Now the password has been set.
XAMPP is an easy to install Apache distribution containing MariaDB, PHP, and Perl. Just download and start the installer. It's that easy.
XAMPP for Windows7.2.34, 7.3.25, 7.4.13 & 8.0.0
Version Checksum Size 7.2.34 / PHP 7.2.34 What's Included? - md5
- sha1
153 Mb 7.3.25 / PHP 7.3.25 What's Included? - md5
- sha1
155 Mb 7.4.13 / PHP 7.4.13 What's Included? - md5
- sha1
156 Mb 8.0.0 / PHP 8.0.0 What's Included? - md5
- sha1
156 Mb Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.2.34, phpMyAdmin 5.0.3, OpenSSL 1.1.1, XAMPP Control Panel 3.2.4, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 7.0.106 (with mod_proxy_ajp as connector), Strawberry Perl 5.32.0.1 Portable
Includes: Apache 2.4.46, MariaDB 10.4.17, PHP 7.3.25, phpMyAdmin 5.0.4, OpenSSL 1.1.1, XAMPP Control Panel 3.2.4, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 7.0.107 (with mod_proxy_ajp as connector), Strawberry Perl 5.32.0.1 Portable
Includes: Apache 2.4.46, MariaDB 10.4.17, PHP 7.4.13, phpMyAdmin 5.0.4, OpenSSL 1.1.1, XAMPP Control Panel 3.2.4, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 7.0.107 (with mod_proxy_ajp as connector), Strawberry Perl 5.32.0.1 Portable
Includes: Apache 2.4.46, MariaDB 10.4.17, PHP 8.0.0, phpMyAdmin 5.0.4, OpenSSL 1.1.1, XAMPP Control Panel 3.2.4, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 7.0.107 (with mod_proxy_ajp as connector), Strawberry Perl 5.32.0.1 Portable
Windows 2008, 2012, Vista, 7, 8 (Important: XP or 2003 not supported)
Windows XP or 2003 are not supported. You can download a compatible version of XAMPP for these platforms here.
XAMPP for Linux7.2.34, 7.3.25, 7.4.13 & 8.0.0
Version Checksum Size 7.2.34 / PHP 7.2.34 What's Included? - md5
- sha1
151 Mb 7.3.25 / PHP 7.3.25 What's Included? - md5
- sha1
150 Mb 7.4.13 / PHP 7.4.13 What's Included? - md5
- sha1
152 Mb 8.0.0 / PHP 8.0.0 What's Included? - md5
- sha1
150 Mb Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.2.34 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.3, OpenSSL 1.1.1h, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Includes: Apache 2.4.46, MariaDB 10.4.17, PHP 7.3.25 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.4, OpenSSL 1.1.1h, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Includes: Apache 2.4.46, MariaDB 10.4.17, PHP 7.4.13 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.4, OpenSSL 1.1.1h, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Includes: Apache 2.4.46, MariaDB 10.4.17, PHP 8.0.0 & PEAR + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.4, OpenSSL 1.1.1h, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Most all distributions of Linux are supported, including Debian, RedHat, CentOS, Ubuntu, Fedora, Gentoo, Arch, SUSE.
XAMPP for OS X7.2.34, 7.2.34, 7.3.25, 7.3.25, 7.4.13, 7.4.13, 8.0.0 & 8.0.0
Version Checksum Size 7.2.34 / PHP 7.2.34 What's Included? - md5
- sha1
161 Mb 7.2.34 / PHP 7.2.34 What's Included? - md5
- sha1
353 Mb 7.3.25 / PHP 7.3.25 What's Included? - md5
- sha1
161 Mb 7.3.25 / PHP 7.3.25 What's Included? - md5
- sha1
358 Mb 7.4.13 / PHP 7.4.13 What's Included? - md5
- sha1
160 Mb 7.4.13 / PHP 7.4.13 What's Included? - md5
- sha1
360 Mb 8.0.0 / PHP 8.0.0 What's Included? - md5
- sha1
161 Mb 8.0.0 / PHP 8.0.0 What's Included? - md5
- sha1
357 Mb Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.2.34 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.3, OpenSSL 1.1.1h, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Includes: Apache 2.4.46, MariaDB 10.4.14, PHP 7.2.34 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.3, OpenSSL 1.1.1h, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Includes: Apache 2.4.46, MariaDB 10.4.17, PHP 7.3.25 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.4, OpenSSL 1.1.1h, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Includes: Apache 2.4.46, MariaDB 10.4.17, PHP 7.3.25 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.4, OpenSSL 1.1.1h, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Includes: Apache 2.4.46, MariaDB 10.4.17, PHP 7.4.13 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.4, OpenSSL 1.1.1h, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Includes: Apache 2.4.46, MariaDB 10.4.17, PHP 7.4.13 + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.4, OpenSSL 1.1.1h, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Includes: Apache 2.4.46, MariaDB 10.4.17, PHP 8.0.0 & PEAR + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.4, OpenSSL 1.1.1h, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Includes: Apache 2.4.46, MariaDB 10.4.17, PHP 8.0.0 & PEAR + SQLite 2.8.17/3.33.0 + multibyte (mbstring) support, Perl 5.32.0, ProFTPD 1.3.6, phpMyAdmin 5.0.4, OpenSSL 1.1.1h, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1, Sablotron 1.0.3, libxml 2.0.1, Ming 0.4.5, Webalizer 2.23-05, pdf class 0.11.7, ncurses 5.9, pdf class 0.11.7, mod_perl 2.0.11, FreeTDS 0.91, gettext 0.19.8.1, IMAP C-Client 2007e, OpenLDAP (client) 2.4.48, mcrypt 2.5.8, mhash 0.9.9.9, cUrl 7.53.1, libxslt 1.1.33, libapreq 2.13, FPDF 1.7, ICU4C Library 66.1, APR 1.5.2, APR-utils 1.5.4
Add-ons
Xampp For Mac For Bwapp
Applications
Xampp For Mac Free Download
Install your favorite apps on top of XAMPP. Bitnami provides a free all-in-one tool to install Drupal, Joomla!, WordPress and many other popular open source apps on top of XAMPP.
Xampp For Mac Os Sierra
OS X native modules have been deprecated. Please use XAMPP-VM for OS X and the Linux version of the add-ons. Check our FAQs for more info.