Vii. installation of phpMyAdmin

Seven,phpMyAdmininstallation1, Introduction

PhpMyAdminis aPHPas a basis toWeb-baseThe way schemas are on the site hostMySQLdatabase management tools to make it available to managersWebInterface ManagementMySQLdatabase. Take thisWebinterface can be an easy way to enter complexSQLthe better way of grammar, especially to deal with the large amount of data import and export more convenient. One of the bigger advantages is thatPhpMyAdminwith otherPHPexecute on the Web server, but you can use the program from anywhereHTMLpage, which is the remote managementMySQLdatabase, easy to set up, modify, delete database and data table. can also be borrowed fromPhpMyAdminBuild a commonPHPsyntax to facilitate the writing of web pagesSQLgrammatical correctness.

PhpMyAdminis a usePHPsoftware tools that can be written byWebmode control and OperationMySQLdatabase. ThroughPHPMyAdminThe database can be fully manipulated, such as creating, copying, and deleting data, and so on. If the right tool is used,MySQLthe management of the database will become quiteSimple. ApplicationMySQLcommand-line mode requires theMySQLknowledge is very familiar to theSQLlanguagethe same is true. Not only that, if the database has a large number of accesses, the data in the list can be very difficult to read.

There are now many gui MySQL The most outstanding of the client program is based on the Web phpmyadmin tools. This is a MySQL database foreground based on php the tool.

PhpMyAdmin The disadvantage is that you must install the Web Server , so if you do not have the appropriate access rights, other users may be able to compromise SQL data.

Official site: http://www.phpmyadmin.net/

2, installation

Download:

[Email protected] tool]# wget https://files.phpmyadmin.net/phpMyAdmin/4.6.0/phpMyAdmin-4.6.0-all-languages.zip

Extract:

[Email protected]]# unzip Https://files.phpmyadmin.net/phpMyAdmin/4.6.0/phpMyAdmin-4.6.0-all-languages.zip

Copy to the Web page directory:

[Email protected]]# cp-a phpmyadmin-4.6.0-all-languages/usr/local/apache/htdocs/www/

switch to the Web page directory:

[Email protected] tool]# cd/usr/local/apache/htdocs/www/[[email protected] www]# lsindex.html index.php Phpmyadmin-4.6.0-all-languages Xcahe

For ease of management, make a soft connection:

[[email protected] www]# ln-s phpmyadmin-4.6.0-all-languages/phpmyadmin[[email protected] www]# lltotal 16-rw-r--r--1 R Oot Root Apr 8 00:22 index.html-rw-r--r--1 root root 8 04:15 index.phplrwxrwxrwx 1 root root Apr 10 21:08 phpMyAdmin-phpmyadmin-4.6.0-all-languages/drwxr-xr-x root root 4096 Mar 17 06:11phpmyadmin-4.6.0-all-languagesdrwxr-xr-x 6 root root 4096 Apr 8 03:23 Xcahe

3, Configuration:

to configure the phpMyAdmin :

[[Email protected] www]# CD phpmyadmin/# default to provide a sample configuration file, we renamed it, remove Sample[[email protected] phpmyadmin]# CP config.sample.inc.phpconfig.inc.php# before modifying the configuration file, we need to get a number of data as password [[email protected] phpmyadmin]# tr-d ' a-za-z0-9 ' < /dev/urandom|head-30|md5sumae99ac4d5b4f1706aea630af0b8e57db-[[email protected] phpmyadmin]# vim config.inc.php# Find 17 lines, enter the random number you just acquired as the password for the */17 $cfg [' blowfish_secret '] = ' ae99ac4d5b4f1706aea630af0b8e57db '; /* Must FILL in the this for COOKIE auth! */1819/**# Modify Line 31: Change Localhsot to 127.0.0.131 $cfg [' Servers '] [$i] [' host '] = ' 127.0.0.1 '; Save exit!

4, Test

Visit via Browser:

650) this.width=650; "src=" http://s4.51cto.com/wyfs02/M01/7E/F0/wKiom1cNoAPTSya1AAC8uVnrTmE308.jpg "style=" float: none; "title=" 11.jpg "alt=" Wkiom1cnoaptsya1aac8uvnrtme308.jpg "/>

Here you need to enter the root account and password for MySQL:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/7E/F0/wKiom1cNoATAH1rKAANEQjkvwxE926.jpg "style=" float: none; "title=" 12.jpg "alt=" Wkiom1cnoatah1rkaaneqjkvwxe926.jpg "/>

phpMyAdmin installation is successful!

Next: Eight, build WordPress Blog System

This article is from the "Flood City time and Space" blog, please be sure to keep this source http://858004880.blog.51cto.com/7265424/1763273

Vii. installation of phpMyAdmin