myphpadmin setting up permissions for DB remote access.

Damien · July 9, 2017 at 3:58 AM

Setup my advancedsettings.xml to connect to DB on local network.

Code

<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.1.28</host>
    <port>3306</port>
    <user>kodi</user>
    <pass></pass>
    <name>kodi_video</name>
  </videodatabase> 
  <musicdatabase>
    <type>mysql</type>
    <host>192.168.1.28</host>
    <port>3306</port>
    <user>kodi</user>
    <pass></pass>
    <name>kodi_music</name>
  </musicdatabase>
</advancedsettings>

Display More

setup the kodi user on myphpadmin.

Logs show it can't connect to DB and do what it needs to do.

I went under the assumption that it is only allowing localhost access, and tried adding an wildcard so all the IP(s) that the router can give would be cleared for access.

Stumped. What am I doing wrong?

**Klojum** · July 9, 2017 at 8:57 AM Official Post

It might be a good idea to post your questions on botu Kodi and LibreELEC forums, but as most of the "staff" people doing support on Kodi and LibreELEC are the same people, I personally get a bit annoyed.

In short:

First, get rid of the first entry in the mysql user table, as it is a humungous security flaw.

Secondly, use passwords. I have a feeling that Kodi (like in most programming languages) sees the av.xml line "<pass></pass>" different from the mysql "no password" option.