[JackieBrown]

I followed this guide
http://wiki.xbmc.org/index.php?title=HOW...untu_Linux

My setup (at least where I'm at)
I am trying to get this working on my local machine first. I have all my shows saved on that machine as well as my xbmc.

I skipped the steps for installing mysq as I have it installed for nZEDB and I binded the address to 0.0.0.0.

My advanced settings config is

Code:

<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>localhost</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
    </videodatabase>
     <videolibrary>
          <importwatchedstate>true</importwatchedstate>
     </videolibrary>
</advancedsettings>

When I log into xbmc, I am unable to scan content so I have no library mode.

It let's me act like I'm setting the content, but it doesn't actually keep.

[JackieBrown]

I know better - sorry - I'll post a debug log shortly

[nokdim]

You are probably missing:

CREATE USER 'xbmc' IDENTIFIED BY 'xbmc'
and
GRANT ALL ON *.* TO 'xbmc';

which creates a user named xbmc which will allow your XBMC install to create a new DB with username xbmc and pass xbmc.

Once you post a debug log we will know more but that is my initial guess.

[JackieBrown]

The problem was the user being unable to create the database. I took the insecure route and used my root user