It is possible to reset the mysql root password as long as you have root access to the OS it’s running on. (Yes, I know this for the obvious reason….) There are a couple of ways to do this; here’s one: https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password <https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password>
-Les > On 20 Aug 2018, at 11:49, Thomas Keffer <tkef...@gmail.com> wrote: > > 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 > <mailto: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 <mailto: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 > <mailto:weewx-user+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/optout > <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 > <mailto:weewx-user+unsubscr...@googlegroups.com>. > For more options, visit https://groups.google.com/d/optout > <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.
