Error 1049: Unknown database 'GroveWeatherPi' MySQL-MariaDB

OmniKnight
Guest

Error 1049: Unknown database 'GroveWeatherPi' MySQL-MariaDB Nov 23, 2017 12:35:45 GMT -8

Quote

Post by OmniKnight on Nov 23, 2017 12:35:45 GMT -8

pi@raspberrypizerow:~/Desktop/New_SDL/SDL_Pi_GroveWeatherPi $ sudo python GroveWeatherPi.py

GroveWeatherPi Solar Powered Weather Station Version 2.99 - SwitchDoc Labs

Program Started at:2017-11-23 20:16:54

----------------------
I2C Mux - TCA9545: Present
BMP280: Present
DS3231: Present
HDC1080: Not Present
HTU21DF: Not Present
AM2315: Present
ADS1015: Not Present
ADS1115: Present
AS3935: Not Present
OLED: Present
SunAirPlus: Present
Sunlight Sensor: Not Present
WXLink: Not Present

UseMySQL: Present
Check WLAN: Present
WeatherUnderground: Not Present
----------------------
Error 1049: Unknown database 'GroveWeatherPi'
Traceback (most recent call last):
File "GroveWeatherPi.py", line 1750, in <module>
pclogging.log(pclogging.INFO, __name__, "GroveWeatherPi Startup Version 2.99")
File "/home/pi/Desktop/New_SDL/SDL_Pi_GroveWeatherPi/pclogging.py", line 70, in log
cur.close()
UnboundLocalError: local variable 'cur' referenced before assignment
pi@raspberrypizerow:~/Desktop/New_SDL/SDL_Pi_GroveWeatherPi $

I know this is an issue with MySQL, this is the first time I ever used MySql and when I followed the tutorial to download that on my Pi zero w I got some thing called MariaDb ?! Is that the same as Sql

Also I can't start a server unless I added 'sudo' and it asks me for a password but none of the passwords that I remember works!?

I also cant list all the databases that has been created ?!!

here is an insight:

pi@raspberrypizerow:~/Desktop/New_SDL/SDL_Pi_GroveWeatherPi $ sudo mysql -u root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 10.1.23-MariaDB-9+deb9u1 Raspbian 9.0

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
MariaDB [(none)]> SHOW DATABASES
->

MariaDB [(none)]> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [mysql]> use GroveWeatherPi
ERROR 1049 (42000): Unknown database 'GroveWeatherPi'
MariaDB [mysql]>

pi@raspberrypizerow:~/Desktop/New_SDL/SDL_Pi_GroveWeatherPi $ mysql -u root -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

Please help! this is urgent

Thanks

SDL
Global Moderator

Posts: 5,655
Raspberry Pi: Yes
Other Device: PC, arduino, beagleBone

Error 1049: Unknown database 'GroveWeatherPi' MySQL-MariaDB Nov 24, 2017 9:04:43 GMT -8

Quote

Post by SDL on Nov 24, 2017 9:04:43 GMT -8

Mr. OmniKnight,

Great name by the way.

Go back to the MariaDB tutorials. It is clear that you haven't added the database. The SQL to do that is in the GroveWeatherPi directory and look in the install for the mySQL commands to add it. You have to figure out how to do it with the mariaDB commands.

BP

OmniKnight
Guest

Error 1049: Unknown database 'GroveWeatherPi' MySQL-MariaDB Nov 24, 2017 16:23:55 GMT -8 scott likes this

Quote

Post by OmniKnight on Nov 24, 2017 16:23:55 GMT -8

I finally got it to work but it would be nice to have your conformation
I guess the SDL_Pi_GroveWeatherPi has two .sql files:

1. is in MySqlFiles called GroveWeatherPi.sql
2. is in the WeatherPiSQL called WeatherPiStructure.sql

Unfortunately I thought number one was the designated file for the database but after multiple hours I noticed that the differences between the two files is not only the Sunlight sensor that been added in the last commit but rather it seems that someone forgot to Create the database!

CREATE DATABASE IF NOT EXISTS GroveWeatherPi;
USE GroveWeatherPi;

