"DNS Service Record" + "Mariadb,mysql database"

DNS service to fill in the record,
1) About: servername in the configuration/etc/resolv.conf of the secondary DNS server points to itself.
Slaves
Vim/etc/named.rfc1912.zones
"Add changes to"
Zone "Hxl.com" in {
Type slave;
Masters {172.25.254.206;};
File "Slaves/hxl.com.zone";
allow-update {none;};
};
Vim/etc/named.rfc1912.zones on the primary DNS server
In the zone "hxl.com" in {
~
Allow-transfer {172.25.254.106;}; Add
};

"Remember to restart the service after the operation Oh ~"
2) About: The secondary DNS server automatically updates the domain name maintained by the master server.
Primary server Profile Maintenance domain join: also-notify {172.25.254.106;};
In the zone "hxl.com" in {
~
Allow-transfer {172.25.254.106;};
also-notify {172.25.254.106;}; Add
};

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/8A/F0/wKiom1g_qlKxRA3HAACvDTGifQU872.png "style=" float: none; "title=" 1.png "alt=" Wkiom1g_qlkxra3haacvdtgifqu872.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/8A/F0/wKiom1g_qlOQaJSDAABwkjqww5k821.png "style=" float: none; "title=" 2.png "alt=" Wkiom1g_qloqajsdaabwkjqww5k821.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/8A/EC/wKioL1g_qlWR6Yn4AADAlRjZtNk838.png "style=" float: none; "title=" 3.png "alt=" Wkiol1g_qlwr6yn4aadalrjztnk838.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/8A/F0/wKiom1g_qlfxJOg6AACzYWObpeA779.png "style=" float: none; "title=" 4.png "alt=" Wkiom1g_qlfxjog6aaczywobpea779.png "/>

"To change the value of the. zone file for the maintenance domain to a 10-digit number before the serial is changed, because the secondary DNS server sees that the serial value of the file sent by the primary server is different, the file change" "Remember: nameserver IP is not the same as the DNS server , so point to IP all for yourself "

3) Remote Change the primary DNS service configuration "SELinux shut down to do the experiment, otherwise the remote modification can not be successful", before doing the experiment, you first put the source/var/named/directory to 770 permissions "so that the host you specified in the modification of your file will have effect", and then for insurance period You take the original. zone file cp-p to/mnt/to make a backup, good recovery.
Vim/etc/named.rfc1912.zones on the primary DNS server
In the zone "hxl.com" in {
~
allow-update {172.25.254.106;}; Add
};
"Do the following on the specified host with update permissions"
Nsupdate
> Server IP (Primary DNS)
> Update modified Information "Example: Delete www.HXL.com (remove all. zone information); add www.HXL.com 86400 A 172.25.254.166 (add information). 86400 means one day. 】
> send "Sent"
> Quit "Quit"

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/8A/EC/wKioL1g_qsLDauXNAACMavS-xrg094.png "style=" float: none; "title=" 5.png "alt=" Wkiol1g_qsldauxnaacmavs-xrg094.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/8A/F0/wKiom1g_qsOiLzTxAADHS_nwEOw623.png "style=" float: none; "title=" 6.png "alt=" Wkiom1g_qsoilztxaadhs_nweow623.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/8A/EC/wKioL1g_qsOBQVT5AAC_etfEeeA129.png "style=" float: none; "title=" 8.png "alt=" Wkiol1g_qsobqvt5aac_etfeeea129.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/8A/EC/wKioL1g_qsTwXjy-AADIZz6XUto294.png "style=" float: none; "title=" 7.png "alt=" Wkiol1g_qstwxjy-aadizz6xuto294.png "/>

4) Set the key to indicate that only the key user has the update permission. Encryption is HMAC-MD5 "similar/etc/rndc.key"
"Add encryption Key"
Dnssec-keygen-a hmac-md5-b 128-n Host Hxl "-a hmac-md5 means that encryption is Hmac-md5;-b 128 means that the encryption length is 128;-n HOST means that the cryptographic service is Hsot (encrypted for the DNS service) HXL is a noun for encrypting files "
HMAC-MD5 is symmetric encrypted. Generate KHXL...KEY;KHXL ... Private Two files and send the files to your updatable host (SCP KHXL ... * [email protected]:/mnt/].
"Copy the/etc/rndc.key file to/etc/hxl.key; The format is the same as the encryption method. You can rename the ' Plus ' in the Khxl...key.

