Local development setup (Local, XAMPP) in Wordpress - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

What is the main purpose of using XAMPP for WordPress local development?

Why do developers use XAMPP when setting up WordPress on their local machines?

A To convert WordPress sites into mobile apps directly

B To host WordPress sites publicly on the internet without needing a hosting provider

C To automatically update WordPress plugins and themes without manual intervention

D To provide a local server environment with Apache, MySQL, and PHP to run WordPress sites offline

💡 Hint

Think about what components WordPress needs to run and how XAMPP helps with that.

XAMPP bundles Apache (web server), MySQL (database), and PHP (programming language) so you can run WordPress locally without internet.

❓ component_behavior

intermediate

What happens when you start Apache and MySQL in XAMPP Control Panel?

After launching XAMPP, you click 'Start' for Apache and MySQL. What is the expected behavior?

A Apache and MySQL services start running locally, allowing WordPress to connect to the web server and database

B XAMPP automatically opens your WordPress dashboard in the browser

C Your computer restarts to apply server settings

D XAMPP deletes all existing WordPress files to reset the environment

💡 Hint

Consider what Apache and MySQL do in a server environment.

Starting Apache launches the web server, and starting MySQL launches the database server. Both are needed for WordPress to work locally.

📝 Syntax

advanced

Which wp-config.php database settings are correct for XAMPP local setup?

Choose the correct database connection settings for WordPress's wp-config.php file when using XAMPP locally.

Wordpress

<?php
// Database settings snippet
define('DB_NAME', 'wordpress_db');
define('DB_USER', 'root');
define('DB_PASSWORD', '');
define('DB_HOST', 'localhost');
?>

A DB_NAME='wordpress_db', DB_USER='admin', DB_PASSWORD='password', DB_HOST='127.0.0.1'

B DB_NAME='wordpress_db', DB_USER='root', DB_PASSWORD='', DB_HOST='localhost'

C DB_NAME='wordpress', DB_USER='root', DB_PASSWORD='root', DB_HOST='localhost'

D DB_NAME='wordpress_db', DB_USER='root', DB_PASSWORD='root', DB_HOST='192.168.1.1'

💡 Hint

Remember default XAMPP MySQL user and password for local installs.

By default, XAMPP uses 'root' as the MySQL user with no password and 'localhost' as the host.

🔧 Debug

advanced

Why does WordPress show 'Error establishing a database connection' on XAMPP?

You installed WordPress on XAMPP but see the error 'Error establishing a database connection'. What is the most likely cause?

A Incorrect database credentials in <code>wp-config.php</code> file

B Apache server is not running in XAMPP Control Panel

C WordPress files are missing the <code>index.php</code> file

D Your internet connection is down

💡 Hint

Check the database connection details first when this error appears.

This error usually means WordPress cannot connect to the database because the username, password, database name, or host is wrong in wp-config.php.

❓ lifecycle

expert

What is the correct order of steps to set up WordPress locally using XAMPP?

Arrange these steps in the correct order to successfully run WordPress on XAMPP locally.

A 1,3,2,4,5

B 1,4,2,3,5

C 1,2,3,4,5

D 2,1,3,4,5

💡 Hint

Think about installing software first, then starting services, then preparing database, then adding WordPress files, then installing.

First install XAMPP, then start servers, create database, add WordPress files, and finally run the WordPress setup in the browser.

Practice

1. What is the main purpose of using a local development setup like Local or XAMPP for WordPress?

easy

A. To automatically publish posts on social media

B. To host live websites accessible to everyone on the internet

C. To replace the need for a web browser

D. To build and test WordPress sites safely on your own computer

Solution

1. Step 1: Understand local development

   Local development means working on your computer, not on the internet.

2. Step 2: Identify the purpose of Local and XAMPP

   They let you build and test WordPress sites safely without affecting live sites.

3. Final Answer:

   To build and test WordPress sites safely on your own computer -> Option D

