Kodi Community Forum

Ubuntu 14.04
Server: Localhost via UNIX socket
Server type: MySQL
Server version: 5.5.40-0ubuntu0.14.04.1 - (Ubuntu)
Protocol version: 10
User: xbmc@localhost
Server charset: UTF-8 Unicode (utf8)

Following the guide HERE
I have installed MySQL, created xbmc user and granted ALL xbmc permissions
I created my advancedsettings.xml file (below) into my userdate directory

The databases and tables are created but, they are not being populated

Here is the error in MySQL when I try to view the table

Quote:SQL query: DocumentationEdit Edit

SELECT `prefs`
FROM `phpmyadmin`.`pma_table_uiprefs`
WHERE `username` = 'xbmc'
AND `db_name` = 'xbmcvideo78'
AND `table_name` = 'movie'
MySQL said: Documentation
#1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist

If a log will help troubleshoot, please let me know which one to upload

advancedsettings.xml 192.168.1.99 is my local machine

Code:
<advancedsettings>

    <videodatabase>

        <type>mysql</type>

        <host>192.168.1.99</host>

        <port>3306</port>

        <user>xbmc</user>

        <pass>xbmc</pass>

        <name>xbmcvideo</name>

    </videodatabase> 

    <musicdatabase>

        <type>mysql</type>

        <host>192.168.1.99</host>

        <port>3306</port>

        <user>xbmc</user>

        <pass>xbmc</pass>

        <name>xbmcmusic</name>

    </musicdatabase>

     <videolibrary>

          <importwatchedstate>true</importwatchedstate>

          <importresumepoint>true</importresumepoint>

    </videolibrary>

    <network>

        <cachemembuffersize>0</cachemembuffersize>

    </network>

</advancedsettings>

Get rid of the name tags for the databases, not necessary. See what that does.

RESOLVED !!!

Thanks for the response Tight_wad

It seems I had an issue with my phpMyAmdin installation

I was able to resolve my problem by reconfiguring phpMyAdmin by running this in Terminal

Code:
sudo dpkg-reconfigure phpmyadmin

Thank you

DetrieZ

Tight_wad

DetrieZ