2015-06-27, 03:10
hi guys/girls, i have been a user of xbmc for quite some time, we have 2 atv 2's using the mysql db sharing purely just for the watched status, yesterday i build a new windows 8 pc and installed 14.2 (same build as atv's) and put in my advanced settings file the atvs work fine still but i cannot get the windows build to conenct to the database, just get the following line in the kodi log file.
10:53:51 T:3136 ERROR: Unable to open database: MyVideos90 [1045](Access denied for user 'kodi'@'Alien-Kodi' (using password: YES))
the database already exists and i have dropped it and tried to let the windows machine recreate it but it will not create it, i then allowed the atv to recreate the db and tried to connect again but i get the same issue. the username to me looks strange as it is putting in the local computer name, i have also added that full username on the mysql db and granted full premissions to it but still no joy.
i can confirm i have access to the my sql server from the windows computer via cmd/telnet.
i am not sure exactly where else to go any ideas help would be appreciated.
kev
10:53:51 T:3136 ERROR: Unable to open database: MyVideos90 [1045](Access denied for user 'kodi'@'Alien-Kodi' (using password: YES))
the database already exists and i have dropped it and tried to let the windows machine recreate it but it will not create it, i then allowed the atv to recreate the db and tried to connect again but i get the same issue. the username to me looks strange as it is putting in the local computer name, i have also added that full username on the mysql db and granted full premissions to it but still no joy.
i can confirm i have access to the my sql server from the windows computer via cmd/telnet.
i am not sure exactly where else to go any ideas help would be appreciated.
kev