I tried to reproduce the problem, but everything works for me. XBMCbuntu 11.0, fresh install.
Code:
sudo apt-get install mysql-server
Code:
mysql -uroot -p
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
GRANT ALL ON *.* TO 'xbmc';
exit;
(Creating the DB beforehand didn't work for me neither; I had to let XBMC create it.)
Added the following to advancedsettings.xml (inside <advancedsettings></advancedsettings> of course):
<videodatabase>
<type>mysql</type>
<host>localhost</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>localhost</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
(localhost because the mysql server is running on the same machine as the xbmc client)
Restarted xbmc.
Code:
mysql -uxbmc -p
show databases;
+--------------------+
| Database |
+--------------------+
| MyMusic18 |
| MyVideos60 |
+--------------------+
Notice that I didn't specify a DB name in advancedsettings.xml, so XBMC created "MyVideos60".
I didnt change any character sets. Many people have been talking about setting the character set to latin1 and collation to latin1_general_ci, but I didn't have to do anything in order to get it to work:
Code:
mysql> show variables like "character_set_database";
+------------------------+--------+
| Variable_name | Value |
+------------------------+--------+
| character_set_database | latin1 |
+------------------------+--------+
mysql> show variables like "collation_database";
+--------------------+-------------------+
| Variable_name | Value |
+--------------------+-------------------+
| collation_database | latin1_swedish_ci |
+--------------------+-------------------+
mysql> show create table path;
| path | CREATE TABLE `path` (
`idPath` int(11) NOT NULL AUTO_INCREMENT,
`strPath` text,
`strContent` text,
`strScraper` text,
`strHash` text,
`scanRecursive` int(11) DEFAULT NULL,
`useFolderNames` tinyint(1) DEFAULT NULL,
`strSettings` text,
`noUpdate` tinyint(1) DEFAULT NULL,
`exclude` tinyint(1) DEFAULT NULL,
PRIMARY KEY (`idPath`),
UNIQUE KEY `ix_path` (`strPath`(255))
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 |
use MyVideos60;
mysql> select idPath,strPath from path;
+--------+---------------------------------------+
| idPath | strPath |
+--------+---------------------------------------+
| 1 | / |
| 2 | /home/xbmc/Movies/ |
| 3 | /home/xbmc/Movies/American.History.X/ |
| 4 | /home/xbmc/Movies/Det.Fors�mte.For�r/ |
+--------+---------------------------------------+
mysql> select idFile, c00 from movie;
+--------+--------------------+
| idFile | c00 |
+--------+--------------------+
| 2 | American History X |
| 3 | Det Fors�mte For�r |
+--------+--------------------+
I've seen people on these boards talking about latin1 and latin1_general_ci multiple times, but I'm not really sure why. This was a fresh install and I followed the wiki which doesn't mention character sets.
If this post doesn't help you I'm afraid you'll have to hope for someone else to answer.