Anonymitaet commented on code in PR #649:
URL: https://github.com/apache/pulsar-site/pull/649#discussion_r1275643877
##########
docs/io-cdc-debezium.md:
##########
@@ -170,6 +170,35 @@ This example shows how to change the data of a MySQL table
using the Pulsar Debe
6. A MySQL client pops out.
+ Change the connection mode to `mysql_native_password`
+ ```
+ mysql> show variables like "caching_sha2_password_auto_generate_rsa_keys";
+ +----------------------------------------------+-------+
+ | Variable_name | Value |
+ +----------------------------------------------+-------+
+ | caching_sha2_password_auto_generate_rsa_keys | ON |
+ +----------------------------------------------+-------+
+
+ # if the value of "caching_sha2_password_auto_generate_rsa_keys" is ON,
ensure the plugin of mysql.user is "mysql_native_password".
Review Comment:
```suggestion
# If the value of "caching_sha2_password_auto_generate_rsa_keys" is ON,
ensure the plugin of mysql.user is "mysql_native_password".
```
##########
docs/io-debezium-source.md:
##########
@@ -220,6 +220,35 @@ This example shows how to change the data of a MySQL table
using the Pulsar Debe
6. A MySQL client pops out.
+ Change the connection mode to `mysql_native_password`
+ ```
+ mysql> show variables like "caching_sha2_password_auto_generate_rsa_keys";
+ +----------------------------------------------+-------+
+ | Variable_name | Value |
+ +----------------------------------------------+-------+
+ | caching_sha2_password_auto_generate_rsa_keys | ON |
+ +----------------------------------------------+-------+
+
+ # if the value of "caching_sha2_password_auto_generate_rsa_keys" is ON,
ensure the plugin of mysql.user is "mysql_native_password".
+ mysql> SELECT Host, User, plugin from mysql.user where user={user};
+ +-----------+------+-----------------------+
+ | Host | User | plugin |
+ +-----------+------+-----------------------+
+ | localhost | root | caching_sha2_password |
+ +-----------+------+-----------------------+
+
+ # if the plugin of mysql.user is is "caching_sha2_password", set it to
"mysql_native_password".
+ alter user '{user}'@'{host}' identified with mysql_native_password by
{password};
+
+ # check the plugin of mysql.user.
Review Comment:
```suggestion
# Check the plugin of mysql.user.
```
##########
docs/io-cdc-debezium.md:
##########
@@ -170,6 +170,35 @@ This example shows how to change the data of a MySQL table
using the Pulsar Debe
6. A MySQL client pops out.
+ Change the connection mode to `mysql_native_password`
+ ```
+ mysql> show variables like "caching_sha2_password_auto_generate_rsa_keys";
+ +----------------------------------------------+-------+
+ | Variable_name | Value |
+ +----------------------------------------------+-------+
+ | caching_sha2_password_auto_generate_rsa_keys | ON |
+ +----------------------------------------------+-------+
+
+ # if the value of "caching_sha2_password_auto_generate_rsa_keys" is ON,
ensure the plugin of mysql.user is "mysql_native_password".
+ mysql> SELECT Host, User, plugin from mysql.user where user={user};
+ +-----------+------+-----------------------+
+ | Host | User | plugin |
+ +-----------+------+-----------------------+
+ | localhost | root | caching_sha2_password |
+ +-----------+------+-----------------------+
+
+ # if the plugin of mysql.user is is "caching_sha2_password", set it to
"mysql_native_password".
+ alter user '{user}'@'{host}' identified with mysql_native_password by
{password};
+
+ # check the plugin of mysql.user.
Review Comment:
```suggestion
# Check the plugin of mysql.user.
```
##########
docs/io-cdc-debezium.md:
##########
@@ -170,6 +170,35 @@ This example shows how to change the data of a MySQL table
using the Pulsar Debe
6. A MySQL client pops out.
+ Change the connection mode to `mysql_native_password`
+ ```
+ mysql> show variables like "caching_sha2_password_auto_generate_rsa_keys";
+ +----------------------------------------------+-------+
+ | Variable_name | Value |
+ +----------------------------------------------+-------+
+ | caching_sha2_password_auto_generate_rsa_keys | ON |
+ +----------------------------------------------+-------+
+
+ # if the value of "caching_sha2_password_auto_generate_rsa_keys" is ON,
ensure the plugin of mysql.user is "mysql_native_password".
+ mysql> SELECT Host, User, plugin from mysql.user where user={user};
+ +-----------+------+-----------------------+
+ | Host | User | plugin |
+ +-----------+------+-----------------------+
+ | localhost | root | caching_sha2_password |
+ +-----------+------+-----------------------+
+
+ # if the plugin of mysql.user is is "caching_sha2_password", set it to
"mysql_native_password".
Review Comment:
```suggestion
# If the plugin of mysql.user is is "caching_sha2_password", set it to
"mysql_native_password".
```
##########
docs/io-cdc-debezium.md:
##########
@@ -170,6 +170,35 @@ This example shows how to change the data of a MySQL table
using the Pulsar Debe
6. A MySQL client pops out.
+ Change the connection mode to `mysql_native_password`
Review Comment:
```suggestion
Change the connection mode to `mysql_native_password`.
```
##########
docs/io-debezium-source.md:
##########
@@ -220,6 +220,35 @@ This example shows how to change the data of a MySQL table
using the Pulsar Debe
6. A MySQL client pops out.
+ Change the connection mode to `mysql_native_password`
+ ```
+ mysql> show variables like "caching_sha2_password_auto_generate_rsa_keys";
+ +----------------------------------------------+-------+
+ | Variable_name | Value |
+ +----------------------------------------------+-------+
+ | caching_sha2_password_auto_generate_rsa_keys | ON |
+ +----------------------------------------------+-------+
+
+ # if the value of "caching_sha2_password_auto_generate_rsa_keys" is ON,
ensure the plugin of mysql.user is "mysql_native_password".
+ mysql> SELECT Host, User, plugin from mysql.user where user={user};
+ +-----------+------+-----------------------+
+ | Host | User | plugin |
+ +-----------+------+-----------------------+
+ | localhost | root | caching_sha2_password |
+ +-----------+------+-----------------------+
+
+ # if the plugin of mysql.user is is "caching_sha2_password", set it to
"mysql_native_password".
Review Comment:
```suggestion
# If the plugin of mysql.user is is "caching_sha2_password", set it to
"mysql_native_password".
```
##########
docs/io-debezium-source.md:
##########
@@ -220,6 +220,35 @@ This example shows how to change the data of a MySQL table
using the Pulsar Debe
6. A MySQL client pops out.
+ Change the connection mode to `mysql_native_password`
Review Comment:
```suggestion
Change the connection mode to `mysql_native_password`.
```
##########
docs/io-debezium-source.md:
##########
@@ -220,6 +220,35 @@ This example shows how to change the data of a MySQL table
using the Pulsar Debe
6. A MySQL client pops out.
+ Change the connection mode to `mysql_native_password`
+ ```
+ mysql> show variables like "caching_sha2_password_auto_generate_rsa_keys";
+ +----------------------------------------------+-------+
+ | Variable_name | Value |
+ +----------------------------------------------+-------+
+ | caching_sha2_password_auto_generate_rsa_keys | ON |
+ +----------------------------------------------+-------+
+
+ # if the value of "caching_sha2_password_auto_generate_rsa_keys" is ON,
ensure the plugin of mysql.user is "mysql_native_password".
Review Comment:
```suggestion
# If the value of "caching_sha2_password_auto_generate_rsa_keys" is ON,
ensure the plugin of mysql.user is "mysql_native_password".
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
