phpMyAdmin Graphics Configuration Features Tutorial

Source: Internet
Author: User
Tags format config interface sql php code php web development query phpmyadmin

In the previous phpMyAdmin tutorial I introduced a number of phpmyadmin configuration knowledge, in the phpmyadmin3.4 version of the graphical phpMyAdmin configuration features, mainly from the phpMyAdmin server configuration, A graphical interface is used to manipulate phpMyAdmin configuration files in phpmyadmin functional configuration, SQL query configuration, framework configuration, phpMyAdmin Import and export configuration. Below I detail how to pass the graph boundary to face phpMyAdmin to configure.

  Preparatory work

The basis for using the phpMyAdmin graphics configuration feature is the need to create a read-write Config folder that is primarily used to store server information for phpMyAdmin configuration, as I have already explained in the phpmyadmin3.4 installation configuration tutorial.

  Introduction to phpMyAdmin Graphic Configuration interface

  Login phpMyAdmin Admin Interface , click the Settings menu, as shown

Start phpMyAdmin Configuration

The phpMyAdmin Settings menu provides a simple management default phpMyAdmin server configuration feature, and you can also import phpMyAdmin configuration information from a saved phpMyAdmin profile or browser. You can also restore phpMyAdmin to the default configuration. When you need more phpMyAdmin configuration management, please click on the setup script in more settings.

  Use phpMyAdmin to configure the server, as shown in

phpMyAdmin Server Profile Configuration

phpMyAdmin Create server Configuration

In the above two phpMyAdmin configuration interfaces, you can create your own phpMyAdmin server-side information by clicking the Create Server button, which can be created to display, download, save, load, and delete the created phpMyAdmin server information. Note that the phpMyAdmin installation environment chooses the appropriate line breaks. Click the question mark Small icon to view this option in the phpMyAdmin configuration file servers configuration option description to help understand.

  phpMyAdmin Feature Configuration Interface

phpMyAdmin Feature Configuration Interface

In the phpMyAdmin function configuration interface, mainly for import/export, security, phpmyadmin a variety of title configuration, phpmyadmin its own system operating environment configuration, such as setting phpMyAdmin upload folder directory, compression settings, login mode security settings.

  phpMyAdmin SQL Query Configuration Interface

phpMyAdmin Configuration of SQL queries

You can use the phpMyAdmin graphical configuration interface for SQL configuration, mainly divided into SQL query settings, SQL query box settings, SQL Checker. The SQL query sets the various restrictions that are used to configure the SQL query primarily; SQL query box sets the main configuration of the SQL query box features, such as editing, creating PHP code, and so on; The SQL Validator is primarily configured to store anonymously for all SQL statements and requires PHP SOAP extension support.

  phpMyAdmin Navigation Frame Interface Configuration

phpMyAdmin Left frame configuration

phpMyAdmin Configuration Right Frame

The phpMyAdmin navigation Framework configuration function is mainly aimed at the left navigation interface and the right homepage frame interface after the login phpMyAdmin.

  phpMyAdmin Import Export Configuration

phpMyAdmin configuration for the various imported file formats supported

phpMyAdmin configured for various exported file formats supported

In the above configuration interface, mainly for the various import export file formats supported by phpMyAdmin, mainly for the phpMyAdmin Import Export database function. It should be noted here that when you configure the phpMyAdmin import Export file format, it is best to import and export the same configuration, otherwise it is easy to cause errors, such as the import of exported CSV format separator inconsistent, can cause import export error.

  Special Reminder : When using the phpMyAdmin graphics configuration feature, be careful to click the Save button below whenever you configure an item.

At this point, the phpMyAdmin graphics configuration function is finished, You can see that using the phpmyadmin3.4 graphical configuration interface to configure phpMyAdmin is more intuitive and easier to understand the configuration options for phpMyAdmin profile config.default.php, which is helpful for friends who first use phpMyAdmin.

  Note : PHP Web Development Tutorials-leapsoul.cn Copyright, reproduced in the form of links to indicate the original source and this statement, thank you.







Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.