Centos7 搭建 Powerdns +PowerAdmin + Mysql
介绍
Mysql 配置安装
- 下载并安装mysql
# wget https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm
# yum install -y mysql80-community-release-el7-2.noarch.rpm
# yum install -y mysql-community-server
备注:官网YUM的rpm的安装包链接
- 启动mysql
# systemctl enable mysqld
# systemctl start mysqld
- 配置mysql 和表结构
创建 powerdns 用户并授权本地登录,密码为helloworld
# grep 'temporary password' /var/log/mysqld.log (查看mysql root 初始密码)
2019-04-12T09:33:42.903384Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: TJuJ+ok<w3Mr
# mysql -u root -p (登录)
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Mysql@elmeast2019'; (修改数据库密码,要求:大小写字母+数字+特殊符号,可通过‘set global validate_password.policy=0;’ 和 ‘set global validate_length.policy=1;’ 减小密码复杂度,注意安全问题)
mysql> CREATE DATABASE powerdns;
mysql> CREATE USER 'powerdns'@'localhost' IDENTIFIED BY 'helloworld';
mysql> GRANT ALL ON powerdns.* TO 'powerdns'@'localhost';
mysql> FLUSH PRIVILEGE