When developing websites and applications, databases are an essential part. Therefore, installing and configuring the database server is a very important task. In PHP, the most common relational database is MySQL. This article explains how to install and configure a MySQL database server in PHP.
First, you need to go to the MySQL official website and download the installation package of the MySQL database server. You can download the latest version of MySQL from the following URL:
https://www.mysql.com/downloads/
After selecting the installation package, you can select the operating system and version.
Once downloaded successfully, you need to run the installation program on your computer. The installer will provide some options including installation path, port, etc. During this period, you need to set up a root username and password, which are the credentials for subsequent logins to the MySQL database server.
After the installation is complete, you need to start the MySQL server. In Windows operating systems, you can find the MySQL server in the Start menu and start it. In the Linux operating system, you can use the following command to start the MySQL server:
$ sudo systemctl start mysql
Once the MySQL server is running, PHP is required to connect to the MySQL database server. To do this, you need to install the MySQL extension in PHP. You can use the following command to install the extension:
$ sudo apt-get install php-mysql
After the installation is complete, you need to modify the PHP configuration file php.ini to ensure that the MySQL extension is loaded correctly . Typically, the php.ini file is located in the following location:
/etc/php/7.4/apache2/php.ini
In the file, you need to search for the following:
; extension=mysql.so
Remove the comments from the statement and modify it into the following form:
extension=mysql.so
After modification, you need to restart the Apache server , to ensure that the modification takes effect.
$ sudo systemctl restart apache2
Now, you can connect to the MySQL database server using PHP code. The following is a simple PHP code example:
// Database connection parameters
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "my_database";
// Create a database connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check whether the connection is successful
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
?>
In the code, you need to set the server name, username, password, and database name to the desired values to ensure you are connecting to the correct database.
Conclusion
MySQL is a widely used open source relational database management system. Using the above method, you can easily install and configure a MySQL database server in PHP and create an application that connects to the server. Installing and configuring a MySQL database server is not a too difficult task and only requires basic setup.
The above is the detailed content of How to install database server configuration in php. For more information, please follow other related articles on the PHP Chinese website!