11-13-2011, 05:18 PM
I found a workaround...
I deleted the mysql database and started over with this:
But that just gave me lots of errors.
Then I deleted the databases, and gave the xbmc user all privleges globally.
Rebooted and the databases where created correctly
No errors in the xbmc.log (at least about databases).
So now I started a import from a backup...
I deleted the mysql database and started over with this:
Code:
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
CREATE DATABASE xbmc_music CHARACTER SET latin1 COLLATE latin1_general_ci;
CREATE DATABASE xbmc_video CHARACTER SET latin1 COLLATE latin1_general_ci;
GRANT ALL ON bbcode.txt insert_posts.sh mybb_posts.csv mybb_posts.sql oej34_kunena_messages.csv oej34_kunena_messages_text.csv oej34_kunena_messages_text.sql oej34_kunena_users_banned.csv oej34_kunena_users.csv oej34_users.csv openelecj34prod.sql posts.sh replace.sh test.csv test.txt update_sample.sql TO 'xbmc';
But that just gave me lots of errors.
Then I deleted the databases, and gave the xbmc user all privleges globally.
Rebooted and the databases where created correctly

No errors in the xbmc.log (at least about databases).
So now I started a import from a backup...