1

### unit2.DNS服务器集群 ###





###实验环境

主DNS server:172.25.254.218(Master)

[root@dns-server ~]# vim /etc/resolv.conf 

  3 nameserver 172.25.254.218


备DNS server:172.25.254.118(Slave)

[root@station ~]# vim /etc/resolv.conf 

  3 nameserver 172.25.254.118


测试客户机器:(218主机询Master,118主机询问Slave,Slave去同步Master)

172.25.254.218

172.25.254.118


注意:主DNS配置请参照《高速缓存DNS》,此处不做描述

主DNS的/var/named/westos.com.zone文件信息为:

  1 $TTL 1D

  2 @       IN SOA  dns.tbr.com. root.tbr.com. (

  3                                          0      ; serial

  4                                         1D      ; refresh

  5                                         1H      ; retry

  6                                         1W      ; expire

  7                                         3H )    ; minimum

  8                 NS      dns.tbr.com.

  9 dns             A       172.25.254.218

 10 www             A       172.25.254.18




###Slave DNS server基础配置

Slave端:

[root@station ~]# yum install bind -y

[root@station ~]# vim /etc/named.conf 

 11         listen-on port 53 { any; };

 17         allow-query    { any; };

 32         dnssec-validation no;


[root@station ~]# vim /etc/named.rfc1912.zones ##仿照19-23行的模板添加下面的内容

 25 zone "westos.com" IN {

 26         type slave;

 27         masters { 172.25.254.218; };

 28         file "slaves/tbr.com.zone";

 29         allow-update { none; };

 30 };


[root@station ~]# cd /var/named/

[root@station named]# ls

data     named.ca     named.localhost  slaves

dynamic  named.empty  named.loopback

[root@station named]# cd slaves/

[root@station slaves]# ls ##该目录下刚开始没有任何文件


[root@station slaves]# firewall-cmd --list-all

public (default, active)

  interfaces: eth0

  sources: 

  services: dhcpv6-client ssh

  ports: 

  masquerade: no

  forward-ports: 

  icmp-blocks: 

  rich rules: 

[root@station slaves]# firewall-cmd --permanent --add-service=dns

success

[root@station slaves]# firewall-cmd --reload 

success

[root@station slaves]# firewall-cmd --list-all

public (default, active)

  interfaces: eth0

  sources: 

  services: dhcpv6-client dns ssh

  ports: 

  masquerade: no

  forward-ports: 

  icmp-blocks: 

  rich rules: 


Master端:

