Re: [weewx-development] MySQL 8.1 starts giving a deprecation warning for mysql_native_password authentication mechanism

[Joel Bion]

Sure! This is what worked for me. It may or may not work for you! BACK UP YOUR DATA and know how to restore it before you begin! 1) do a “pip3 list” to see if you have pycparser, cffi, cryptography. If you are missing any in this list, “pip3 install <pkgname>” for each <pkgname> you don’t have. 2) stop your weewx service. 3) back up your MySQL data - all of it - before continuing. This guide won’t describe how to do that. 4) run the MySQL program as the root user on the mysql database. 5) look at how your users are set up with “select user,host,plugin from user;” 6) if your weewx username is using a plug-in other than mysql_native_password, you’re probably fine and can stop here. 7) if your plug-in is “mysql_native_password” change it with “alter user ‘weewxuser’@‘localhost’ identified with caching_sha2_password by ‘your password’;” (Don’t use the double-quotes) 8) force changes to take place with “flush privileges;” 9) quit and re-enter mysql program. Issue command on step 5 again to verify changes ‘took.’ 10) if they took, then make sure weewx is configured with the correct password for the Weewx user. 11) restart weewx. Look at log files repeatedly to verify writes to your database are happening. -joel Sent from my iPhone On Jul 22, 2023, at 2:30 PM, Vince Skahan <vinceska...@gmail.com> wrote: It would be nice if you'd post a followup here so the next person knows your solutions.... On Saturday, July 22, 2023 at 7:07:18 AM UTC-7 Joel Bion wrote: Well, after all that it took 5 minutes to add the correct Python modules, 5 minutes to learn the right SQL commands to change the password authentication mechanism and about 15 minutes to reboot and test. Easier than I thought! -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-development+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/48a259ce-1f8e-4009-925b-7950ff882b17n%40googlegroups.com. -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-development+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/A98F5F2C-244E-4345-A4F1-5BCC79B509D8%40gmail.com.