Manually install phpmyadmin under windows-phpMyAdmin-php.cn

Home

Database

phpMyAdmin

Manually install phpmyadmin under windows

王林

Dec 13, 2019 am 11:24 AM

phpmyadminwindowsInstall

Manually install phpmyadmin under windows

1. Go directly to the official website to download the file, phpMyAdmin-4.3.7-all-languages.zip

2. Unzip it to the web directory and name it phpMyAdmin (I nginx is used here, and the web root directory is configured as E:\webroot)

3. Configure the config file, open the config.default.php file under libraries, find the following items in turn, and configure them according to the instructions ：

(1) Access URL

$cfg[&#39;PmaAbsoluteUri&#39;] = &#39;&#39;;这里填写phpmyadmin的访问网址 ,我这里为http://localhost:8088/phpMyAdmin

(2) mysql host information

$cfg[&#39;Servers&#39;][$i][&#39;host&#39;] = &#39;localhost&#39;; // MySQL hostname or IP address

Fill in the localhost or the IP address of the server where mysql is located, if mysql On the same server as the phpmyadmin, use the default localhost

$cfg[&#39;Servers&#39;][$i][&#39;port&#39;] = &#39;&#39;; // MySQL port - leave blank for default port

mysql port. If it is the default 3306, leave it empty.

(3)mysql username and password

$cfg[&#39;Servers&#39;][$i][&#39;user&#39;] = &#39;root&#39;; // MySQL user 访问phpmyadmin使用的mysql用户名 
fg[&#39;Servers&#39;][$i][&#39;password&#39;] = &#39;&#39;; // MySQL password (only needed对应上述mysql用户名的密码

(4) Authentication method

$cfg[&#39;Servers&#39;][$i][&#39;auth_type&#39;] = &#39;cookie&#39;;

There are four modes to choose from, cookie, http, HTTP , config

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.

When this item is set to cookie, http or HTTP, logging in to phpmyadmin requires a data username and password for verification, as follows:

The PHP installation mode is Apache, and http and cookies can be used;

PHP installation mode is CGI, you can use cookies

(5) Setting of phrase password (blowfish_secret)

$cfg[&#39;blowfish_secret&#39;] = &#39;&#39;;

If the authentication method is set to cookie, you need to set the phrase password , 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.

The installation is complete!

Recommended related articles and tutorials: phpmyadmin tutorial

The above is the detailed content of Manually install phpmyadmin under windows. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

phpMyAdmin's Function: Interacting with MySQL (SQL)May 07, 2025 am 12:16 AM

phpMyAdmin simplifies MySQL database management through the web interface. 1) Create databases and tables: Use graphical interface to operate easily. 2) Execute complex queries: such as JOIN query, implemented through SQL editor. 3) Optimization and best practices: including SQL query optimization, index management and data backup.

MySQL vs. phpMyAdmin: Understanding the Key DifferencesMay 06, 2025 am 12:17 AM

MySQL is a database management system, and phpMyAdmin is a web tool for managing MySQL. 1.MySQL is used to store and manage data and supports SQL operations. 2.phpMyAdmin provides a graphical interface to simplify database management.

phpMyAdmin: Accessing and Managing MySQL DatabasesMay 05, 2025 am 12:08 AM

phpMyAdmin provides an intuitive interface through the browser to help manage MySQL databases. 1. Create a database and table: Enter the code in the "SQL" tab and execute it. 2. Optimize table: Use the "OPTIMIZETABLE" command to improve query performance. 3. Permission management: Use the "SHOWGRANTS" and "GRANT" commands to check and modify permissions. 4. Performance optimization: regularly optimize tables, use indexes, and avoid large-scale imports.

MySQL: The Engine, phpMyAdmin: The User InterfaceMay 04, 2025 am 12:02 AM

MySQL and phpMyAdmin are powerful database tools, and their combination provides convenience for database management. MySQL's high performance, scalability and security make it the first choice for database engines, while phpMyAdmin's database management, data import and export, and user management capabilities simplify database operations. The actual case shows how they work together, and provides optimization strategies such as index optimization, query optimization, caching mechanism and phpMyAdmin configuration tuning to improve performance.

The Role of SQL in phpMyAdmin: A Deep DiveMay 03, 2025 am 12:07 AM

SQL's role in phpMyAdmin is multifaceted, including data operation, database design, optimization and maintenance. 1.SQL is used for basic data operations, such as querying and inserting data. 2.SQL supports complex queries, view creation and stored procedure writing. 3. In phpMyAdmin, SQL commands are executed through the MySQL server, and the results are displayed in a table form. 4. Users can perform performance optimization through SQL, such as indexing and query optimization.

Beyond the Interface: phpMyAdmin and the Power of SQLMay 02, 2025 am 12:21 AM

The combination of phpMyAdmin and SQL allows users to directly enter and execute SQL commands, implementing more complex queries and database management. 1) In phpMyAdmin, you can execute SQL commands, such as SELECTFROMusersWHEREage>30; 2) Use the EXPLAIN command to analyze the execution plan of the query and optimize performance; 3) By creating indexes, avoiding SELECT and using LIMIT, the query efficiency can be significantly improved.

phpMyAdmin: Managing SQL Databases with EaseMay 01, 2025 am 12:24 AM

phpMyAdmin is a tool for managing MySQL and MariaDB databases through a web interface. 1) Create a database: Use the CREATEDATABASE command. 2) Create table and insert data: Use the CREATETABLE and INSERTINTO commands. 3) Create a view: Use the CREATEVIEW command to simplify querying. 4) Optimize table: Use the OPTIMIZETABLE command to improve query speed.

Is phpMyAdmin a Database? Clarifying Its RoleApr 30, 2025 am 12:13 AM

phpMyAdminisnotadatabase;it'saweb-basedtoolformanagingMySQLandMariaDBdatabases.Itoffersfeatureslikecreating/modifyingdatabases,executingSQLqueries,managingusers/permissions,andimporting/exportingdata.

See all articles