MySQL Study -- Use of graphical tools in MySQL (phpMyAdmin) and -- mysqlphpmyadmin

MySQL Study -- Use of MySQL tools (phpMyAdmin) and -- mysqlphpmyadmin
MySQL Study-Use of MySQL tool (phpMyAdmin)
System Environment: RedHat EL6Database: MySQL 5.6.4-m7
PhpMyAdmin is a software tool written in PHP. It is a MySQL database management tool based on PHP and based on the Web-Base architecture on the website host, allows administrators to use Web interfaces to manage MySQL databases. 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, allows you to easily create, modify, and delete databases and 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 application environment and install the following software:1. Apache[Root @ mysrv libraries] # rpm-qa | grep httpd

httpd-tools-2.2.15-26.el6.x86_64httpd-manual-2.2.15-26.el6.noarchhttpd-2.2.15-26.el6.x86_64

<strong>[root@mysrv libraries]# rpm -qa |grep mod</strong>mod_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 # depends on the php installation directory.
[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: 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.
# Mv phpMyAdmin-4.4.11-all-languages phpMyAdmin [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

Figure 1: logon page
Figure 2: Management Interface
---- At This Point, phpMyAdmin has been configured successfully!
Note:
The above error occurs because php-mbstring is not installed and configured in linux!

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.