[tekno]

I have crystalbuntu on ATV1 (linux) that I installed mysql into and am trying to set up a shared database or databases. I think I am having issues with database permissions

I followed a guide here


http://lifehacker.com/5634515/how-to-syn...-the-house

I can get neither shared video nor music
in the xbmc log I see errors like


10:04:18 T:3008886592 ERROR: Unable to open database: MyMusic19 [1045](Access denied for user 'xbmc'@localhost (using password: YES))

Here is some more helpful info
mysql> show grants for 'xbmc'@'%';
+--------------------------------------------------------------------------------------------------------------+
| Grants for xbmc@% |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD '*EC4F5173DE994BFEAB7040A4A32B4ED6DE26F6F0' |
+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.12 sec)




mysql> select host, user, password from mysql.user;
+-----------------+------------------+-------------------------------------------+
| host | user | password |
+-----------------+------------------+-------------------------------------------+
| localhost | root | *EC4F5173DE994BFEAB7040A4A32B4ED6DE26F6F0 |
| crystalbuntu | root | *441F2E24F42FEE487C3EB3DA975CA253EA3F515C |
| 127.0.0.1 | root | *441F2E24F42FEE487C3EB3DA975CA253EA3F515C |
| ::1 | root | *441F2E24F42FEE487C3EB3DA975CA253EA3F515C |
| localhost | | |
| crystalbuntu | | |
| localhost | debian-sys-maint | *9EFDF87950A08F709DF23A0428C6D8CF0EA377E2 |
| % | xbmc | *EC4F5173DE994BFEAB7040A4A32B4ED6DE26F6F0 |
+-----------------+------------------+-------------------------------------------+
8 rows in set (0.05 sec)


mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test2 |
| mysql |
| performance_schema |
| test |
| xbmc_music |
| xbmc_video |
+--------------------+
7 rows in set (0.06 sec)


advancedsettings.xml (from machine hosting the database)

<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>127.0.0.1</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_video</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>127.0.0.1</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>xbmc_music</name>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
</videolibrary>
</advancedsettings>


any help appreciated

[saitoh183]

forget that deprecated guide and check the wiki

[tekno]

I see no difference other than the bind address which as I was connecting from localhost anyway should not seem to inhibit that, there is also naming the database in advancedsettings.xml but neither seems to work and the mysql version is 5.5

[nickr]

For a start get rid of the <name> entries in advancedsettings

[Ned Scott]

I see no difference other than the bind address which as I was connecting from localhost anyway should not seem to inhibit that, there is also naming the database in advancedsettings.xml but neither seems to work and the mysql version is 5.5

Actually, the whole reason the wiki guide got started was because the lifehacker article was outdated and it tells the user to manually create the MySQL DBs, which will completely break the setup.

[oarko]

should be easy to fix.

first
sudo nano /etc/mysql/my.cnf

change bind-address to ip of computer or my easy option add '#' before(less secure, but if not worried about other databases in mysql it is ok).

[ctr]x too exit Y to save

if you use the ip of computer change advancedsettings.xml at
<host>127.0.0.1</host> to <host>*ip of system*</host>

and yes remove the <name></name> tags

xbmc will create databases MyVideo## amd MyMusic## where ## is the database version.

That should solve your connection issues to mysql