There are four MySQL databases we use every day on the wordpress website: MySQL database address, database, user name and password. These four points must be filled in correctly for each website to connect to the database, otherwise the database cannot be accessed. In this article, Lao Wei takes wordpress and pagoda panel as examples to explain how to obtain four points of database.
This article is mainly about the content shared by Xiaobai and novices. Many people are new to the php program, mainly taking the wordpress program as an example. During the installation process, database information should be added to facilitate the connection to the database, as shown in the following figure. At this time, a little friend scratched his head. Where did the information come from? Why didn't I know? Or how could I not find it?
1. In a MySQL database, there can be multiple databases corresponding to multiple websites. In general, Database name and user name are the same 。 This is easier to remember. It is more complicated to set the security password.
2. The management database is usually completed by phpMyAdmin software. Login address: http://server IP/phpmyadmin. For security reasons, you should change the default path to a complex situation that only you know, such as mixed letters and numbers.
3. If a virtual host is used, the database account information can be obtained from the host control panel.
4. Different php panels have different ways of obtaining database information. The common military brothers in China, such as lnmp, oneinstack, AMH, WDCP, phpstudy, phpEnv, etc., obtain database information from the panel.
5. No matter which php program needs to input database information to complete the installation process.
Add a small detail: if there are multiple databases (multiple websites) in a MySQL database, the table prefix must be changed to be different.
Let's talk about the pagoda panel. The way to obtain database information is related to the way you choose to install WordPress. Today, Old Wei only said the quickest and simplest method suitable for novices. That is to use the pagoda panel to deploy the wordpress program. After the deployment, you will see the database account information as follows:
The database account information in the red box is extremely important. It should be saved to the local computer, which will be used later when installing WordPress. Please refer to the related tutorials for the process of deploying wordpress by one click in the pagoda panel: Pagoda panel One click deployment Source code installation Complete process of WordPress
Blackboard tapping: One click deployment is not to install wordpress programs for you, but to help you simplify the original manual operation process of adding domain names, creating websites, creating databases, creating ftp, uploading php programs, etc. You only need to provide relevant information, and the whole process is completed quietly by the pagoda panel in the background. The real process of installing wordpress programs requires you to do it yourself.
The content written by Old Wei was a bit confused, and he didn't clear the thread. It probably meant that he had said it, but it was estimated that the novice could see it more confused. If you are new to this aspect, you can ask Lao Wei if you don't understand it after reading it, and will try to help you explain the four points of the database and how to use it.
