myql如何配置访问IP黑名单_myql访问IP黑名单方法

-- 查看是否存在来自该 IP 的用户

SELECT User, Host FROM mysql.user WHERE Host = 192.168.1.100;

<p>-- 如果存在，删除该用户

DROP USER username@192.168.1.100;</p>

# 禁止来自 192.168.1.100 的访问

iptables -A INPUT -s 192.168.1.100 -p tcp --dport 3306 -j DROP

<h1>永久保存规则（CentOS/RHEL）</h1><p>service iptables save</p><div class="aritcle_card flexRow">

                                                        <div class="artcardd flexRow">

                                                                <a class="aritcle_card_img" href="/xiazai/skill2334" title="MySQL"><img

                                                                                src="https://img.php.cn/upload/skill/000/000/081/178900927846657.jpg" alt="MySQL"  onerror="this.onerror=;this.src=/static/lhimages/moren/morentu.png" ></a>

                                                                <div class="aritcle_card_info flexColumn">

                                                                        <a href="/xiazai/skill2334" title="MySQL">MySQL</a>

                                                                        <p>编写正确的MySQL查询，避免字符集、索引和锁方面的常见陷阱。</p>

                                                                </div>

                                                                <a href="/xiazai/skill2334" title="MySQL" class="aritcle_card_btn flexRow flexcenter"><b></b><span>下载</span> </a>

                                                        </div>

                                                </div>

# 封禁 IP

firewall-cmd --permanent --add-rich-rule=rule family="ipv4" source address="192.168.1.100" port protocol="tcp" port="3306" reject

<h1>重新加载配置</h1><p>firewall-cmd --reload</p>

mysqld: 192.168.1.100