MySQLStudy-Use of graphical tools in MySQL (phpMyAdmin)

MySQLStudy-MySQL-type tool usage (phpMyAdmin) system environment: RedHatEL6 Database: MySQL5.6.4-m7phpMyAdmin is a software tool written in PHP and is based on PHP, mySQL database management tools based on Web-Base architecture on website hosts, allowing managers to manage using Web interfaces

MySQL Study-MySQL-type tool usage (phpMyAdmin) system environment: RedHat EL6 Database: MySQL 5.6.4-m7 php MyAdmin is a software tool written in PHP, based on PHP, mySQL database management tools based on Web-Base architecture on website hosts, allowing managers to manage using Web interfaces

MySQL Study-Use of MySQL tool (phpMyAdmin)

System Environment: RedHat EL6

Database: MySQL 5.6.4-m7

PhpMyAdmin is an applicationPHPCompiledSoftware ToolsIt is based on PHP and structured in the Web-Base ModeWebsiteHostMySQLOfDatabase ManagementTools for managers to manage using Web interfacesMySQL database. By using this Web interface, you can become a better way to easily input complicated SQL syntax, especially to process the import and export of a large amount of data. One of the biggest advantages is that phpMyAdmin runs on the Web server like other PHP programs, but you can use the HTML pages generated by these programs anywhere, that is, remote management of MySQL databases, easy creation, modification, and deletionDatabaseAnd data tables. You can also use phpMyAdmin to create common php syntaxes to facilitate the correctness of the SQL syntaxes required for compiling webpages.

To install and configure phpMyAdmin in a Linux environment, you need to install Apache, PHP, and MySQL. These software can be installed using the RPM package or source code. In this case, the RPM installation is used:

1. Prepare the environment and install the following software:

1. Apache

[root@mysrv 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[root@mysrv 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

[root@mysrv 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

[root@mysrv 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

The php-mbstring is not found on the RedHat installation disc. You need to download it from the Internet and install it. The following configurations are required after installation:

[Root @ mysrv libraries] # echo 'extension = mbstring. so'>/etc/php. ini # depending on the php installation directory, set [root @ mysrv libraries] # service httpd restart

After the preceding software package is installed, you can install and configure phpMyAdmin.

Ii. install and configure phpMyAdmin

1. Download and install and configure phpMyAdmin

1) download the latest phpMyAdmin from the official website of phpMyAdmin.
Https://www.phpmyadmin.net/downloads/

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

2) decompress the software package to/var/www/html
# Tar zxvf phpMyAdmin-4.4.11-all-languages.tar.gz-C/var/www/html

3) change the directory name to phpMyAdmin.
# PhpMyAdmin mv phpMyAdmin-4.4.11-all-languages

[Root @ mysrv oracle] # ls-l/var/www/html/
Total 8
-Rw-r -- 1 root 17 Jul 15 index. php
Drwxr-xr-x 10 root 4096 Jul 14 :45 phpMyAdmin

4) Configure phpMyAdmin
1. Edit the./libraries/config. default. php file.
2. Search for $ cfg ['servers'] [$ I] ['host'] = 'localhost'. If you allow remote client management, change "localhost" to the server ip address.

$ Cfg ['servers'] [$ I] ['host'] = '2017. 168.8.24 ';
3. Search for $ cfg ['servers'] [$ I] ['auth _ type'] = 'config ';
Debug config in your own machine. If you use cookies in the network space, now we have added the web site before, and then modify it to a cookie. We recommend that you use cookies here.

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';
4. Find $ cfg ['servers'] [$ I] ['user'] = 'root'; // MySQL user (mysql user name, use root on your machine ;)

$ Cfg ['servers'] [$ I] ['user'] = 'root ';
5. Find $ cfg ['servers'] [$ I] ['Password'] = ''; // MySQL password (mysql user password, your server is generally the root password of the mysql user)

$ Cfg ['servers'] [$ I] ['Password'] = 'oracle ';
6. Search for $ cfg ['servers'] [$ I] ['only _ db'] = ''; // If set to a db-name, only (if you only have one data, set it. If you want to set up a server on your local computer, leave it blank)

$ Cfg ['servers'] [$ I] ['only _ db'] = '';
7. find $ cfg ['defaultlang '] = 'zh'. (select the language here. zh indicates the meaning of Simplified Chinese. You do not know whether to fill in gbk or not)

$ Cfg ['defaultlang '] = 'en ';
8. Save the settings.
If the following error occurs: "the configuration file now requires a top secret phrase password (blowfish_secret)", set the cookie for your website in the equal sign of $ cfg ['blowfish _ secret'] =, example: $ cfg ['blowfish _ secret'] = 'arbitrary characters '; this is because your "$ cfg ['servers'] [$ I] ['auth _ type'] = 'cookies.
Iii. Test
Open the browser, http: // 192.168.8.24/phpMyAdmin

650) this. width = 650; "src =" http://img.blog.csdn.net/20150715161941423? Watermark/2/text/plain/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA ==/ dissolve/70/gravity/Center "alt =" "style =" border: none; "/>

: Login interface

650) this. width = 650; "src =" http://img.blog.csdn.net/20150715162028340? Watermark/2/text/plain/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA ==/ dissolve/70/gravity/Center "alt =" "style =" border: none; "/>

: Management Interface

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

Note:

650) this. width = 650; "src =" http://img.blog.csdn.net/20150715162349053? Watermark/2/text/plain/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA ==/ dissolve/70/gravity/Center "alt =" "style =" border: none; "/>

The above error occurs because php-mbstring is not installed and configured in linux!