


It is very suitable for database managers who are not familiar with database operation commands. Let me tell you how to install this tool:
1. First download phpmyadmin from the Internet, and then unzip it to an accessible web directory (if it is a virtual space, you can unzip it Upload to the web directory via ftp, etc.), of course you can modify the name of the decompressed file.
2. Configure the config file
Open the config.default.php file under libraries, find the following items in order, and configure them according to the instructions:
A. Visit the URL
Quote:
$cfg['PmaAbsoluteUri'] = ''; Fill in the access URL of phpmyadmin here
B.mysql host information
Quote:
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
Fill in localhost or mysql location The IP address of the server. If mysql and the phpmyadmin are on the same server, press the default localhost
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
mysql port, if it is the default 3306, leave it empty
C.mysql username and password
Quote:
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user access The mysql user name used by phpmyadmin
fg['Servers'][$i]['password'] = ''; // MySQL password (only neededThe password corresponding to the above mysql user name
D. Authentication method
Quote:
$ cfg['Servers'][$i]['auth_type'] = 'cookie';
There are four modes to choose from, cookie, http, HTTP, config
The config method is to enter the access URL of phpmyadmin directly Enter without entering username and password. It is unsafe and not recommended.
When this item is set to cookie, http or HTTP, logging in to phpmyadmin requires data username and password for verification, as follows:
PHP installation mode is Apache , you can use http and cookies;
PHP installation mode is CGI, you can use cookies
E. Setting of phrase password (blowfish_secret)
Quote:
$cfg['blowfish_secret'] = '';
If the authentication method is set to cookie, You need to set a phrase password, and it is up to you to decide what password to set, but it cannot be left blank, otherwise an error will be prompted when logging in to phpmyadmin
Ok, so far, you have successfully installed phpmyadmin, simple, log in quickly Try it out
Note:
This document only describes the basic configuration of installing phpmyadmin. Detailed descriptions of each configuration parameter in the config.default.php file can be found
phpMyAdmin is a MySQL database management tool. After installing the tool, that is MySQL data can be managed directly through the web form without the need to execute system commands. It is very suitable for database managers who are not familiar with database operation commands. The installation method of this tool is explained in detail below.
1. Download
1. First go to the official website to download the phpMyAdmin installation package: http://www.phpmyadmin.net/ (the installation includes all-languages)
2. Unzip it to a directory accessible by the web. If It is a virtual space that can be decompressed and uploaded to the web directory through the ftp tool. At the same time, you can modify the name of the decompressed file (you can customize the directory name).
2. Configuration
3. Open the /libraries/config.default.php file (the old version is the config.inc.php file in the root directory) and edit it with WordPad (do not use Notepad, this is UTF8 encoding). Just follow the instructions to configure it.
4. Find $cfg['PmaAbsoluteUri']=''; // Change it to the URL of phpMyAdmin that you will upload to the space
For example: $cfg['PmaAbsoluteUri'] ='http: // Website domain name/phpmyadmin/' ;
5. Search for $cfg['Servers'][$i]['host'] ='localhost'; // Usually the default is used, but there are exceptions. You don’t need to modify it.
6. Search for $cfg['Servers'][ $i]['auth_type'] ='config'; // Use config for debugging on your own machine; if you use cookies on the Internet, there are four modes to choose from: cookie, http, HTTP, config
① The config method is to enter the access URL of phpMyAdmin to enter directly without entering the user name and password. It is unsafe and not recommended.
② Set cookie, http, HTTP method, log in to phpMyAdmin and need data username and password for verification.
The details are as follows: PHP installation mode is Apache, you can use http and cookies; PHP installation mode is CGI, you can use cookies.
7. Search for $cfg['Servers'][$i]['user'] = 'root'; // MySQL user name
8. Search for $cfg['Servers'][$i]['password'] =''; // MySQL password (only needed, just leave it blank)
9. Find $cfg['Servers'][$i]['only_db'] = ''; // If you only have one data, set it up , set to your database name; if you want to set up a server, it is recommended to leave it blank
10. Search $cfg['DefaultLang'] = 'zh'; // Here is the language selection, zh means Simplified Chinese
11. Find $cfg['blowfish_secret'] =''; // If the authentication method is set to cookie, you need to set a phrase password. It is up to you to decide what password to set. You cannot leave it blank here, otherwise you will be prompted as shown below when logging in to phpMyAdmin. error shown.
12. Save after setting up. Now you can upload it to the network space. Browse http://website domain name/phpmyadmin/ to test it. (Just enter the username and password of the database)
If an error occurs during the installation process: "phpMyAdmin - Error The mysqli extension is missing. Please check the PHP configuration." error.
The solution is as follows:
①Go to the librariesconfig.default.php file in the phpmyadmin folder and find: $cfg['Servers'][$i]['extension']='mysql'; statement.
②If you find the sentence $cfg['Servers'][$i]['extension']='mysql';, continue to search for the following sentence $cfg['Servers'][$i]['extension' ]='mysqli'; and remove its comments.
③If you don’t find the sentence $cfg['Servers'][$i]['extension']='mysql';, just put $cfg['Servers'][$i]['extension']=' mysqli'; statement, changed to $cfg['Servers'][$i]['extension']='mysql'; statement. (That is, make sure the " mysql " value is valid)
The above introduces the phpmyadmin download and a very detailed PHPMYADMIN concise installation tutorial, including the content of phpmyadmin download. I hope it will be helpful to friends who are interested in PHP tutorials.

PHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.

PHP makes it easy to create interactive web content. 1) Dynamically generate content by embedding HTML and display it in real time based on user input or database data. 2) Process form submission and generate dynamic output to ensure that htmlspecialchars is used to prevent XSS. 3) Use MySQL to create a user registration system, and use password_hash and preprocessing statements to enhance security. Mastering these techniques will improve the efficiency of web development.

PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.

PHP is still dynamic and still occupies an important position in the field of modern programming. 1) PHP's simplicity and powerful community support make it widely used in web development; 2) Its flexibility and stability make it outstanding in handling web forms, database operations and file processing; 3) PHP is constantly evolving and optimizing, suitable for beginners and experienced developers.

PHP remains important in modern web development, especially in content management and e-commerce platforms. 1) PHP has a rich ecosystem and strong framework support, such as Laravel and Symfony. 2) Performance optimization can be achieved through OPcache and Nginx. 3) PHP8.0 introduces JIT compiler to improve performance. 4) Cloud-native applications are deployed through Docker and Kubernetes to improve flexibility and scalability.

PHP is suitable for web development, especially in rapid development and processing dynamic content, but is not good at data science and enterprise-level applications. Compared with Python, PHP has more advantages in web development, but is not as good as Python in the field of data science; compared with Java, PHP performs worse in enterprise-level applications, but is more flexible in web development; compared with JavaScript, PHP is more concise in back-end development, but is not as good as JavaScript in front-end development.

PHP and Python each have their own advantages and are suitable for different scenarios. 1.PHP is suitable for web development and provides built-in web servers and rich function libraries. 2. Python is suitable for data science and machine learning, with concise syntax and a powerful standard library. When choosing, it should be decided based on project requirements.

PHP is a scripting language widely used on the server side, especially suitable for web development. 1.PHP can embed HTML, process HTTP requests and responses, and supports a variety of databases. 2.PHP is used to generate dynamic web content, process form data, access databases, etc., with strong community support and open source resources. 3. PHP is an interpreted language, and the execution process includes lexical analysis, grammatical analysis, compilation and execution. 4.PHP can be combined with MySQL for advanced applications such as user registration systems. 5. When debugging PHP, you can use functions such as error_reporting() and var_dump(). 6. Optimize PHP code to use caching mechanisms, optimize database queries and use built-in functions. 7


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

SublimeText3 Linux new version
SublimeText3 Linux latest version

SublimeText3 Mac version
God-level code editing software (SublimeText3)

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.

EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function