the upper two lines can be found in the second .sql file but not in the first one!
that was the reason why the database could not be found.
I was able to figure this out after hours of debugging, uninstalling Sql and reinstalling it multiple times.

In short the solution is to target the second SQL file when you try to USE the GroveWeatherPi Database

Thanks,
OmniKnight

weatherpi
New Member

Posts: 15

Raspberry Pi: Yes

Error 1049: Unknown database 'GroveWeatherPi' MySQL-MariaDB Nov 27, 2017 10:56:45 GMT -8

Quote

Post by weatherpi on Nov 27, 2017 10:56:45 GMT -8

Nov 24, 2017 9:04:43 GMT -8 SDL said:

Mr. OmniKnight,

Great name by the way.

Go back to the MariaDB tutorials. It is clear that you haven't added the database. The SQL to do that is in the GroveWeatherPi directory and look in the install for the mySQL commands to add it. You have to figure out how to do it with the mariaDB commands.

BP

Is there a MariaDB tutorial now? I noticed this weekend when I had to rebuild my old WeatherPi that Raspbian Stretch now downloads and installs mariadb instead of mysql when you do the step: sudo apt-get install mysql-server python-mysqldb

It also fails to ask you for a default password during the mariadb installation. I did some MariaDB googling and saw mention that it's blank but that doesn't work either. I could get into it using sudo mysql and issued a statement to change the password but that didn't let me login either with mysql -uroot -p and entering my just changed password.

Did I miss some updated tutorial(s) somewhere?

OmniKnight
Guest

Error 1049: Unknown database 'GroveWeatherPi' MySQL-MariaDB Nov 28, 2017 19:50:18 GMT -8

Quote

Post by OmniKnight on Nov 28, 2017 19:50:18 GMT -8

He there

I felt into the same thing and spend 8+ hours trying to actually login but with no use
None of the tutorials made any sense
they all require password and login and you quickly realize that you NEVER setup a default password
It just seemed to me that everything is whether wrong or out of date
However, just skip this part and try to "point to an already existed data base" and point to the file WeatherPiSQLStructire.sql file

that's essentially what solved my problem

doxidad
Senior Member

Posts: 272
Raspberry Pi: Yes

Error 1049: Unknown database 'GroveWeatherPi' MySQL-MariaDB Nov 29, 2017 9:21:27 GMT -8

Quote

Post by doxidad on Nov 29, 2017 9:21:27 GMT -8

Try running this script. If I remember correctly, this is how I set up the root password.

sudo mysql_secure_installation

I'm not sure where it is located right now but if it is in your path it should be found. If not use find and search for it.

It will prompt you to enter your root password. If I remember correctly there isn't on set. It will then prompt you for a new password.

See mariadb.com/kb/en/library/mysql_secure_installation/ for more info.

Hope this will helps you out.
TR

weatherpi
New Member

Posts: 15

Raspberry Pi: Yes

Error 1049: Unknown database 'GroveWeatherPi' MySQL-MariaDB Nov 29, 2017 11:47:40 GMT -8 SDL likes this

Quote

Post by weatherpi on Nov 29, 2017 11:47:40 GMT -8

I came across that script too but it didn't seem to work either. What I did was load up a jessie image and run with that release. It installs mysql and prompts for a password that actually works when you try and login.

But honestly at that point I was pretty much done with MariaDB so I will play with stretch some more this week and see if I can get MariaDB running correctly now that OG WeatherPi #1 is back up and running again.

thanks much for the replies.

SwitchDoc Labs Product Support

Error 1049: Unknown database 'GroveWeatherPi' MySQL-MariaDB

Post by OmniKnight on Nov 23, 2017 12:35:45 GMT -8

Post by SDL on Nov 24, 2017 9:04:43 GMT -8

Post by OmniKnight on Nov 24, 2017 16:23:55 GMT -8

Post by weatherpi on Nov 27, 2017 10:56:45 GMT -8

Post by OmniKnight on Nov 28, 2017 19:50:18 GMT -8

Post by doxidad on Nov 29, 2017 9:21:27 GMT -8

Post by weatherpi on Nov 29, 2017 11:47:40 GMT -8

Quick Reply