How to connect to the database in phpstudypro

Connecting to a database in phpStudy Pro requires the following steps: Start phpMyAdmin and select a database name. Create a user and grant global permissions. Find the main server address, username and password. Connect to database in PHP code using mysqli function.

How to connect to the database in phpStudy Pro

Step 1: Open phpMyAdmin

• Start phpStudy Pro, click "Tools" > "phpMyAdmin".
• In the window that appears, select the name of the database you want to connect to.

Step 2: Create a database user

• Click the "Users" tab.
• In the "Add User Account" section, enter your new username and password.
• Select the "local" host.
• Check the "Global" checkbox to grant the user access to all databases.
• Click the "Create User" button.

Step 3: Grant User Permissions

• In the Users tab, find the username you just created.
• Click the "Edit Permissions" link.
• In the Databases section, select the checkbox for the database you wish to grant the user access to.
• In the "Global Permissions" section, select the "All Permissions" checkbox.
• Click the "Save" button.

Step 4: Set up PHP connection information

• In phpMyAdmin, click the Database tab.
• Select your database name from the drop-down list.

• In the "Main Server" section, look for the following information:

  • Address: Typically "localhost"
  • Username: You were in step 2 Created user
  • Password: The password you set in step 2

Step 5: Connect to the database in PHP code

In your PHP code, use the following function to connect to the database:

$mysqli = new mysqli("localhost", "用户名", "密码", "数据库名称");

If the connection is successful, the $mysqli variable will contain a resource pointing to the database connection.

The above is the detailed content of How to connect to the database in phpstudypro. For more information, please follow other related articles on the PHP Chinese website!