CentOS6.6 install and configure phpMyAdmin4.3.13.1

PhpMyAdmin is a PHP-based MySQL database management tool built on the website host in the Web-Base mode. it allows administrators to control and operate MySQL databases on the Web. I. task: back up the MySql database in Linux; ii. method: Use phpMyAdmin to operate the database or use commands to back up data; III. installation process: 1. download phpmyadmin4.3.13

PhpMyAdmin is a PHP-based MySQL database management tool built on the website host in the Web-Base mode. it allows administrators to control and operate MySQL databases on the Web.

I. task: back up the MySql database in Linux;

II. method: Use phpMyAdmin to operate the databaseOr passBack up data using commands;

III. 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. decompress:

[Root @ sky9896var] # tar-zcvf phpMyAdmin-4.3.13.1-all-languages.tar.gz

3. rename the directory:

[Root @ sky9896var] # music phpMyAdmin-4.3.13.1-all-languages.tar.gz phpmyadmin

4. move the folder to the apache Publishing Directory:

[Root @ sky9896var] # mv phpmyadmin/./www/html

5. switch to the release file directory: [root @ sky9896 var] # cd www/html/phpmyadmin

6. configuration file: [root @ sky9896 libraries] # vi config. default. php

Modify config. default. php

$ Cfg ['pmaabsoluteuri '] = 'http: // 117.40.239.9/phpmyadmin ';

$ Cfg ['servers'] [$ I] ['host'] = 'localhost ';

Specifies the host name of the MySQL server. the default value is usually used.

$ Cfg ['servers'] [$ I] ['port'] = '';

Specify the listening port of MySQL. if it is left blank, the default port 3306 is used.

$ Cfg ['servers'] [$ I] ['auth _ type'] = 'cooker ';

Specify the authentication method and connect to Alibaba cloud through the network. to ensure security, you must use cookies.

$ Cfg ['blowfish _ secret'] = 'phpmyadmin ';

Specifies the information used for cookie authentication. it can be any string.

$ Cfg ['servers'] [$ I] ['user'] = 'root ';

Specifies the account of the MySQL administrator.

$ Cfg ['servers'] [$ I] ['password'] = '******';

Password of the MySQLroot account.

7. test: http: // 117.40.239.9/phpmyadmin/enter the account and password

Logon success page:

8. you can operate the MySql database.

9. back up the database using commands:

[Root @ sky9896 data] # mysqldump-h localhost-u root-p ultrax> backultrax. SQL