Mysql Using Xampp

This is old.

EDIT: The MySQL configuration file should be in.xamppmysqlbinmy.ini. You need to find the bind-address parameter and change it to Everyone on your network should then be able to connect that MySQL instance. Of course, that may include people who better shouldn't do that. Download the XAMPP installer from 2. Double-click the installer file and follow the instruction to install XAMPP. Double-click the XAMPP icon to open the XAMPP Control Panel. Click Start next to 'Apache' and 'MySQL' to start the local servers. Click Admin next to 'Apache' to open the Apache Dashboard.

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

  1. Download and Install Visual Studio 2008 redistributable package because XAMPP will need this to run properly.
  2. Download and Install XAMPP for PHP 5.X for Windows- Be sure to select the proper version of PHP as there are many choices.
  3. Allow the program to make changes to your machine.
  4. 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.
  5. 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 should now see a green 'Running' indicator
  6. 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.

Testing your XAMPP Installation

In your web browser, go to http://localhost. You should see the start page of XAMPP:

Class Files

  1. After downloading the class files, create a folder in htdocs named 'Webucator' and extract your class files in that folder.

Setting the MySQL Password on Windows

The PHP files use 'pwdpwd' for the MySQL root password, while the default password is NO password.

  1. Click Admin next to MySQL on the XAMPP Control Panel to bring up the phpMyAdmin.
  2. Choose the mysql database on the left.
  3. Then choose the SQL tab on the top and run the following statement:
  4. You also need to update line 21 of the xampp/phpMyAdmin/ 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).

  1. 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.
  2. If it asks you to login, the username is root and the password is pwdpwd.
  3. On that page, click on the Import link under the Localhost heading. After, it should say 'Importing into the current server'.
  4. Browse to the Northwind-MySQL.sql file in your class files (c:xampphtdocsWebucator).
  5. Click the Go button on the bottom left of the page.
  6. You should get a Success message and Northwind should be added to your list of Databases.

Recommended Code Editor

Visual 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

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:

  1. Method 1:
    1. Go to http://localhost/Webucator/ClassFiles/PHPBasics/Demos/HelloWorld.php in your web browser.
    2. Follow the same pattern to view all other class files; basically the C:xampphtdocs gets changed to http://localhost/
  2. Method 2:
    1. Go to http://localhost/Webucator/ClassFiles/ in your web browser.
    2. Bookmark that page in your browser for easy access to it from now on.
    3. 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!

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.

How to Install MySQL and PHPMyAdmin

1. Install Xampp on your PC.

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

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



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

4/5(6votes )

Create Mysql Database Using Xampp

Sr SEO Specialist at Seek (Melbourne, Australia). 18 utc to pst. Specialized in technical SEO. In a quest to programmatic SEO for large organizations through the use of Python, R and machine learning.