*Reduced by 1% after each order
Rating 0 stars - 0 votes

How to Install Magento on Localhost Like XAMPP

This step-by-step tutorial will help you install Magento quickly and easily on localhost.

When you install XAMPP - make sure to install "phpmyadmin". Once you have XAMPP installed and running, follow these steps:


  1. Download Magento CE from here (recommended .zip file for Windows): https://www.magentocommerce.com/products/downloads/magento/

  2. Extract contents of magento- into this folder:

  3. c:\xampp\htdocs\

    As a result, you should have a new folder called "magento":


  4. Now open this URL in your browser: http://localhost/magento/

  5. You should see Magento installation page:

    Magento Installation Configuration
    Magento Installation Page

    Agree with terms and click "Continue"

  6. On "Localization" page select preferred options and click "Continue"

  7. On "Database Connection" page you must specify credentials to an existing database. You have to create it manually. This can be done from phpmyadmin (which should be installed along with XAMPP)

  8. Keep the tab in your browser with Magento installation open. Open a new tab and enter this URL: http://localhost/phpmyadmin/

    You should see the phpMyAdmin dashboard. On the top menu, click "Databases", then type some database name (say magentodb) and click "Create"

    My PHP Admin Databases
    Type some database name in the phpMyAdmin dashboard
  9. Return to Magento installation tab. Enter the newly created database name, username "root" into database user field and I'd recommend you to enable "Use Web Server (Apache) Rewrites" checkbox. You may leave all other fields as they are and click "Continue".
  10. Magento Installation Configuration
    Enter the Database Name in the Magento Installation Tab
  11. On the last step, you have to enter your name, email and specify what username and password you would like to use to log into your store backend (administration panel)
  12. Magento Create Admin Account
    Enter the Credentials to be Used to Log Into Your Store Backend


That's it! Now you should be able to see your Magento store front by this URL:


and log into backend using this URL:


Hope you will find this tutorial helpful. If you have got any questions, you can ask in the comments or in this topic of official Magento forum:


Use Store Manager for Magento to MaNage Your Store Expeditiously!

Try it FREE!

Related Articles:

Card image

Magento Support: Custom Development and Technical Assistance

Here is the full list of Magento support services offered by Store Manager experts. Read More...

Card image

Magento Open Source vs Magento Commerce vs Magento Commerce Cloud

Find out the difference between Magento editions and check their benefits. Read More...

Card image

How to Get Started with Your Magento. All-In Instructions

Detailed guide on how to set up your domain and proceed with Magento installation. Read More...

Card image

Store Manager Quick Start Guide

Use this quick tutorial to start working with Store Manager for Magento solution. Read More...

Sarmad Akram • 4 years ago


Thanks for the tutorial. Actually i have a problem and i'm trying to solve it from last 2 weeks. I have installed magento using xampp. Now when i export the database and import into another database i receive this error that sql is not valid its a html.

Can you please help me to solve it.

Magento Store ManagerMod Sarmad Akram • 4 years ago
Sarmad Akram • 4 years ago


No, Actually i don't need to move the data. I want to publish my website from local host to a live server. When i import the database to a server i get this error.


Magento Store ManagerMod Sarmad Akram • 4 years ago


1. What is the exact error message that you receive?

2. If you have a production store and a development store - you must understand that moving databases between them requires surgical precision, because you are not moving just products - you are moving the whole store data with payment,shipment and all possible store configuration. Frankly, we strongly would not recommend you do that. You should move only such data as catalog, attributes, customers, orders, etc. The best way to do it via export/import - https://www.mag-manager.com... But if you want to move all store configuration - it would be simpler and less time-consuming just to configure production store manually again.

Sarmad Akram • 4 years ago

Thank you so much for your reply,

Thank you so much for your reply, But i was doing a very simple thing i have installed magento and i have done nothing with it no configurations no payment methods 0 products. I just want to move to online server from local server. I export the database and during import get the error.


Magento Store ManagerMod Sarmad Akram • 4 years ago


It seems you are trying to execute PHP code as MySQL query. PHP is not SQL; SQL is not PHP. Those are very different things. You should ask a developer for further assistance.

Sarmad Akram • 4 years ago

If you don't mind can i ask you another question about magento?

Magento Store ManagerMod Sarmad Akram • 4 years ago

What exactly question?

Sarmad Akram • 4 years ago

Actually i have moved a magento website from local server to an online server. After uploading i can see the same text on the front end but there are no graphics. You can see here. http://sandro.x10host.com/ May be i have to change any permissions? Your answer will be very helpful. Thanks.

Magento Store ManagerMod Sarmad Akram • 4 years ago

Unfortunately we are not aware what can be the reason of the issue. You need to ask a developer for further assistance or you may post your question at Magento community forum and maybe other users who have faced the same problem and advise you on this regard.

Sarmad Akram • 4 years ago

Thank you so much for all your time, I have solved the problem. Actually xampp server had some problems. I have tried with wamp and , ALL IS WELL.