[root@dns-server ~]# vim /etc/named.rfc1912.zones

 25 zone "tbr.com" IN {

 26         type master;

 27         file "westos.com.zone";

 28         allow-update { none; };

 29         allow-transfer { 172.25.254.218; }; ##允许该ip的主机与自己同步



测试:

172.25.254.118主机:

[root@station named]# dig www.westos.com

;; ANSWER SECTION:

www.tbr.com. 86400 IN A 172.25.254.18



##########Slave DNS server自动同步主DNS数据###########

在Master端:

[root@dns-server ~]# vim /etc/named.rfc1912.zones

 25 zone "tbr.com" IN {

 26         type master;

 27         file "westos.com.zone";

 28         allow-update { none; };

 29         allow-transfer { 172.25.254.218; };

 30         also-notify { 172.25.254.218; }; ##总是向该ip的主机通告更新后的dns解析文件

 31 };


[root@dns-server ~]# vim /var/named/westos.com.zone ##需要修改serial值

##当修改serial值之后才会认为文件不同,从而重新更新同步

 3                                 2016112601      ; serial

 10 www             A       172.25.254.18

##修改serial值的同时修改dns解析的内容(之前为www.westos.com——172.25.254.18)


[root@dns-server ~]# systemctl restart named



在Slave端:

保证防火墙允许dns服务或者关闭防火墙


测试:

172.25.254.218主机:

[root@dns-server ~]# dig www.westos.com

;; ANSWER SECTION:

www.westos.com. 86400 IN A 172.25.254.18


172.25.254.118主机:

[root@station named]# dig www.westos.com

;; ANSWER SECTION:

www.westos.com. 86400 IN A 172.25.254.18





#############远程修改DNS配置###############

注意:先将上一个实验中的部分配置删除,否则会影响该实验:

在Master端:

[root@dns-server ~]# vim /etc/named.rfc1912.zones

 25 zone "tbr.com" IN {

 26         type master;

 27         file "tbr.com.zone";

 28         allow-update { none; };

=======删除以下两行内容=======

 29         allow-transfer { 172.25.254.219; };

 30         also-notify { 172.25.254.219; };

===========================

##并将28行改为如下:

 28         allow-update { 172.25.254.119; }; ##允许该ip远程修改DNS配置


[root@station named]# setenforce 0 ##修改selinux模式为警告模式

[root@station named]# getenforce 

Permissive


[root@dns-server ~]# cp -p /var/named/tbr.com.zone /mnt/ ##注意要加-p

##做该实验之前,先将tbr.com.zone文件备份,方便之后还原

[root@dns-server ~]# chmod 770 /var/named/

[root@dns-server ~]# ll -d /var/named/

drwxrwx---. 5 root named 4096 11月 25 23:59 /var/named/



测试:

172.25.254.119主机:

[root@station named]# nsupdate 

> server 172.25.254.219

> update delete www.tbr.com ##删除A记录

> send


172.25.254.219主机:

[root@dns-server named]# dig www.tbr.com

;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 4624

[root@dns-server named]# ls

data      named.empty      slaves        tbr.com.zone.inter

dynamic   named.localhost  tbr.com.ptr   tbr.com.zone.jnl

named.ca  named.loopback   tbr.com.zone

[root@dns-server named]# rm -fr tbr.com.zone.jnl 

[root@dns-server named]# rm -fr tbr.com.zone

[root@dns-server named]# cp -p /mnt/tbr.com.zone . ##将之前备份的文件拷贝回来,注意:要加-p

[root@dns-server named]# ls

data      named.empty      slaves        tbr.com.zone.inter

dynamic   named.localhost  tbr.com.ptr

named.ca  named.loopback   tbr.com.zone

[root@dns-server var]# dig www.tbr.com

;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 60307

##此时并不能查到dns信息,A记录消失


172.25.254.119主机:

[root@station named]# nsupdate

> server 172.25.254.219

> update add www.tbr.com 86400 A 172.25.254.19 ##添加A记录

> send


172.25.254.219主机:

[root@dns-server named]# dig www.tbr.com

;; ANSWER SECTION:

www.tbr.com. 86400 IN A 172.25.254.19

##再次查看,成功恢复




###########远程修改添加密码认证#############

Master端:

[root@dns-server named]# dnssec-keygen --help ##查看dnssec-keygen的帮助

[root@dns-server named]# dnssec-keygen -a HMAC-MD5 -b 128 -n HOST tbr

Ktbr.+157+00014

##此时可能会卡住,因为加密字符不够导致的,可以在该主机上移动鼠标或操作来增加无序加密字符

##-a 加密方式; -b 加密长度; -n 加密类别(HOST|USER)

[root@dns-server named]# ls

data                     named.empty      tbr.com.zone

dynamic                  named.localhost  tbr.com.zone.inter

Ktbr.+157+00014.key      named.loopback   tbr.com.zone.jnl

Ktbr.+157+00014.private  slaves

named.ca                 tbr.com.ptr


##生成了这两个文件:Ktbr.+157+00014.key Ktbr.+157+00014.private

[root@dns-server named]# cat Ktbr.+157+00014.key 

tbr. IN KEY 512 3 157 +dqtFZtEFN+NGp/2rRHJOQ==

[root@dns-server named]# cat Ktbr.+157+00014.private 

Private-key-format: v1.3

Algorithm: 157 (HMAC_MD5)

Key: +dqtFZtEFN+NGp/2rRHJOQ==

Bits: AAA=

Created: 20161126061602

Publish: 20161126061602

Activate: 20161126061602


[root@dns-server named]# cp -p /etc/rndc.key /etc/tbr.key

[root@dns-server named]# vim /etc/tbr.key 

  1 key "tbr" { ##此处将key名称改为自己设置的(eg.tbr)

  2         algorithm hmac-md5;

  3         secret "+dqtFZtEFN+NGp/2rRHJOQ=="; ##此处将加密字符改为上面生成的key字符

  4 };


##将加密字符文件与DNS相关联:(如下)

[root@dns-server named]# vim /etc/named.conf 

 44 include "/etc/tbr.key";

[root@dns-server named]# vim /etc/named.rfc1912.zones

 28         allow-update { key tbr; };


##最后将key文件发送给远程修改的客户机

[root@dns-server named]# scp Ktbr.+157+00014.* root@172.25.254.119:/mnt/


测试:

172.25.254.119主机:

[root@station named]# cd /mnt ##需要进入到有key文件的目录下操作

[root@station mnt]# ls

Ktbr.+157+00014.key     Ktbr.+157+00014.private 

[root@station mnt]# nsupdate -k Ktbr.+157+00014.private ##-k表示用密码认证

> server 172.25.254.219

> update delete www.tbr.com

> send




#############Dynamic DNS 动态DNS###############

注意:

做该实验之前,先将上一个实验的部分配置还原:

Master端:

[root@dns-server named]# rm -fr tbr.com.zone.jnl 

[root@dns-server named]# rm -fr tbr.com.zone

[root@dns-server named]# cp -p /mnt/tbr.com.zone . ##将之前备份的文件拷贝回来,注意:要加-p

[root@dns-server named]# systemctl restart named ##重启服务后生效


Master端:

[root@dns-server ~]# yum install dhcpd -y

[root@dns-server named]# cp /usr/share/doc/dhcp-4.2.5/dhcpd.conf.example /etc/dhcp/dhcpd.conf 

cp: overwrite ‘/etc/dhcp/dhcpd.conf’? y

[root@dns-server named]# vim /etc/dhcp/dhcpd.conf

  7 option domain-name "tbr.com";

  8 option domain-name-servers 172.25.254.219;


 14 ddns-update-style none; ##将该条配置启用

||

 14 ddns-update-style interim; ##并将参数修改为interim


=============删除以下两行===============

 27 subnet 10.152.187.0 netmask 255.255.255.0 {

 28 }

======================================


 30 subnet 172.25.254.0 netmask 255.255.255.0 {

 31   range 172.25.254.240 172.25.254.244;

 32   option routers 172.25.254.219;

 33 }

 34

 35 key tbr { ##修改key名称为tbr

 36          algorithm hmac-md5; ##默认使用hmac-md5加密

 37          secret +dqtFZtEFN+NGp/2rRHJOQ==; ##将密码修改为之前的key值

 38        };

 39 

 40 zone tbr.com. { ##修改zone的名称为tbr.com.

 41          primary 127.0.0.1; ##默认使用环回口进行通信

 42          key tbr; ##使用的key为tbr

 43        }

========================================

##上述补充的内容可以通过下面的方式查询:

[root@dns-server ~]# man 5 dhcpd.conf

/dns ##搜索关键字dns

========================================



[root@dns-server named]# systemctl start dhcpd ##启动服务



测试:

172.25.254.119主机:

修改为DHCP获取地址:(不做详细描述)

[root@station Desktop]# hostname

station.domain19.example.com

[root@station Desktop]# 

hostnamectl set-hostname music.tbr.com

[root@station Desktop]#reoot


[root@music ~]# systemctl restart network

[root@music ~]# ifconfig

inet 172.25.254.241  netmask 255.255.255.0  broadcast 172.25.254.255

[root@music ~]# dig music.tbr.com

;; ANSWER SECTION:

music.tbr.com. 300 IN A 172.25.254.241


去修改Master端的/etc/dhcp/dhcpd.conf中的ip范围为172.25.254.242 172.25.254.244,再

[root@music ~]# systemctl restart network

[root@music ~]# ifconfig

inet 172.25.254.241  netmask 255.255.255.0  broadcast 172.25.254.255

[root@music ~]# dig music.tbr.com

;; ANSWER SECTION:

music.tbr.com. 300 IN A 172.25.254.242





### unit3.MYSQL ###


###创建|删除用户

1.创建本地用户



2.创建非本地用户(可通过数据库的网络接口登陆,但该接口必须开启才可以生效)

MariaDB [(none)]> CREATE USER redhat@'%' identified by 'redhat';

Query OK, 0 rows affected (0.00 sec)


MariaDB [(none)]> SELECT Host,User,Password FROM mysql.user;

+-----------+--------+-------------------------------------------+

| Host      | User   | Password                                  |

+-----------+--------+-------------------------------------------+

| localhost | root   | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| 127.0.0.1 | root   | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| ::1       | root   | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| %         | redhat | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| localhost | westos | *28C1E2BE21B45562A34B6CC34A19CFAFC2F88F96 |

+-----------+--------+-------------------------------------------+

5 rows in set (0.00 sec)


3.删除用户

MariaDB [(none)]> DROP USER redhat@'%';

Query OK, 0 rows affected (0.00 sec)


MariaDB [(none)]> SELECT Host,User,Password FROM mysql.user;

+-----------+--------+-------------------------------------------+

| Host      | User   | Password                                  |

+-----------+--------+-------------------------------------------+

| localhost | root   | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| 127.0.0.1 | root   | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| ::1       | root   | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| localhost | westos | *28C1E2BE21B45562A34B6CC34A19CFAFC2F88F96 |

+-----------+--------+-------------------------------------------+

4 rows in set (0.01 sec)



###用户授权

注意:用户授权只能在root上做

MariaDB [(none)]> SELECT HOST,USER.PASSWD FROM mysql.user

    -> ;

ERROR 1054 (42S22): Unknown column 'USER.PASSWD' in 'field list'

MariaDB [(none)]> SELECT Host,User,Password FROM mysql.user

    -> ;

+-----------+------+-------------------------------------------+

| Host      | User | Password                                  |

+-----------+------+-------------------------------------------+

| localhost | root | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| 127.0.0.1 | root | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| ::1       | root | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

+-----------+------+-------------------------------------------+

3 rows in set (0.00 sec)


MariaDB [(none)]> CREATE USER westos@localhost identified by 'westos';

Query OK, 0 rows affected (0.00 sec)


MariaDB [(none)]> SELECT Host,User,Password FROM mysql.user;

+-----------+--------+-------------------------------------------+

| Host      | User   | Password                                  |

+-----------+--------+-------------------------------------------+

| localhost | root   | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| 127.0.0.1 | root   | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| ::1       | root   | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| localhost | westos | *28C1E2BE21B45562A34B6CC34A19CFAFC2F88F96 |

+-----------+--------+-------------------------------------------+

4 rows in set (0.00 sec)





###先查看各个用户的部分权限列表

MariaDB [(none)]> SELECT User,Select_priv,Insert_priv,Create_priv FROM mysql.user;

+--------+-------------+-------------+-------------+

| User   | Select_priv | Insert_priv | Create_priv |

+--------+-------------+-------------+-------------+

| root   | Y           | Y           | Y           |

| root   | Y           | Y           | Y           |

| root   | Y           | Y           | Y           |

| westos | N           | N           | N           |

+--------+-------------+-------------+-------------+

4 rows in set (0.00 sec)


###添加权限

MariaDB [(none)]> GRANT SELECT,INSERT,CREATE on  *.* to westos@localhost;

Query OK, 0 rows affected (0.00 sec)


MariaDB [(none)]> SELECT User,Select_priv,Insert_priv,Create_priv FROM mysql.user;

+--------+-------------+-------------+-------------+

| User   | Select_priv | Insert_priv | Create_priv |

+--------+-------------+-------------+-------------+

| root   | Y           | Y           | Y           |

| root   | Y           | Y           | Y           |

| root   | Y           | Y           | Y           |

| westos | Y           | Y           | Y           |

+--------+-------------+-------------+-------------+

4 rows in set (0.00 sec)


补充:如果权限没有生效,可以通过以下方法:

MariaDB [(none)]> FLUSH PRIVILEGES; ##重载授权表

Query OK, 0 rows affected (0.00 sec)



##撤销权限

MariaDB [(none)]> REVOKE SELECT,INSERT,CREATE on  *.* from westos@localhost;

Query OK, 0 rows affected (0.00 sec)


MariaDB [(none)]> SELECT User,Select_priv,Insert_priv,Create_priv FROM mysql.user;

+--------+-------------+-------------+-------------+

| User   | Select_priv | Insert_priv | Create_priv |

+--------+-------------+-------------+-------------+

| root   | Y           | Y           | Y           |

| root   | Y           | Y           | Y           |

| root   | Y           | Y           | Y           |

| westos | N           | N           | N           |

+--------+-------------+-------------+-------------+

4 rows in set (0.00 sec)



#############忘记root密码|修改密码#############

1.忘记root密码

[root@dns-server ~]# systemctl stop mariadb ##关闭mariadb

[root@dns-server ~]# mysqld_safe --skip-grant-tables & ##开启mysql的单用户模式

[1] 2469 

161126 20:52:29 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'.

161126 20:52:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql


[root@dns-server ~]# mysql -u root

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 1

Server version: 5.5.35-MariaDB MariaDB Server


Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [(none)]> SELECT User,Password FROM mysql.user;

+--------+-------------------------------------------+

| User   | Password                                  |

+--------+-------------------------------------------+

| root   | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| root   | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| root   | *84BB5DF4823DA319BBF86C99624479A198E6EEE9 |

| westos | *28C1E2BE21B45562A34B6CC34A19CFAFC2F88F96 |

+--------+-------------------------------------------+

4 rows in set (0.00 sec)


MariaDB [(none)]> UPDATE mysql.user set Password='westos' WHERE User='root';

Query OK, 3 rows affected (0.00 sec)

Rows matched: 3  Changed: 3  Warnings: 0


MariaDB [(none)]> SELECT User,Password FROM mysql.user;

+--------+-------------------------------------------+

| User   | Password                                  |

+--------+-------------------------------------------+

| root   | westos                                    |

| root   | westos                                    |

| root   | westos                                    |

| westos | *28C1E2BE21B45562A34B6CC34A19CFAFC2F88F96 |

+--------+-------------------------------------------+

4 rows in set (0.00 sec)


MariaDB [(none)]> UPDATE mysql.user set Password=password('westos') WHERE User='root';

Query OK, 3 rows affected (0.00 sec)

Rows matched: 3  Changed: 3  Warnings: 0


MariaDB [(none)]> SELECT User,Password FROM mysql.user;

+--------+-------------------------------------------+

| User   | Password                                  |

+--------+-------------------------------------------+

| root   | *28C1E2BE21B45562A34B6CC34A19CFAFC2F88F96 |

| root   | *28C1E2BE21B45562A34B6CC34A19CFAFC2F88F96 |

| root   | *28C1E2BE21B45562A34B6CC34A19CFAFC2F88F96 |

| westos | *28C1E2BE21B45562A34B6CC34A19CFAFC2F88F96 |

+--------+-------------------------------------------+

4 rows in set (0.00 sec)


MariaDB [(none)]> Ctrl-C -- exit!

Aborted

[root@dns-server ~]# fg

mysqld_safe --skip-grant-tables


^Z ##ctrl+z

[1]+  Stopped                 mysqld_safe --skip-grant-tables

[root@dns-server ~]# killall -9 mysqld_safe ##关闭单用户模式

[1]+  Killed                  mysqld_safe --skip-grant-tables

[root@dns-server ~]# ps aux | grep mysql

mysql     2624  0.0  5.2 859052 98764 pts/0    Sl   20:52   0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysq --skip-grant-tables --log-error=/var/log/mariadb/mariadb.log --pid-file=/var/run/mariadb/mariadb.pid --socket=/var/lib/mysql/mysql.sock

root      2709  0.0  0.0 112640   980 pts/0    R+   20:59   0:00 grep --color=auto mysql


[root@dns-server ~]# kill -9 2624 ##关闭mysql相关进程

[root@dns-server ~]# systemctl start mariadb ##开启mariadb

[root@dns-server ~]# mysql -uroot -pwestos

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 3

Server version: 5.5.35-MariaDB MariaDB Server


Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [(none)]> quit

Bye



2.修改密码(知道密码)

[root@dns-server ~]# mysqladmin -uroot -pwestos password redhat

[root@dns-server ~]# mysql -uroot -pwestos

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

[root@dns-server ~]# mysql -uroot -predhat

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 8

Server version: 5.5.35-MariaDB MariaDB Server


Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [(none)]> quit

Bye




###web方式管理MYSQL

1.安装lftp

[root@dns-server ~]# yum install lftp -y


2.去ftp服务器上下载phpMyAdmin

[root@dns-server ~]# lftp 172.25.254.250

lftp 172.25.254.250:~> cd /pub/docs/software/

lftp 172.25.254.250:/pub/docs/software> get phpMyAdmin-3.4.0-all-languages.tar.bz2 

4548030 bytes transferred                                                 

lftp 172.25.254.250:/pub/docs/software> exit

[root@dns-server ~]# ls

anaconda-ks.cfg  Downloads                               Pictures   Videos

Desktop          Music                                   Public

Documents        phpMyAdmin-3.4.0-all-languages.tar.bz2  Templates


3.安装httpd

[root@dns-server ~]# yum install httpd -y

[root@dns-server ~]# mv phpMyAdmin-3.4.0-all-languages.tar.bz2 /var/www/html/

[root@dns-server ~]# cd /var/www/html/

[root@dns-server html]# ls

phpMyAdmin-3.4.0-all-languages.tar.bz2

[root@dns-server html]# tar -jxf phpMyAdmin-3.4.0-all-languages.tar.bz2 

[root@dns-server html]# ls

phpMyAdmin-3.4.0-all-languages  phpMyAdmin-3.4.0-all-languages.tar.bz2

[root@dns-server html]# rm -fr phpMyAdmin-3.4.0-all-languages.tar.bz2 

[root@dns-server html]# ls

phpMyAdmin-3.4.0-all-languages

[root@dns-server html]# firewall-cmd --permanent --add-service=http

success

[root@dns-server html]# firewall-cmd --reload 

success

[root@dns-server html]# mv phpMyAdmin-3.4.0-all-languages phpadmin

[root@dns-server html]# ls

phpadmin


4.安装php相关软件

[root@dns-server html]# yum search php

Loaded plugins: langpacks

================================== N/S matched: php ===================================

php.x86_64 : PHP scripting language for creating dynamic web sites

php-cli.x86_64 : Command-line interface for PHP

php-common.x86_64 : Common files for PHP

php-gd.x86_64 : A module for PHP applications for using the gd graphics library

php-ldap.x86_64 : A module for PHP applications that use LDAP

php-mysql.x86_64 : A module for PHP applications that use MySQL databases

php-odbc.x86_64 : A module for PHP applications that use ODBC databases

php-pdo.x86_64 : A database access abstraction module for PHP applications

php-pear.noarch : PHP Extension and Application Repository framework

php-pgsql.x86_64 : A PostgreSQL database module for PHP

php-process.x86_64 : Modules for PHP script using system process interfaces

php-recode.x86_64 : A module for PHP applications for using the recode library

php-soap.x86_64 : A module for PHP applications that use the SOAP protocol

php-xml.x86_64 : A module for PHP applications which use XML

php-xmlrpc.x86_64 : A module for PHP applications which use the XML-RPC protocol

php-pecl-memcache.x86_64 : Extension to work with the Memcached caching daemon


  Name and summary matches only, use "search all" for everything.

=========注意:以下两个都要安装==========

[root@dns-server html]# yum install php -y

[root@dns-server html]# yum install php-mysql.x86_64 -y


5.修改php相关配置

[root@dns-server html]# cd phpadmin/

[root@dns-server phpadmin]# ls

browse_foreigners.php     main.php                server_status.php

bs_disp_as_mime_type.php  navigation.php          server_synchronize.php

bs_play_media.php         phpdoctor.ini           server_variables.php

ChangeLog                 phpinfo.php             setup

changelog.php             phpmyadmin.css.php      show_config_errors.php

chk_rel.php               pmd                     sql.php

config.sample.inc.php     pmd_common.php          tbl_addfield.php

contrib                   pmd_display_field.php   tbl_alter.php

CREDITS                   pmd_general.php         tbl_change.php

db_create.php             pmd_help.php            tbl_chart.php

db_datadict.php           pmd_pdf.php             tbl_create.php

db_export.php             pmd_relation_new.php    tbl_export.php

db_import.php             pmd_relation_upd.php    tbl_get_field.php

db_operations.php         pmd_save_pos.php        tbl_import.php

db_printview.php          prefs_forms.php         tbl_indexes.php

db_qbe.php                prefs_manage.php        tbl_move_copy.php

db_search.php             print.css               tbl_operations.php

db_sql.php                querywindow.php         tbl_printview.php

db_structure.php          README                  tbl_relation.php

db_tracking.php           README.VENDOR           tbl_replace.php

docs.css                  RELEASE-DATE-3.4.0      tbl_row_action.php

Documentation.html        robots.txt              tbl_select.php

Documentation.txt         schema_edit.php         tbl_sql.php

enum_editor.php           schema_export.php       tbl_structure.php

export.php                scripts                 tbl_tracking.php

favicon.ico               server_binlog.php       themes

import.php                server_collations.php   themes.php

import_status.php         server_databases.php    TODO

index.php                 server_engines.php      transformation_overview.php

INSTALL                   server_export.php       transformation_wrapper.php

js                        server_import.php       url.php

libraries                 server_privileges.php   user_password.php

LICENSE                   server_processlist.php  view_create.php

license.php               server_replication.php  view_operations.php

locale                    server_sql.php          webapp.php

[root@dns-server phpadmin]# less README  ##可以查看该文件

[root@dns-server phpadmin]# less Documentation.txt ##去查看该文件,会指导需要修改的文件


[root@dns-server phpadmin]# cp -p config.sample.inc.php config.inc.php ##注意:要加-p

[root@dns-server phpadmin]# vim config.inc.php 

 17 $cfg['blowfish_secret'] = 'linux'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH!  ##必须加一个cookie值,内容不限

[root@dns-server phpadmin]# systemctl restart httpd.service  ##重启后生效




测试:

真机172.25.254.18:

打开firefox

http://172.25.254.218/phpadmin

就可以登陆了

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值