"Join the/etc/named.conf file on the primary DNS server"
43:include "/etc/hxl.key";
"In the/etc/named.rfc1912.zones file of the primary DNS server"
Locate the area of the domain you are maintaining, and change the allow-update line to: allow-update{key hxl;};
"Update with Command remote"
Nsupdate-k KHXL ... Private
> "Point to Your actions"

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/8A/F0/wKiom1g_qw3w0vpoAADiEB3k6ng881.png "style=" float: none; "title=" 12.png "alt=" Wkiom1g_qw3w0vpoaadieb3k6ng881.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/8A/EC/wKioL1g_qw7DUabxAABQuYIEg9g045.png "style=" float: none; "title=" 13.png "alt=" Wkiol1g_qw7duabxaabquyieg9g045.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/8A/F0/wKiom1g_qw_yr_ZFAACMAXYifDI453.png "style=" float: none; "title=" 14.png "alt=" Wkiom1g_qw_yr_zfaacmaxyifdi453.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/8A/EC/wKioL1g_qxCAnokzAAAsm-EPPBc479.png "style=" float: none; "title=" 15.png "alt=" Wkiol1g_qxcanokzaaasm-eppbc479.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/8A/F0/wKiom1g_qxKi07-uAACiMQFGp1o342.png "style=" float: none; "title=" 16.png "alt=" Wkiom1g_qxki07-uaacimqfgp1o342.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/8A/F0/wKiom1g_qxLQmN7KAABKrOfAllY306.png "style=" float: none; "title=" 17.png "alt=" Wkiom1g_qxlqmn7kaabkrofally306.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/8A/EC/wKioL1g_qxaDvY7cAADeEMPaIkQ606.png "style=" float: none; "title=" 18.png "alt=" Wkiol1g_qxadvy7caadeempaikq606.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/8A/EC/wKioL1g_qxiQek_VAADNenEFJL8474.png "style=" float: none; "title=" 19.png "alt=" Wkiol1g_qxiqek_vaadnenefjl8474.png "/>

5) DDNS Dynamic DNS Specifies the domain's automatic configuration "first change the name of your machine, and make a distinction, instead of TV." Hxl.com, and will Bootproto=dhcp, add dns1=172.25.254.206 (DNS host) "Peanut shell.
in the DNS host
 1. Download the DHCPD software, start the service
 2. Modify the/etc/dhcp/dhcpd.conf file
[number of rows]   (something was removed in the middle, See your own files in the appropriate location)
  7. Option Domain-name "hxl.com";
  8. Option domain-name-servers172.25.254.206;
 14. Ddns-update-style interim;  "Key Note! : This is usually commented out, but this time with DNS, so open. The Open value is interim "
 30. Subnet 172.25.254.0 netmask255.255.255.0 {
    range172.25.254.162 172.25.254.166;
     option routers 172.25.254.206;
}
"In the above procedure complete the following add content"
Key HXL {
    algorithm hmac-md5;
    secret   ~~~~~~~~;  "This is the generated password, in your khxl...* file There is this code, copied over. No, this place does not "", don't mess with this is the rule, man 5 dhcpd.conf "
};
  
Zone hxl.com. {
    primary 127.0.0.1;  "This is a loopback interface, because you are the host of the DNS service, access speed with a loopback interface"
    key Hxl ;
}

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/8A/F0/wKiom1g_q2KjocXWAABRpgCWSUM277.png "style=" float: none; "title=" 20.png "alt=" Wkiom1g_q2kjocxwaabrpgcwsum277.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/8A/EC/wKioL1g_q2KTT0SbAADEx6ydfv8023.png "style=" float: none; "title=" 21.png "alt=" Wkiol1g_q2ktt0sbaadex6ydfv8023.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/8A/EC/wKioL1g_q2OQLCVIAACOJ4k5IZQ079.png "style=" float: none; "title=" 22.png "alt=" Wkiol1g_q2oqlcviaacoj4k5izq079.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/8A/F0/wKiom1g_q2PQjWLlAADCK686tjg567.png "style=" float: none; "title=" 23.png "alt=" Wkiom1g_q2pqjwllaadck686tjg567.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/8A/EC/wKioL1g_q2XD42veAAPSR1B9B60012.png "style=" Float:none; "title=" 24.png "alt=" Wkiol1g_q2xd42veaapsr1b9b60012.png "/>

