---
title: "Configure MySQL Database"  
description: "MySQL is an open source database server. MySQL Database powers the most demanding Web, E-commerce and Online Transaction Processing (OLTP) application"  
author: "Anonymous User"  
published: 2011-09-18  
updated: 2020-02-12  
canonical: https://www.mindstick.com/articles/733/configure-mysql-database  
category: "php"  
tags: ["php"]  
reading_time: 1 minute  

---

# Configure MySQL Database

Where MySQL is an open-source database server. These database powers are the most demanding for Web, E-commerce, and Online [Transaction Processing](https://www.mindstick.com/interview/2274/what-is-oltp-online-transaction-processing) (OLTP) applications.

This is a fully [integrated](https://www.mindstick.com/forum/33532/handler-pagehandlerfactory-integrated-has-a-bad-module-managedpipelinehandler-in-its-module-list) transaction-safe, ACID (Atomicity Consistency [Isolation](https://yourviews.mindstick.com/view/195/hey-isolation-let-s-be-friends) Durability) compliant database with full commit, rollback, and crash recovery and row-level locking capabilities.

The MySQL DB delivers the ease of use, [scalability](https://www.mindstick.com/blog/140/performance-and-scalability-characteristics-of-mysql), and performance that has made MySQL the world's most popular open-source database.

Into this article, I will show you, how to use the [MySQL database](https://www.mindstick.com/forum/390/how-to-create-mysql-database-backup-file-using-php) with PHP. To use of MySQL database with PHP, make some changes in the php.ini file.

##### Change 1:

Open ‘php.ini’ file and configure as follows:

![Configure MySQL Database](https://www.mindstick.com/mindstickarticle/b45cb3e6-3ed4-4bfd-b3c7-5881b1760b2b/images/4367d9cf-28bc-4608-89a6-224d400e5e9d.png)

From the above file, uncomment the highlighted line by removing semicolon (;) from the front of this line.

##### Change 2:

Open ‘php.ini’ file and find out ‘extension_dir’ after that set the [extension](https://www.mindstick.com/articles/22/extension-method) directory path.

![Configure MySQL Database](https://www.mindstick.com/mindstickarticle/b45cb3e6-3ed4-4bfd-b3c7-5881b1760b2b/images/49b4dae8-c3cb-4f25-bccd-1cc293f1f51b.png)

Here “C:\php\ext\” is a directory path where I had install PHP.

After making the above two changes in the php.ini file, [restart your](https://answers.mindstick.com/qa/50639/how-to-force-restart-your-iphone-8-plus) [apache server](https://www.mindstick.com/articles/710/apache-server-installation-on-windows). Now your MySQL database server is ready for use with PHP.

\

---

Original Source: https://www.mindstick.com/articles/733/configure-mysql-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.