We all know the purpose of installing XAMPP on a computer is to achieve a local platform to develop and test a web app locally before making it live. But if there’s a problem installing XAMPP MySQL then you may seek professional help and that’s where precisely this blog post will help you.
XAMPP is a software packet which contains four key components i.e. X stands for cross-platform compatibility, A (Apache web server), M (MySQL database), P(PHP), P (Perl). It has been designed to provide you a smooth installation experience to create a local web server for development and testing purpose. However, working on a website either on a local computer or hosted, you would need a database. Don’t worry, you don’t have to be MySQL expert to create a database with XAMPP. You can use phpMyAdmin graphical user interface for MySQL.
In this post, you will learn how XAMPP MySQL installation and configuration takes place. However, in my previous posts on how to install XAMPP and how to install WAMP, I’ve fully explained the role of MYSQL. But in this post, I’ll specifically talk about MySQL and Apache in reference to XAMPP.
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 is a costless and open source software that provides the functionality of operating and managing MySQL over the internet. Subscribe to my newsletter: Donate!: Addi.
Download and Install: XAMPP MySQL Apache and PHP/Pearl
First, you need to download and install XAMPP installer on your computer. This way you’ll get a dedicated control panel to manage all the components. Whilst installing XAMPP you’ll see an option to select whether you wish to run MySQL and Apache as services. If you select the option, then MySQL and Apache will start at system boot-up with the database web management tool phpMyAdmin user interface to manage XAMPP MySQL.
What is MySQL?
MySQL is an open source relational database management system (RDBMS) that relies on SQL (structured query language). Most of the web-based applications use RDBMS for its development. Basically, MySQL helps you structure your data, present the information in an organized manner, edit, delete, update, or retrieve data whenever required.
Any content management system (CMS) you use to create your website be it WordPress, Drupal, Magento, PrestaShop, etc. you would need MySQL to store and retrieve its data. All type of data like post content, post type, user profiles, tables, etc. is accessible via MySQL only. Mostly web servers which provide you one-click installation have already installed MySQL so that you don’t have to do it externally.
XAMPP MySQL as a package
XAMPP is a cross-platform compatible Apache distribution. Likewise, MySQL perfectly works on multiple operating systems and it can easily integrate with PHP. On XAMPP MySQL works as a database component which is required to run a database-enabled website and servers. On the control panel of XAMPP MySql and Apache need to be started first in order to run the website on the local server. As shown in the screenshot below. And when you see their status turned into green, that means it has been started correctly.
XAMPP MySQL and phpMyAdmin
If you are going to have a WordPress website the best practice is to develop and test it locally before making it live. However, not only a WordPress website, rather any cms say Joomla, Drupal, PrestaShop, etc. you should test a website in a local environment before presenting it to live users.
In order to create a database or tables for the website, you need to log in to phpMyAdmin user interface. Click the Admin button from the XAMPP to run phpMyAdmin and the interface will look like the one shown below. Here, go to the ‘phpmyadmin’ click on the ‘New’ and then name the database. And finally, click on the ‘Create’ button to finish the process.
So you can see how important role MySQL plays in the web development realm. In the layman language, we can say MySQL XAMP is like the backbone for a project. I’ll tell you why!! A project needs to be tested thoroughly to be successful. So, for this purpose, you need to have a secure and fully equipped platform. And XAMPP provides the required platform loaded with requisite components.
As you are are going to design a website and you are familiar with your CMS may be it is WordPress or Joomla, and you have also created the local development environment with XAMPP and MySQL with Apache Web Server. Now you need a beautiful website or theme. And to craft a beautiful website you need a powerful website builder. There are many WordPress Theme Builders available now these days but I’ll recommend TemplateToaster, it works locally on your Windows PC to design website of your choice. Produce your stunning website with this website builder and kick start your website in no time at all.
This is old.
We now recommend using MAMP instead of XAMPP. See these instructions for setting up for our PHP classes.
XAMPP is a free distribution package that makes it easy to install Apache Web Server, PHP, PEAR, and MySQL. Before installing XAMPP, you should turn off any other web servers and instances of MySQL you have running on your Windows machine.
Installing XAMPP on Windows
- Download and Install Visual Studio 2008 redistributable package because XAMPP will need this to run properly.
- Download and Install XAMPP for PHP 5.X for Windows- Be sure to select the proper version of PHP as there are many choices.
- Allow the program to make changes to your machine.
- It is VERY important to install on the root of c:. If you don't, some functions of XAMPP may have restrictions that will force you to adjust the settings in your UAC, which isn't recommended.
- Double-click on the new XAMPP Control Desktop shortcut or Use the Search feature in Windows 10 to find the XAMPP Control App, which opens up the XAMPP Control Panel Application. There you will see a column of 'Start' buttons. Select the ones for MySQL and for Apache..you should now see a green 'Running' indicator
- NOTE: If you find another service is already running on port 80 on your computer, read our instructions on how to change XAMPP to use a different port like 8080.
Xampp With Mysql
Testing your XAMPP Installation
In your web browser, go to http://localhost. You should see the start page of XAMPP:
- After downloading the class files, create a folder in htdocs named 'Webucator' and extract your class files in that folder.
Xampp Phpmyadmin Mysql
Setting the MySQL Password on Windows
The PHP files use 'pwdpwd' for the MySQL root password, while the default password is NO password.
- Click Admin next to MySQL on the XAMPP Control Panel to bring up the phpMyAdmin.
- Choose the mysql database on the left.
- Then choose the SQL tab on the top and run the following statement:
- You also need to update line 21 of the xampp/phpMyAdmin/config.inc.php file with the new password (
pwdpwd). Note: In order to connect to the myPHPAdmin center, you must do these steps in order.
Installing Northwind Database using XAMPP
NOTE: you should download the class files above before following these instructions, as it contains the Northwinds Database file(s).
- To install the Northwind database used in class, click Admin next to MySQL on the XAMPP Control Panel to bring up the phpMyAdmin. That should take you to http://localhost/phpmyadmin.
- If it asks you to login, the username is root and the password is pwdpwd.
- On that page, click on the Import link under the Localhost heading. After, it should say 'Importing into the current server'.
- Browse to the Northwind-MySQL.sql file in your class files (c:xampphtdocsWebucator).
- Click the Go button on the bottom left of the page.
- You should get a Success message and Northwind should be added to your list of Databases.
Recommended Code EditorVisual Studio Code (Download, Install, and Set up)
- While you may use a different editor or IDE, Visual Studio Code is an excellent IDE to learn to code on. It provides a nice balance of power and simplicity and it is available on Windows and Mac.
Testing PHP Files
Open Phpmyadmin Xampp
All your class files should be located in C:xampphtdocsWebucatorClassFiles
To test any of the class files in your browser, say C:xampphtdocsWebucatorClassFilesPHPBasicsDemosHelloWorld.php, you can use 1 of 2 methods:
- Method 1:
- Go to http://localhost/Webucator/ClassFiles/PHPBasics/Demos/HelloWorld.php in your web browser.
- Follow the same pattern to view all other class files; basically the C:xampphtdocs gets changed to http://localhost/
- Method 2:
- Go to http://localhost/Webucator/ClassFiles/ in your web browser.
- Bookmark that page in your browser for easy access to it from now on.
- From there, you can see all the lesson folders and drill down to any class file for testing/viewing.
And that's it
Happy Windows XAMPPing!