phpmyadmin的安装与使用图文教程第1/2页
PhpMyAdmin简介
PhpMyAdmin是一个用PHP编写的，可以通过互联网控制和操作MySQL。通过phpMyAdmin可以完全对数据库进行操作，例如建立、复制/删除数据等等。
安装篇
第一步：下载phpmyadmin
到天空软件站下载phpmyadmin，地址：http://tele.skycn.com/index.html，搜索phpmyadmin即可出现最新更新的phpmyadmin版本，建议使用多国语言版，这样才出现简体中文字符。
第二步：本地配置phpmyadmin
把下载回来的phpmyadmin解压出来，并将解压出来的此文件夹改名为phpmyadmin，然后定位到此文件夹的/phpmyadmin/libraries下的config.default.php，把它复制到/phpmyadmin并重命名为config.inc.php
用记事本打开config.inc.php，编辑--查找...
查找$cfg['PmaAbsoluteUri'] = '';
将其改成
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin';
[也就是您的网站服务的IP或域名加上你的phpmyadmin的文件夹名]
查找$cfg['Servers'][$i]['auth_type'] = 'config';
把config改成 http，即
$cfg['Servers'][$i]['auth_type'] = 'http';
[改成http后，就可以像登录路由器那样，出现一个登录对话框]
保存退出。
第三步：上传phpmyadmin
本地配置完毕后，就二进制上传到你的服务器或虚拟服务器上的web文件夹httproot，有些服务器的根文件夹叫htdocs。
用浏览器输入地址，例如：http://www.jb51.net/phpmyadmin，就会跳出一个输入用户名和密码的对话框，如下图所示：
然后我们就把服务器提供商提供给我们具有读写权限的帐号和密码填入进去，即可进入你的phpmyadmin页面了。如果出现的界面不是中文，安装了多国语言版的版本，可以在右边如图的这个位置选择简体中文
到此为止，整个phpmyadmin的安装结束。
小技巧
聪明的你是否发觉上面有什麽不对了呢？如果每个人都照我这样做那麽..是不是每个人的phpMyAdmin的位置都在http://网址/phpMyAdmin这里？这种情况是可以改变的..只要将phpMyAmin资料夹更名即可。若我想要更名为pma（各取一个字，方便记忆），路径:/usr/local/apache/htdocs/pma，如此别人就无法去解的phpMyAdmin的位置...只剩下你自己知道了...
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
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1389
52
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
Explain JSON Web Tokens (JWT) and their use case in PHP APIs.
Apr 05, 2025 am 12:04 AM
JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,
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
Explain late static binding in PHP (static::).
Apr 03, 2025 am 12:04 AM
Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.
What are PHP magic methods (__construct, __destruct, __call, __get, __set, etc.) and provide use cases?
Apr 03, 2025 am 12:03 AM
What are the magic methods of PHP? PHP's magic methods include: 1.\_\_construct, used to initialize objects; 2.\_\_destruct, used to clean up resources; 3.\_\_call, handle non-existent method calls; 4.\_\_get, implement dynamic attribute access; 5.\_\_set, implement dynamic attribute settings. These methods are automatically called in certain situations, improving code flexibility and efficiency.
Explain the match expression (PHP 8 ) and how it differs from switch.
Apr 06, 2025 am 12:03 AM
In PHP8, match expressions are a new control structure that returns different results based on the value of the expression. 1) It is similar to a switch statement, but returns a value instead of an execution statement block. 2) The match expression is strictly compared (===), which improves security. 3) It avoids possible break omissions in switch statements and enhances the simplicity and readability of the code.
