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, prepare the application environment, install the following software:
1. Apache
[email protected] 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>[[email protected] 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
[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 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 Jul 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 server IP
$cfg [' Servers '] [$i] [' host '] = ' 192.168.8.24 ';
3, find $cfg [' Servers '] [$i] [' auth_type '] = ' config ';
debug with config in your own machine, and if we have added a cookie to the space on the network, we have modified it to a cookie, which we recommend using cookies.
$cfg [' Servers '] [$i] [' auth_type '] = ' Cookies ';
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, Your server is typically the password for the MySQL user root)
$cfg [' Servers '] [$i] [' password '] = ' Oracle ';
6, find $cfg [' Servers '] [$i] [' only_db '] = ";//If set to a db-name, only (you only have one data set up If you are on this computer or want to set up a server, leave the suggestion blank)
$cfg [' Servers '] [$i] [' only_db '] = ';
7, find $cfg [' defaultlang '] = ' zh '; (here is the language of choice, zh for Simplified Chinese meaning, here do not know to fill GBK to No)
$cfg [' defaultlang '] = ' en ';
8, save after Setup
If " The configuration file now requires a top secret phrase password (blowfish_secret) "then please set your website's cookie in $cfg[' blowfish_secret ' = ';", for example: $cfg [' blowfish_secret '] = ' Any character '; This is due to your "$cfg [' Servers '] [$i] [' auth_type '] = ' cookie '.
Three, test
Open Browser, http://192.168.8.24/phpMyAdmin
Figure one: Login interface
Figure II: Management Interface
----This, phpMyAdmin has been configured successfully!
Note:
above, error, because there is no installation and configuration php-mbstring caused under Linux!
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
MySQL study use of--mysql tools (PhpMyAdmin)
