Installing the configuration under the CentOS 6.6 operating system phpMyAdmin 4.3.13.1

phpMyAdmin is a PHP based on the Web-base schema on the site host. MySQL database management tools that allow administrators to control and manipulate MySQL databases on a web basis.

< Span style= "font-size:18px;line-height:150%;font-family: ' The song Body '; Color:rgb (51,51,51); Background-color:rgb ( 255,255,255); " One, task: Back up the MySQL database in Linux;

Second, the method: through the phpMyAdmin tool operation database or through the command Way backup data ;

Third, the installation process:

1. Download phpmyadmin4.3.13.1

Wgethttps://files.phpmyadmin.net/phpmyadmin/4.3.13.1/phpmyadmin-4.3.13.1-all-languages.tar.gz

2. Unzip:

[Email protected]]# TAR–ZCVF phpmyadmin-4.3.13.1-all-languages.tar.gz

3. Directory Renaming:

[[Email protected]]# mv phpmyadmin-4.3.13.1-all-languages.tar.gz PhpMyAdmin

4. Move the folder to the Apache publishing directory:

[[email protected]] #mv phpmyadmin/./www/html

5. Switch to the Publish file directory: [[email protected] var]# CD Www/html/phpmyadmin

6. Configuration file: [[email protected] libraries]# VI config.default.php

Modifying a configuration file config.default.php

$cfg [' Pmaabsoluteuri ']= ' http://117.40.239.9/phpmyadmin ';

$cfg [' Servers '] [$i] [' Host ']= ' localhost ';

Specifies the hostname of the MySQL server, usually with a default value.

$cfg [' Servers '] [$i] [' Port ']= ';

Specify the listening port for MySQL, and leave blank to use the default port of 3306.

$cfg [' Servers '] [$i] [' Auth_type ']= ' cookies ';

Specifies the authentication method, which must be used for security reasons over a network connection.

$cfg [' Blowfish_secret ']= ' phpMyAdmin ';

Specifies the information that is used for cookie authentication, which can be any string.

$cfg [' Servers '] [$i] [' User ']= ' root ';

Specify the MySQL administrator's account number.

$cfg [' Servers '] [$i] [' Password ']= ' ****** ';

Specifies the password for the Mysqlroot account.

7. Test: http://117.40.239.9/phpmyadmin/input account and password 650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M02/6E /e0/wkiom1wkviuyhfkwaadaqyxcpak772.jpg "title=" 1.JPG "alt=" Wkiom1wkviuyhfkwaadaqyxcpak772.jpg "/>

Login Successful Interface:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/6E/DC/wKioL1WKV_WBD6eEAAMq5xIOCKs748.jpg "title=" 2.JPG " alt= "Wkiol1wkv_wbd6eeaamq5xiocks748.jpg"/>

8. You can operate the MySql database.

9. back up the database in the command mode:

[Email protected] data]# mysqldump-h localhost-u root–p Ultrax >backultrax.sql

This article is from the "linux~dba~mba~edu" blog, make sure to keep this source http://sky9896.blog.51cto.com/2330653/1665068

Installing the configuration under the CentOS 6.6 operating system phpMyAdmin 4.3.13.1