Use of graphical tools under MySQL study--mysql (phpMyAdmin)

MySQL study use of--mysql tools (PhpMyAdmin)

System environment: RedHat EL6

Database: MySQL 5.6.4-M7

PHPMyAdmin is aPHPwritten bysoftware Toolsis based on PHP, and is structured in a web-base waywebsiteon the hostMySQLof theDatabase Managementtools that allow administrators to manage web interfacesMySQL Database. This web interface can be an easy way to enter complex SQL syntax, especially to handle the import and export of large amounts of data. One of the bigger advantages is that because phpMyAdmin is executed on the Web server like any other PHP program, you can use the HTML pages generated by these programs anywhere, that is, to manage the MySQL database remotely, to easily create, modify, and deleteDatabaseand data sheets. It is also possible to build common PHP syntax by phpMyAdmin, which is convenient for writing web pages with the correct SQL syntax.

Installing and configuring phpMyAdmin in a Linux environment requires the installation of Apache, PHP, and MySQL, which can be installed in RPM packages or source code, and this case is installed in RPM:

First, the environment preparation, installation of the following software:

1. Apache

[Email protected] libraries]# Rpm-qa |grep httpdhttpd-tools-2.2.15-26.el6.x86_ 64httpd-manual-2.2.15-26.el6.noarchhttpd-2.2.15-26.el6.x86_64[[email protected] libraries]# rpm-qa |grep modmod_ Auth_pgsql-2.0.3-10.1.el6.x86_64mod_authz_ldap-0.26-16.el6.x86_64xorg-x11-drv-modesetting-0.5.0-1.el6.x86_ 64packagekit-gtk-module-0.5.8-21.el6.x86_64module-init-tools-3.9-21.el6.x86_64mod_auth_kerb-5.4-9.el6.x86_ 64mod_wsgi-3.2-3.el6.x86_64mod_ssl-2.2.15-26.el6.x86_64mod_dnssd-0.6-2.el6.x86_64mod_perl-2.0.4-10.el6.x86_ 64mod_auth_mysql-3.0.0-11.el6_0.1.x86_64

2. mysql

[Email protected] libraries]# Rpm-qa |grep mysqlmysql-5.1.66-2.el6_3.x86_64mysql-bench-5.1.66-2.el6_3.x86_ 64mysql-devel-5.1.66-2.el6_3.x86_64mysql-libs-5.1.66-2.el6_3.x86_64mysql-connector-odbc-5.1.5r1144-7.el6.x86_ 64qt-mysql-4.6.2-25.el6.x86_64php-mysql-5.3.3-22.el6.x86_64mysql-devel-5.1.66-2.el6_3. I686mysql-libs-5.1.66-2.el6_3.i686mysql-connector-java-5.1.17-6.el6.noarchmysql-server-5.1.66-2.el6_3.x86_ 64mod_auth_mysql-3.0.0-11.el6_0.1.x86_64mysql-test-5.1.66-2.el6_3.x86_64

3. php

[Email protected] libraries]# Rpm-qa |grep phpphp-pecl-memcache-3.0.5-4.el6.x86_64php-pgsql-5.3.3-22.el6.x86_ 64php-cli-5.3.3-22.el6.x86_64php-pdo-5.3.3-22.el6.x86_64php-mysql-5.3.3-22.el6.x86_ 64php-pecl-apc-3.1.9-2.el6.x86_64php-ldap-5.3.3-22.el6.x86_64php-mbstring-5.3.3-46.el6_6.x86_ 64php-pear-1.9.4-4.el6.noarchphp-xml-5.3.3-22.el6.x86_64php-5.3.3-22.el6.x86_64php-gd-5.3.3-22.el6.x86_ 64php-soap-5.3.3-22.el6.x86_64php-common-5.3.3-22.el6.x86_64php-odbc-5.3.3-22.el6.x86_ 64php-xmlrpc-5.3.3-22.el6.x86_64

Where php-mbstring, in the Redhat installation CD-ROM, need to download from the Internet after installation, after installation requires the following configuration:

[Email protected] libraries]# echo ' extension=mbstring.so ' >>/etc/php.ini #根据php安装目录而定 [[email protected] libraries]# Service httpd Restart

Once the above package is installed, you can enter the installation and configuration of the phpMyAdmin

Second, installation and configuration phpMyAdmin

1. Download the installation and configuration phpMyAdmin

1) go to PhpMyAdmin's official station to download the latest phpMyAdmin
https://www.phpmyadmin.net/downloads/

Download version: phpmyadmin-4.4.11-all-languages.tar.gz

2) Unzip the package to/var/www/html
# tar zxvf phpmyadmin-4.4.11-all-languages.tar.gz-c/var/www/html

3) Modify the directory named PhpMyAdmin
# MV Phpmyadmin-4.4.11-all-languages PhpMyAdmin

[Email protected] oracle]# ls-l/var/www/html/
Total 8
-rw-r--r--1 root root 14:21 index.php
Drwxr-xr-x root root 4096 Jul 17:45 phpMyAdmin

4) Configuration phpMyAdmin
1, edit. /libraries/config.default.php file
2. Find $cfg [' Servers '] [$i] [' host '] = ' localhost '; If the client is allowed to manage remotely, change "localhost" to the server IP

$cfg [' Servers '] [$i] [' host '] = ' 192.168.8.24 ';
3, find $cfg [' Servers '] [$i] [' auth_type '] = ' config ';
Debug in your own machine with config; if the space on the network with a cookie, here we have already added the URL in the previous, the change to a cookie, here is recommended to use cookies.

$cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';
4. Find $cfg [' Servers '] [$i] [' user '] = ' root '; MySQL user (MySQL username, root in his machine)

$cfg [' Servers '] [$i] [' user '] = ' root ';
5. Find $cfg [' Servers '] [$i] [' password '] = '; MySQL password (mysql user's password, their server is generally the password of the MySQL user root)

$cfg [' Servers '] [$i] [' password '] = ' Oracle ';
6. Find $cfg [' Servers '] [$i] [' only_db '] = '; If set to a db-name, only (you have only one data set up; If you're on this computer or want to build a server, leave the suggestion blank)

$cfg [' Servers '] [$i] [' only_db '] = ';
7, find $cfg [' defaultlang '] = ' zh '; (Here is the choice of language, zh for Simplified Chinese meaning, here do not know to fill GBK to No)

$cfg [' defaultlang '] = ' en ';
8, save after setting
  If "configuration file now requires top secret phrase password (blowfish_secret)" then please $cfg[' Blowfish_secret '] = '; Set your website's cookie within the equals sign, for example: $cfg [' blowfish_secret '] = ' any character '; This is because of your "$cfg [' Servers '] [$i] [' Auth_type ' = ' cookie ' for the reason.
third, test
Open Browser, http://192.168.8.24/phpMyAdmin

650) this.width=650; "Src=" http://img.blog.csdn.net/20150715161941423?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

Figure One: Login interface

650) this.width=650; "Src=" http://img.blog.csdn.net/20150715162028340?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

Figure II: Management interface

----This, phpMyAdmin has been configured successfully!

Attention:

650) this.width=650; "Src=" http://img.blog.csdn.net/20150715162349053?watermark/2/text/ Ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity/center "Style=" Border:none; "/>

Above, error, because there is no installation and configuration php-mbstring caused under Linux!

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1674979

MySQL study use of--mysql tools (PhpMyAdmin)