Author Topic: Homeweatherstation - problem with MySQL  (Read 646 times)

0 Members and 1 Guest are viewing this topic.

Offline plex

  • Contributor
  • ***
  • Posts: 102
Homeweatherstation - problem with MySQL
« on: February 16, 2019, 07:21:35 AM »
Oi!

I'm trying out this nice template, however I'm stuck with MySQL database setup.

When I'm trying to create the table and structure, I'm facing this error:

weather34 Error creating database: Access denied for user 'myusername'@'%' to database 'weatherstation'
Fatal error: Uncaught Error: Call to undefined function mysql_query() in /var/www/vejrstationen.dk/public_html/pws/createdb.php:24 Stack trace: #0 {main} thrown in /var/www/vejrstationen.dk/public_html/pws/createdb.php on line 24

My database is not called "weatherstation", but set correctly in the setup -> http://yourdomain/easyweathersetup.php

 [ You are not allowed to view attachments ]

 [ You are not allowed to view attachments ]

 [ You are not allowed to view attachments ]

I've also tried to import the weatherstation.mysql into "phpmyadmin". Tables got created, but I don't see any historical data?

By the way - I'm on a MBP RED.

Thanks

Offline tmiles

  • Member
  • *
  • Posts: 1
    • Golden Valley Weather
Re: Homeweatherstation - problem with MySQL
« Reply #1 on: February 16, 2019, 02:12:44 PM »
I ran into a similar issue and my fix was to change the Database Host name to localhost instead of the server address as you have listed. Hope that gets you going.

Offline plex

  • Contributor
  • ***
  • Posts: 102
Re: Homeweatherstation - problem with MySQL
« Reply #2 on: March 03, 2019, 10:57:25 AM »
I ran into a similar issue and my fix was to change the Database Host name to localhost instead of the server address as you have listed. Hope that gets you going.

Thanks

Suddenly I made it work, doing the import way in phpmyadmin