Home php教程 php手册 phpmyadmin图形配置功能使用教程

phpmyadmin图形配置功能使用教程

Jun 21, 2016 am 08:53 AM
config php phpmyadmin sql

  在之前的phpmyadmin教程中我介绍了不少phpmyadmin配置方面的知识,在phpmyadmin3.4版本中出现了图形化的phpmyadmin配置功能,主要从phpmyadmin服务器配置、phpmyadmin功能配置、SQL查询配置、框架配置、phpmyadmin导入导出配置等几方面以图形界面方式对phpmyadmin配置文件进行操作。下面我详细介绍下怎么通过图形界面对phpmyadmin进行配置。

  准备工作

  使用phpmyadmin图形配置功能的基础是需要创建可读写的config文件夹,其主要用来存放phpmyadmin配置的服务器信息,这一点我已在phpmyadmin3.4安装配置教程中已说明。

  phpmyadmin图形配置界面介绍

  登录phpmyadmin管理界面,点击设置菜单,如图

开始phpmyadmin配置

  在phpmyadmin设置菜单中,主要提供简单管理默认phpmyadmin服务器配置功能,同时你也可以将已保存的phpmyadmin配置文件或游览器中的phpmyadmin配置信息导入,也可以将phpmyadmin恢复成默认配置。当你需要进行更多phpmyadmin配置管理时,请点击更多设置中的安装脚本

  使用phpmyadmin对服务器进行配置,如图

phpmyadmin服务器概要配置

phpmyadmin创建服务器配置

  在上述两个phpmyadmin配置界面中,你可以点击创建服务器按钮创建自己的phpmyadmin服务器端信息,创建后可显示、下载、保存、加载、删除已创建的phpmyadmin服务器信息。注意phpmyadmin的安装环境选择合适的换行符。点击问号小图标可查看此选项在phpmyadmin配置文件中Servers配置选项说明,可帮助理解。

  phpmyadmin功能配置界面

phpmyadmin功能配置界面

  在phpmyadmin功能配置界面,主要进行导入/导出、安全、phpmyadmin各种标题配置、phpmyadmin自身系统运行环境等配置,比如设置phpmyadmin上传文件夹目录、压缩设置、登录方式安全设置等。

  phpmyadmin SQL查询配置界面

phpmyadmin对SQL查询进行相关配置

  可使用phpmyadmin图形配置界面针对SQL进行配置,主要分为SQL查询设置、SQL查询框设置、SQL校验器。SQL查询设置主要配置SQL查询时的各种限制条件;SQL查询框设置主要配置SQL查询框的各种功能,比如编辑、创建PHP代码等功能;SQL校验器主要配置是否针对所有SQL语句以匿名方式存储,其需要PHP SOAP扩展支持。

  phpmyadmin导航框架界面配置

phpmyadmin左侧框架配置

phpmyadmin配置右侧框架

  phpmyadmin导航框架配置功能主要针对登录phpmyadmin后左侧导航界面以及右侧主页框架界面进行相关配置。

  phpmyadmin导入导出配置

phpmyadmin针对支持的各种导入文件格式进行配置

phpmyadmin针对支持的各种导出文件格式进行配置

  在上述配置界面中,主要针对phpmyadmin支持的各种导入导出文件格式进行相关配置,其主要针对的是phpmyadmin导入导出数据库功能。这里需要注意,当你配置phpmyadmin的导入导出文件格式时,最好导入和导出的配置一致,否则容易造成错误,比如导入导出的csv格式分隔符不一致,会造成导入导出错误。

  特别提醒:在使用phpmyadmin图形配置功能时,每当配置一项时注意点击下方的保存按钮。

  至此,phpmyadmin图形配置功能就介绍完了,可以看到使用phpmyadmin3.4图形配置界面配置phpmyadmin时更直观,也更容易理解phpmyadmin配置文件config.default.php的各项配置选项,对初次使用phpmyadmin的朋友会有很大帮助。

  :PHP网站开发教程-leapsoul.cn版权所有,转载时请以链接形式注明原始出处及本声明,谢谢。



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 Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

CakePHP Project Configuration CakePHP Project Configuration Sep 10, 2024 pm 05:25 PM

In this chapter, we will understand the Environment Variables, General Configuration, Database Configuration and Email Configuration in CakePHP.

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian 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

CakePHP Date and Time CakePHP Date and Time Sep 10, 2024 pm 05:27 PM

To work with date and time in cakephp4, we are going to make use of the available FrozenTime class.

CakePHP File upload CakePHP File upload Sep 10, 2024 pm 05:27 PM

To work on file upload we are going to use the form helper. Here, is an example for file upload.

CakePHP Routing CakePHP Routing Sep 10, 2024 pm 05:25 PM

In this chapter, we are going to learn the following topics related to routing ?

Discuss CakePHP Discuss CakePHP Sep 10, 2024 pm 05:28 PM

CakePHP is an open-source framework for PHP. It is intended to make developing, deploying and maintaining applications much easier. CakePHP is based on a MVC-like architecture that is both powerful and easy to grasp. Models, Views, and Controllers gu

How To Set Up Visual Studio Code (VS Code) for PHP Development 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

CakePHP Creating Validators CakePHP Creating Validators Sep 10, 2024 pm 05:26 PM

Validator can be created by adding the following two lines in the controller.

See all articles