If you do not know how to administer a MySQL database, I would strongly suggest sticking with sqlite. It's much simpler.
-tk On Wed, Nov 1, 2017 at 3:21 AM, 'Holm Dittrich' via weewx-user < [email protected]> wrote: > Hello, > I need your help again. > I would like change the database from sqlite to mysql. > > My result should be to have the weather data`s into my database from my > website > > The changes into .conf is no problem. Change and save. > > [[wx_binding]] > # The database should match one > of the sections in [Databases] > database = *archive_mysql* > > My problems starts with the creation of the weewx mysql database. > > Where and how can i write following - into the console?: > mysql> CREATE USER 'weewx'@'localhost' > IDENTIFIED BY 'weewx'; > mysql> GRANT select, update, create, > delete, insert, drop ON weewx.* TO weewx@localhost; > > I know it is easy for you but I don`t know how go one next step..... > > Thanks for your support. > > Holm > > -- > 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 [email protected]. > 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