4. Quick Check:

   Local development = safe site building [OK]

Hint: Local means work on your PC, not live online [OK]

Common Mistakes:

• Confusing local setup with live hosting
• Thinking local setup publishes sites online
• Believing local setup replaces browsers

2. Which of the following is the correct URL to access your WordPress site running on XAMPP locally?

easy

A. http://www.your-site.com

B. ftp://localhost/your-site-folder

C. http://localhost/your-site-folder

D. https://your-site-folder.local

Solution

1. Step 1: Recall local server URL format

   Local servers like XAMPP use 'localhost' with the folder name to access sites.

2. Step 2: Match correct URL pattern

   http://localhost/your-site-folder uses 'http://localhost/your-site-folder', which is correct for local access.

3. Final Answer:

   http://localhost/your-site-folder -> Option C

4. Quick Check:

   Local URL = http://localhost/folder [OK]

Hint: Local sites use http://localhost plus folder name [OK]

Common Mistakes:

• Using live website URLs instead of localhost
• Using ftp:// instead of http://
• Adding .local domain incorrectly

3. You installed XAMPP and placed your WordPress files in the folder htdocs/mywp. What happens when you visit http://localhost/mywp in your browser?

medium

A. You see the WordPress installation page to set up your site

B. You get a 404 error page because the folder is wrong

C. The browser downloads the WordPress files instead of showing them

D. You see a blank page with no content

Solution

1. Step 1: Understand XAMPP folder usage

   XAMPP serves files from the 'htdocs' folder, so 'mywp' is accessible at localhost/mywp.

2. Step 2: Recognize WordPress behavior on first visit

   Visiting the folder URL shows the WordPress installation page if setup is not done yet.

3. Final Answer:

   You see the WordPress installation page to set up your site -> Option A

4. Quick Check:

   Local WordPress folder URL shows install page [OK]

Hint: Visit localhost/folder to start WordPress install [OK]

Common Mistakes:

• Expecting live site without installation
• Confusing 404 error with wrong folder
• Thinking files download instead of display

4. You installed Local by Flywheel but when you try to access your site, the browser shows "Site can't be reached". What is the most likely cause?

medium

A. Local server is not running or stopped

B. You typed the wrong live website URL

C. Your internet connection is down

D. WordPress files are missing from the folder

Solution

1. Step 1: Check Local server status

   If Local server is stopped, the site URL won't load and shows connection errors.

2. Step 2: Rule out other causes

   Local sites don't need internet; wrong live URL or missing files cause different errors.

3. Final Answer:

   Local server is not running or stopped -> Option A

4. Quick Check:

   Local server must run to access site [OK]

Hint: Ensure Local server is running before opening site [OK]

Common Mistakes:

• Assuming internet is needed for local sites
• Confusing live URLs with local URLs
• Ignoring server status in Local app

5. You want to move a WordPress site from Local to XAMPP on your computer. Which steps should you follow to make the site work correctly on XAMPP?

hard

A. Copy only WordPress files to XAMPP's htdocs and open the site URL

B. Export the database from Local, copy WordPress files to XAMPP's htdocs, import database in phpMyAdmin, update site URL in database

C. Install WordPress fresh on XAMPP and copy themes from Local

D. Change the Local site URL to XAMPP URL and restart Local

Solution

1. Step 1: Export database and copy files

   Export Local's database and copy all WordPress files to XAMPP's htdocs folder.

2. Step 2: Import database and update URLs

   Use phpMyAdmin to import the database, then update site URL in database to match XAMPP URL.

3. Final Answer:

   Export the database from Local, copy WordPress files to XAMPP's htdocs, import database in phpMyAdmin, update site URL in database -> Option B

4. Quick Check:

   Database + files + URL update = successful move [OK]

Hint: Move files + export/import DB + update URLs [OK]

Common Mistakes:

• Copying files without database export/import
• Not updating site URL in database
• Trying to change Local URL instead of moving site