" test, the host side only modify the DNS scope, restart the DHCPD service, the specified machine will automatically change the IP and the specified domain. You do not have to modify the. zone file every time to specify TV.HXL.com IP. Doing this will automatically correspond to the "
 1." For example, the IP digTV.HXL.com appears in the specified machine is 172.25.254.162.
 2. Restart the DHCPD service when the scope of the dhcpd.conf file is changed to 172.25.254.163-172.25.254.166 in the primary DNS server.
 3. Restart the network service in the specified machine, at which point your IP becomes 172.25.254.163, then dig TV. When hxl.com, its IP will automatically be 172.25.254.163.




            ************************
            ************** Database Operations *********
            *********************************** *
Mariadb-server is the installation package for the database software
MARIADB, an application service software that executes the MySQL database under Linux. Port is 3306
Initial operation
1.yum install mariadb-server.x86_64-y
2.netstat-antlpe | grep mysql  "View Interface"
"Modify the file, Make it invisible port in the Internet, compare the database, not everyone casually access "
VIM/ETC/MY.CNF
10:skip-networking=1
Restart Service, 2 operation will not see

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/8A/EC/wKioL1g_rsihaoNCAADEt90F9t0478.png "style=" float: none; "title=" 1.png "alt=" Wkiol1g_rsihaoncaadet90f9t0478.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/8A/F0/wKiom1g_rsmy3q54AAB0GowK0gk269.png "style=" float: none; "title=" 2.png "alt=" Wkiom1g_rsmy3q54aab0gowk0gk269.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/8A/EC/wKioL1g_rszBhmKjAADQF03RQdI325.png "style=" float: none; "title=" 3.png "alt=" Wkiol1g_rszbhmkjaadqf03rqdi325.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/8A/F0/wKiom1g_rs2CKoaGAABhPxMIr8Y572.png "style=" float: none; "title=" 4.png "alt=" Wkiom1g_rs2ckoagaabhpxmir8y572.png "/>

The Configure Security Wizard
Mysql_secure_installation "Main set password, other one need in set, default carriage return"
Mysql-uroot-p "Password Login" after completion
"Common Database Command" "'; ' End and Execute "
SHOW DATABASES; [View database name]
650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/8A/F0/wKiom1g_r0HiYddHAACFpzDRm1I861.png "title=" 5.png "  alt= "Wkiom1g_r0hiyddhaacfpzdrm1i861.png"/>use MySQL; [Go to MySQL database]
650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/8A/EC/wKioL1g_r2LBVSw7AABrDqyUxho450.png "title=" 6.png "    alt= "Wkiol1g_r2lbvsw7aabrdqyuxho450.png"/>show TABLES; [Show MySQL database form]
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/8A/F0/wKiom1g_r27gujCIAABhH__INog255.png "title=" 7.png " alt= "Wkiom1g_r27gujciaabhh__inog255.png"/>select * from user; [Query MySQL for all information in the user table]
650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/8A/EC/wKioL1g_r3ygfTAfAACQkw0Z1tQ352.png "title=" 8.png "  alt= "Wkiol1g_r3ygftafaacqkw0z1tq352.png"/>select Host from user; [Query MySQL for all host information in user table] "If you are in MySQL, do not, user change to Mysql.user"

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/8A/F0/wKiom1g_r4-g_yLRAABcWZBjPKc785.png "style=" float: none; "title=" 9.png "alt=" Wkiom1g_r4-g_ylraabcwzbjpkc785.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/8A/F0/wKiom1g_r5CxputcAABob3xF4nI393.png "style=" float: none; "title=" 10.png "alt=" Wkiom1g_r5cxputcaabob3xf4ni393.png "/>

DESC user; [Querying the data structure of the user table]
650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/8A/F0/wKiom1g_r6HxGFYXAACFc303XD4610.png "title=" 11.png    "alt=" Wkiom1g_r6hxgfyxaacfc303xd4610.png "/>create DATABASE HXL; [Create HXL Database]
650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/8A/EC/wKioL1g_r7CzyD-yAABOx5NvCuU567.png "title=" 12.png "alt=" Wkiol1g_r7czyd-yaabox5nvcuu567.png "/>create TABLE utab (username varchar (TEN) not null,password varchar () No Tnull,age varchar (4)); [Create Utab data table with username,password,age three items, first two not empty, type varchar ()]
650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/8A/EC/wKioL1g_r8PSMSU2AABkDXjQhd0589.png "title=" 13.png "alt=" Wkiol1g_r8psmsu2aabkdxjqhd0589.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/8A/EC/wKioL1g_sAzCSgP5AABJX3_PZoU663.png "style=" float: none; "title=" 14.png "alt=" Wkiol1g_sazcsgp5aabjx3_pzou663.png "/>

