Install php and mysql database server configuration

When building a web server, PHP and MySQL database are two essential components. This article explains how to install and configure PHP and MySQL database servers.

Installing PHP

PHP (Hypertext Preprocessor) is a widely used scripting language mainly used for web development. The following describes the steps to install PHP on the Ubuntu operating system:

Step 1: Update the software source list

Before installing PHP, you need to ensure that all software is the latest version. Update the software source list. achieve this goal. Enter the following command in the terminal window:

sudo apt-get update

Step 2: Install PHP and related dependencies

Enter the following command to install PHP and related dependencies:

sudo apt-get install php libapache2-mod-php php-mysql

Step 3: Verify PHP Whether the installation is successful

After completing the above installation, you can enter the following command in the terminal to check whether PHP is installed successfully:

php -v

If the PHP version information is displayed, it means that PHP is installed successfully.

Install MySQL database

MySQL is a popular open source relational database management system. The following describes the steps to install the MySQL database on the Ubuntu operating system:

Step 1: Update the software source list

Similar to installing PHP, you also need to update the software source list before installing MySQL. Enter the following command in the terminal window:

sudo apt-get update

Step 2: Install the MySQL database

Enter the following command in the terminal window to install MySQL:

sudo apt-get install mysql-server

You will be prompted to set up during the installation process The password of the root user, after the setting is completed, the installation of MySQL can be completed.

Step 3: Verify whether MySQL is installed successfully

After completing the installation of MySQL, you can enter the following command in the terminal to verify whether MySQL is installed successfully:

mysql --version

If the MySQL version is displayed information, it means that MySQL is installed successfully.

Configuring PHP and MySQL

After installing PHP and MySQL, some configuration work still needs to be done. Here are some steps on how to configure PHP and MySQL.

Step 1: Start Apache

Before using PHP and MySQL, you need to confirm whether Apache is started. Enter the following command in the terminal window to start Apache:

sudo service apache2 start

Step 2: Test whether PHP can run

In order to test whether PHP can run successfully, you need to create a PHP file and place it in In Apache's web root directory. Enter the following command in the terminal to create a PHP file:

sudo nano /var/www/html/info.php

Enter the following code in the open file:

<?php phpinfo();
?>

Save and exit the file. Then enter the following URL in the browser to test whether the PHP file can run normally:

http://localhost/info.php

If the page displays the PHP version information, it means that PHP has run successfully.

Step 3: Configure MySQL

Before using MySQL, you need to complete the following configuration work:

Configure the root user of MySQL

In MySQL, root The user has the highest authority and therefore needs to set a secure password to protect the security of the server. Enter the following command in the terminal to enter MySQL:

sudo mysql -uroot -p

Enter the root user password to enter the MySQL command line. Enter the following command at the command line to set the root user password:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new_password';

where new_password is the new password you set.

Create a new user and authorize it

In order to facilitate the management of the database, you need to create a new user and authorize access rights. Enter the following command on the MySQL command line:

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON * . * TO 'username'@'localhost';

FLUSH PRIVILEGES;

where username and password are the username and password you set.

Step 4: Test MySQL to establish a connection

In order to test whether MySQL can successfully establish a connection, you can enter the following command in the terminal:

mysql -u username -p

Enter the user name and password, if it can If you log in successfully, it means that the MySQL connection is normal.

Summary:

The above are the complete steps to install and configure PHP and MySQL database servers. Through the above steps, we can successfully install and use PHP and MySQL databases on the Ubuntu operating system.

The above is the detailed content of Install php and mysql database server configuration. For more information, please follow other related articles on the PHP Chinese website!