poorbarcode commented on code in PR #649:
URL: https://github.com/apache/pulsar-site/pull/649#discussion_r1275674311
##########
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:
Done
##########
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:
Done
##########
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:
Done
##########
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:
Done
##########
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:
Done
--
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]
