[PR] docs: update the mysql docker example in stream proxy to use mysql_native_password [apisix]

["kayx23 (via GitHub)" <gi...@apache.org>]

kayx23 opened a new pull request, #10439:
URL: https://github.com/apache/apisix/pull/10439

   ### Description
   
   Try with the current command in the doc and use `mysql` client to connect with the MySQL server, you will see an error: `Authentication plugin 'caching_sha2_password' cannot be loaded. The specific module can not be found`.
   
   This is because MySQL 8.0 uses `caching_sha2_password` as the default authentication rather than `mysql_native_password`, which has been the default authentication in earlier versions.
   
   For this example, an easy way to resort back to using `mysql_native_password` with this docker example is to add `mysqld --default-authentication-plugin=mysql_native_password`:
   
   ![image](https://github.com/apache/apisix/assets/39619599/c2075d28-775a-4f7e-89d9-65d6b2a2ad45)
   
   ### Checklist
   
   - [x] I have explained the need for this PR and the problem it solves
   - [x] I have explained the changes or the new features added to this PR
   - [ ] I have added tests corresponding to this change
   - [x] I have updated the documentation to reflect this change
   - [ ] I have verified that this change is backward compatible (If not, please discuss on the [APISIX mailing list](https://github.com/apache/apisix/tree/master#community) first)
   
   <!--
   
   Note
   
   1. Mark the PR as draft until it's ready to be reviewed.
   2. Always add/update tests for any changes unless you have a good reason.
   3. Always update the documentation to reflect the changes made in the PR.
   4. Make a new commit to resolve conversations instead of `push -f`.
   5. To resolve merge conflicts, merge master instead of rebasing.
   6. Use "request review" to notify the reviewer after making changes.
   7. Only a reviewer can mark a conversation as resolved.
   
   -->
   


-- 
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: notifications-unsubscribe@apisix.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [PR] docs: update the mysql docker example in stream proxy to use mysql_native_password [apisix]

["SylviaBABY (via GitHub)" <gi...@apache.org>]

SylviaBABY merged PR #10439:
URL: https://github.com/apache/apisix/pull/10439


-- 
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: notifications-unsubscribe@apisix.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org