Posts: 8
Joined: Sep 2016
Reputation:
0
I got this on the log
21:53:49 T:13244 ERROR: Unable to open database: MyMusic56 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic55 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic54 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic53 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic52 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic51 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic50 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic49 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic48 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic47 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic46 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic45 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic44 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic43 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic42 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic41 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic40 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic39 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic38 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic37 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic36 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic35 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic34 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic33 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic32 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyMusic56 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to create new database
21:53:49 T:13244 ERROR: Unable to open database: MyVideos99 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos98 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos97 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos96 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos95 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos94 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos93 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos92 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos91 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos90 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos89 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos88 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos87 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos86 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos85 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos84 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos83 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos82 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos81 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos80 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos79 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos78 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos77 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos76 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos75 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
21:53:49 T:13244 ERROR: Unable to open database: MyVideos99 [1130](Host '192.168.1.49' is not allowed to connect to this MySQL server)
I thought the following config would be enough
#bind-address = 127.0.0.1
bind-address = 0.0.0.0.0
What am I missing?
Posts: 218
Joined: Jan 2017
Reputation:
0
Ohhh
Thanks.. I'm new to SQL and I didn't understand that all commands end with a ';'
Perhaps you wan to do this clear in the wiki
-J
Posts: 168
Joined: Mar 2012
Reputation:
1
2017-02-26, 18:28
(This post was last modified: 2017-02-26, 18:54 by Pyromaniac.)
Hey guys, I'm new to mysql, so I have one question regarding mysql and kodi: Is it really necessary to grant all privileges to the kodi-user? Isn't this a bit dangerous if you are hosting some other services like owncloud or similar and don't have a dedicated mysql-server for kodi?
edit:
I did it like that now:
Global privileges only: CREATE, ALTER (so it can create those "MyVideo..." and "MyMusic..." Databases)
Database privileges for "My%": all privileges
At the moment everything seems fine, but can some of the devs tell me if I'm going to have problems, maybe after an kodi-update?