John, Please don't summarize what you're finding. Cut-and-paste explicitly into the email. For example, when you say '**I get access denied**' when trying to use mysql, did it prompt for a password first (it should have)? You should have given it the MySQL root password you used when setting up MySQL. If you don't remember it, then you're stuck. Reinstall, and this time remember it. Incidentally, this is a good example of how MySQL is more difficult to manage.
I don't know what you mean by anything in the "grins and giggles" paragraph. What "not found" error? And, again, don't summarize what you think you're seeing in syslog --- post it. Don't take these setbacks personally. The RPi is not out to get you. Give it the right commands and it will do the right thing. -tk On Mon, Aug 20, 2018 at 11:32 AM John Clark <w0av...@gmail.com> wrote: > > > On 8/20/2018 12:24 PM, Thomas Keffer wrote: > > Nothing wrong with the Rapsberry Pi as a platform: thousands of WeeWX > users are using it successfully. However, you should reconsider your > decision to use MySQL if you are not familiar with it. It is much more > complex to administer then the default sqlite database. > > In any case, check the access permissions for user weewx. To do this, run > 'mysql' either as user weewx or user root. Then use the SHOW GRANTS command: > > $ > *mysql -u root -p * > mysql> > *SHOW GRANTS FOR 'weewx'@'localhost'; * > > > $ mysql -u root -p **I get access denied** > mysql> SHOW GRANTS FOR 'weewx'@'localhost'; **I get no results** > > Just for grins and giggles I set it to use sqlite and it did "run" but > there was nothing displayed with "localhost/weewx" just the "not > found"error and according to the syslog it wasn't uploading to my website > > *. *So, I am gonna give it a break before I use a hammer on it. THEN, I'm > not sure WHAT I'll do. > -- > *John Clark <w0av...@gmail.com>* > > -- > You received this message because you are subscribed to the Google Groups > "weewx-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to weewx-user+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
