mysql8防火墙_MySQL8.0-MySQLEnterpriseFirewall

###################################################

MySQL8.0 Enterprise Firewall

###################################################

----------------------------------

Prepare Database

----------------------------------

C:\Users\IH656>E:\mysql\bin\mysqld

--defaults-file=E:\mysql\init\my.ini --console

2018-04-23T08:06:49.837835Z 0 [System] [MY-010116] [Server]

E:\mysql\bin\mysqld

(mysqld 8.0.11-commercial) starting as process 3224

2018-04-23T08:06:52.458635Z 0 [Warning] [MY-010068] [Server]

CA certificate ca.p

em is self signed.

2018-04-23T08:06:52.708235Z 0 [System] [MY-010931] [Server]

E:\mysql\bin\mysqld:

ready for connections. Version:

'8.0.11-commercial' socket: '' port: 3306 My

SQL Enterprise Server - Commercial.

C:\Users\IH656>mysql -u root -p

Enter password: ************

Welcome to the MySQL monitor. Commands end

with ; or \g.

Your MySQL connection id is 33

Server version: 8.0.11-commercial MySQL Enterprise Server -

Commercial

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All

rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or

its

affiliates. Other names may be trademarks of their

respective

owners.

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

input statement.

mysql>

mysql>

----------------------------------

Installing MySQL Enterprise Firewall

----------------------------------

To install MySQL Enterprise Firewall manually, look in the

share directory of your MySQL installation and choose the script

that is appropriate for your platform. The available scripts differ

in the suffix used to refer to the plugin library file:

win_install_firewall.sql: Choose this script for Windows

systems that use .dll as the file name suffix.

linux_install_firewall.sql: Choose this script for Linux and

similar systems that use .so as the file name suffix.

shell> mysql -u root -p mysql <

linux_install_firewall.sql

Enter password: (enter root password here)

mysql> SHOW GLOBAL VARIABLES LIKE

'mysql_firewall_mode';

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

| Variable_name | Value |

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

| mysql_firewall_mode | ON |

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

For example, to enable the firewall in an option file, use

these lines:

[mysqld]

mysql_firewall_mode=ON

It is also possible to disable or enable the firewall at

runtime:

mysql> SET GLOBAL mysql_firewall_mode = OFF;

mysql> SET GLOBAL mysql_firewall_mode = ON;

mysql>

mysql> use mysql

Database changed

mysql> source E:\mysql\share\win_install_firewall.sql

Database changed

Query OK, 0 rows affected (1.15 sec)

Query OK, 0 rows affected (0.90 sec)

Query OK, 0 rows affected (0.91 sec)

Query OK, 0 rows affected (0.12 sec)

Query OK, 0 rows affected (0.07 sec)

Query OK, 0 rows affected (0.27 sec)

Query OK, 0 rows affected (0.09 sec)