INSERT into Utab VALUES (' hxl ', ' 123 ', ' 20 '); [Inserts data into the Utab. If you can empty the item, you want to set it to null, expressed as ", to write on]
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/8A/F0/wKiom1g_sCSzmd9GAAFOPFDxROc941.png "title=" 15.png "alt=" Wkiom1g_scszmd9gaafopfdxroc941.png "/>alter TABLE Utab ADD class varchar (8) after password; [Add Item: Represents a new addition class, added after password]
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/8A/F0/wKiom1g_sDzxs8eYAABqEpxFGb8726.png "title=" 16.png  "alt=" Wkiom1g_sdzxs8eyaabqepxfgb8726.png "/>update utab SET; [Set everyone Class=1]
650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/8A/EC/wKioL1g_sEOTzfHNAABbOIJb5cA557.png "title=" 17.png "alt=" Wkiol1g_seotzfhnaabboijb5ca557.png "/>update utab SET WHERE username= ' HXL '; [indicates that the class value of username to HXL is set to 3]
650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/8A/EC/wKioL1g_sGnBA2ioAABpJ1l8DCg610.png "title=" 18.png "alt=" wkiol1g_sgnba2ioaabpj1l8dcg610.png "/>drop database hxl; [means deleting HXL databases in the database]
650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/8A/F1/wKiom1g_sHuCEUPKAABSiGlJWvY753.png "title=" 19.png "alt=" Wkiom1g_shuceupkaabsigljwvy753.png "/>" Set User and access rights "
1. Create a user
CREATE USER [email protected] indentified by ' 123 '; [Create a local user named Hxl with a password of 123]
CREATE USER [email protected] '% ' indentified by ' 1234 '; [Create a remote user 1234]

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M01/8A/EC/wKioL1g_sJHwMvmGAABpF-rIZw0393.png "style=" float: none; "title=" 20.png "alt=" Wkiol1g_sjhwmvmgaabpf-rizw0393.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/8A/F1/wKiom1g_sJLCy4JlAABpkjnaP5Y371.png "style=" float: none; "title=" 21.png "alt=" Wkiom1g_sjlcy4jlaabpkjnap5y371.png "/>

2. Add permissions for new users
GRANT insert,create,delete,select,update On * * to [email protected]; [Indicates a user-created permission granted to [email protected], in * * (all databases)]

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/8A/F1/wKiom1g_sKjhh2O7AABst6SXo2s506.png "title=" 22.png "alt=" Wkiom1g_skjhh2o7aabst6sxo2s506.png "/>3. Overloaded Authorization table
FLUSH privileges;

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/8A/F1/wKiom1g_sNHijuCzAACG3Dy0faY562.png "title=" 23.png "alt=" Wkiom1g_snhijuczaacg3dy0fay562.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/8A/F1/wKiom1g_sPaBQaKdAABNhQLLBQw271.png "style=" float: none; "title=" 24.png "alt=" Wkiom1g_spabqakdaabnhqllbqw271.png "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/8A/ED/wKioL1g_sPaD6Z1NAABQvAiZFVo935.png "style=" float: none; "title=" 25.png "alt=" Wkiol1g_spad6z1naabqvaizfvo935.png "/>

4. Revoke User Rights
REVOKE insert,create,delete,update on * * FROM [email protected];

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/8A/ED/wKioL1g_sQ-C2xGnAACAcZWk1BE823.png "style=" float: none; "title=" 27.png "alt=" Wkiol1g_sq-c2xgnaacaczwk1be823.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/8A/ED/wKioL1g_sRCzz8WbAAB1tY_cFJM420.png "style=" float: none; "title=" 28.png "alt=" Wkiol1g_srczz8wbaab1ty_cfjm420.png "/>

5. Delete a user
DROP USER [email protected];

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M00/8A/F1/wKiom1g_sRzSh1bcAACK8c8WV-U919.png "title=" 29.png "alt=" Wkiom1g_srzsh1bcaack8c8wv-u919.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M02/8A/ED/wKioL1g_sViyc-0_AAAs0Cw9TKo515.png "title=" 30.png "alt=" Wkiol1g_sviyc-0_aaas0cw9tko515.png "/>

6. Shutting down the database service
Systemctl Stop MARIADB
7. Database root password forgot, change password
Systemctl Stop mariadb; [Close MARIADB Service]
Mysqld_safe--skip-grant-tables & "running MySQL Safe mode in the background"
mysql-uroot [Enter MySQL, no password status]
SELECT * from Mysql.user; [View MySQL user table]
UPDATE Mysql.user Set Password=password (' hxl1234 ') WHERE user= ' root ' [modifies the root user password to hxl123; Password=password (") This format means: Change the password to the value in the password format, so that your root password will not be displayed in clear text, the display is a cryptographic string]
Next turn off Safe mode, kill-9 PID, Ps-aux | grep MySQL Check to see if clean mysql_safe is turned off; MARIADB service is turned on normally, task is completed.

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/8A/ED/wKioL1g_sYCh175yAACmY2IeXmQ497.png "style=" float: none; "title=" 31.png "alt=" Wkiol1g_sych175yaacmy2iexmq497.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/8A/F1/wKiom1g_sYHSY9I_AACgfqIzUVM301.png "style=" float: none; "title=" 32.png "alt=" Wkiom1g_syhsy9i_aacgfqizuvm301.png "/>

650) this.width=650; "src=" Http://s1.51cto.com/wyfs02/M01/8A/ED/wKioL1g_sYOxa717AADSh22VbyY145.png "style=" float: none; "title=" 33.png "alt=" Wkiol1g_syoxa717aadsh22vbyy145.png "/>

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/8A/ED/wKioL1g_sYSzchKfAAAvgCIJt0o587.png "style=" float: none; "title=" 34.png "alt=" Wkiol1g_syszchkfaaavgcijt0o587.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/8A/F1/wKiom1g_sYfCoWF3AADuZLcaeN8698.png "style=" float: none; "title=" 35.png "alt=" Wkiom1g_syfcowf3aaduzlcaen8698.png "/>

"Backup and Recovery Database"
Backup
mysqldump-uroot-phxl1234 HXL >/mnt/hxl.sql [Back up HXL table all information in the database to/mnt/hxl.sql]
mysqldump-uroot-phxl1234--all-databases > Data.sql [back up information for all tables in the database]
mysqldump-uroot-phxl1234--no-data hxl>/mnt/data.sql [Back up all information in the database except the HXL table]
Restore (Import data)
mysql-uroot-phxl1234 HXL </mnt/hxl.sql
Non-interactive operations database (plus-e)
Example: Mysql-uroot-phxl1234-e "SHOW DATABASES"

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/8A/F1/wKiom1g_saeTig5kAAC9Vfcm4zY716.png "style=" float: none; "title=" 36.png "alt=" Wkiom1g_saetig5kaac9vfcm4zy716.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/8A/ED/wKioL1g_safgoZXwAAAzYTuHGpM328.png "style=" float: none; "title=" 37.png "alt=" Wkiol1g_safgozxwaaazytuhgpm328.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/8A/F1/wKiom1g_saiCAXAAAAA5vU53m34402.png "style=" float: none; "title=" 38.png "alt=" Wkiom1g_saicaxaaaaa5vu53m34402.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M01/8A/F1/wKiom1g_sajyYsA8AABJq4vcDiA190.png "style=" float: none; "title=" 39.png "alt=" Wkiom1g_sajyysa8aabjq4vcdia190.png "/>

Then you import the line, and the data that you back up is backed up with SQL statements.
"* * Graphical management database, convenient very"
1. "Pre-requirement"
Download httpd software, enter/var/www/html/; download and install: Tar jxf phpmyadmin-xx.zip package; Download PHP
PHP and MARIADB versions are higher than 5.2 and 5.0, respectively.
2. "Move languages package to/myadmin"
RM-FR phpmyadmin-xx.tar.bz2
MV Phpmyadmin-xx-languages/myadmin
cd/myadmin/
3. "Copy ~inc.php file"
Cp-p config.sample.inc.php config.inc.php
4. "Modify the ~inc.php file"
Vim config.inc.php
: $cfg [' Blowfish_secret ']= ' HXL '; "Add an arbitrary value after the = of 17 rows"

When you have done this, turn on all services. In your browser interface into the 172.25.254.206 (the database exists host IP)/myadmin/, in the interface to select the language, you can enter the system normally.

"DNS Service Record" + "Mariadb,mysql database"