Backend Development
PHP Tutorial
Illustrated tutorial on Phpmyadmin installation and configuration method_PHP tutorial
Illustrated tutorial on Phpmyadmin installation and configuration method_PHP tutorial
Phpmyadmin is a WEB database management tool used by most PHP mysql developers now. The installation and configuration method of Phpmyadmin is also very simple. Below I will introduce you to the diagram of the Phpmyadmin installation and configuration method. Friends who need to know more can refer to it. .
Analysis
Find 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).
4. Find $cfg['PmaAbsoluteUri']
Change it to the URL of phpMyAdmin that you will upload to the space
For example: $cfg['PmaAbsoluteUri'] = ‘http://www.xxx.com/phpmyadmin/’;
5. Find $cfg['Servers'][$i]['host'] = 'localhost'; (usually the default is used, there are exceptions, and no modification is required)
6. Find $cfg['Servers'][$i]['auth_type'] = ‘config’;
Use config for debugging on your own machine; if you use cookies in the Internet space, since we have added the URL before, we will change it to cookies. It is recommended to use cookies here.
7. Search for $cfg['Servers'][$i]['user'] = 'root'; // MySQL user (user name, usually just fill in a few letters here; in special cases, you can enter it in your own machine Use root, which is usually your ftp username on the Internet. The virtual host provider will tell you, generally do not change it.)
8. Find $cfg['Servers'][$i]['password'] = ”; // MySQL password (only needed, just leave it blank)
9. Find $cfg['Servers'][$i]['only_db'] = ”; // If set to a db-name, only (If you only have one data, set it to your database name; if 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. To find $cfg['blowfish_secret'], please set the cookie of your website in the equal sign of $cfg['blowfish_secret'] = ' '; (the cookie is the domain name used to access phpmyadmin), for example: $cfg['blowfish_secret '] = 'www.xinnethz.net';.
How to solve the problem that the additional features of phpmyadmin's linked table have not been activated?
Going back to the picture above, we see that although the phpmyadmin configuration is complete and can be used, there is still a prompt at the bottom that some configuration work has not been completed. One of the prompts: The additional features of the linked table have not been activated, so how to solve it?
First, click the import link, upload scripts/create_tables.sql and execute it to create the phpmyadmin database.
Secondly, find
in the phpmyadmin configuration file config.default.php| The code is as follows | Copy code | ||||||||||||
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
Here I assign the value to leapsoul.cn, this password is used to encrypt Cookies
In phpmyadmin3, there are a total of four login methods Config: Just enter the phpmyadmin remote login address directly. Just set the username and password in the configuration file. http: A dialog box will pop up, enter your username and password and enter Signon: A login method similar to page jump. At the same time, $cfg['Servers'][$i]['SignonURL'] needs to be set. When you enter the remote login address of phpmyadmin, it will automatically jump to signonURL. URL set. Cookie: This is the login method when phpmyadmin is configured. At this point, the entire installation and configuration of phpmyadmin3 is completed. You can experience the new features of the new version of phpmyadmin Statement of this Website
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
Hot AI Tools
Undresser.AI UndressAI-powered app for creating realistic nude photos 
AI Clothes RemoverOnline AI tool for removing clothes from photos. 
Undress AI ToolUndress images for free 
Clothoff.ioAI clothes remover 
AI Hentai GeneratorGenerate AI Hentai for free. 
Hot Article
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago
By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
1 months ago
By 尊渡假赌尊渡假赌尊渡假赌
How Long Does It Take To Beat Split Fiction?
4 weeks ago
By DDD
R.E.P.O. Save File Location: Where Is It & How to Protect It?
4 weeks ago
By DDD
Two Point Museum: All Exhibits And Where To Find Them
1 months ago
By 尊渡假赌尊渡假赌尊渡假赌
Hot Tools
Notepad++7.3.1Easy-to-use and free code editor 
SublimeText3 Chinese versionChinese version, very easy to use 
Zend Studio 13.0.1Powerful PHP integrated development environment 
Dreamweaver CS6Visual web development tools 
SublimeText3 Mac versionGod-level code editing software (SublimeText3)
Hot Topics
PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian
Dec 24, 2024 pm 04:42 PM
PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati 
How To Set Up Visual Studio Code (VS Code) for PHP Development
Dec 20, 2024 am 11:31 AM
Visual Studio Code, also known as VS Code, is a free source code editor — or integrated development environment (IDE) — available for all major operating systems. With a large collection of extensions for many programming languages, VS Code can be c 
How to fix mysql_native_password not loaded errors on MySQL 8.4
Dec 09, 2024 am 11:42 AM
One of the major changes introduced in MySQL 8.4 (the latest LTS release as of 2024) is that the "MySQL Native Password" plugin is no longer enabled by default. Further, MySQL 9.0 removes this plugin completely. This change affects PHP and other app 
How do you parse and process HTML/XML in PHP?
Feb 07, 2025 am 11:57 AM
This tutorial demonstrates how to efficiently process XML documents using PHP. XML (eXtensible Markup Language) is a versatile text-based markup language designed for both human readability and machine parsing. It's commonly used for data storage an 
PHP Program to Count Vowels in a String
Feb 07, 2025 pm 12:12 PM
A string is a sequence of characters, including letters, numbers, and symbols. This tutorial will learn how to calculate the number of vowels in a given string in PHP using different methods. The vowels in English are a, e, i, o, u, and they can be uppercase or lowercase. What is a vowel? Vowels are alphabetic characters that represent a specific pronunciation. There are five vowels in English, including uppercase and lowercase: a, e, i, o, u Example 1 Input: String = "Tutorialspoint" Output: 6 explain The vowels in the string "Tutorialspoint" are u, o, i, a, o, i. There are 6 yuan in total 
7 PHP Functions I Regret I Didn't Know Before
Nov 13, 2024 am 09:42 AM
If you are an experienced PHP developer, you might have the feeling that you’ve been there and done that already.You have developed a significant number of applications, debugged millions of lines of code, and tweaked a bunch of scripts to achieve op 
Top 10 PHP CMS Platforms For Developers in 2024
Dec 05, 2024 am 10:29 AM
CMS stands for Content Management System. It is a software application or platform that enables users to create, manage, and modify digital content without requiring advanced technical knowledge. CMS allows users to easily create and organize content 
How to Add Elements to the End of an Array in PHP
Feb 07, 2025 am 11:17 AM
Arrays are linear data structures used to process data in programming. Sometimes when we are processing arrays we need to add new elements to the existing array. In this article, we will discuss several ways to add elements to the end of an array in PHP, with code examples, output, and time and space complexity analysis for each method. Here are the different ways to add elements to an array: Use square brackets [] In PHP, the way to add elements to the end of an array is to use square brackets []. This syntax only works in cases where we want to add only a single element. The following is the syntax: $array[] = value; Example 
| |||||||||||||
