+- Forum (http://forum.xbian.org)
+-- Forum: Software (/forum-6.html)
+--- Forum: Configuration (/forum-17.html)
+--- Thread: [PROBLEM] MySQL cannot create db (/thread-2056.html)
MySQL cannot create db - thebestneo - 26th Jan, 2014 01:40 AM
Hi, i created xbmc user on my mysql server and gave grants to it, but i get these errors:
Code:
16:02:20 T:3041141280 ERROR: Unable to open database: MyMusic32 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:20 T:3041141280 ERROR: Unable to open database: MyMusic31 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:20 T:3041141280 ERROR: Unable to open database: MyMusic30 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:20 T:3041141280 ERROR: Unable to open database: MyMusic29 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:20 T:3041141280 ERROR: Unable to open database: MyMusic28 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:20 T:3041141280 ERROR: Unable to open database: MyMusic27 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic26 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic25 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic24 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic23 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic22 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic21 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic20 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic19 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic18 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic17 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic16 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic15 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic14 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic13 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic12 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic11 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic10 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic9 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic8 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic7 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic6 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic5 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic4 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic3 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic2 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic1 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyMusic32 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to create new database
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos75 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos74 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos73 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos72 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos71 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos70 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos69 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos68 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos67 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos66 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos65 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos64 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos63 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos62 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos61 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos60 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos59 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos58 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos57 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos56 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos55 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos54 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos53 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos52 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos51 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos50 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos49 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos48 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos47 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos46 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos45 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos44 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos43 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos42 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos41 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos40 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos39 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos38 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos37 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos36 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos35 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos34 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos33 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos32 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:21 T:3041141280 ERROR: Unable to open database: MyVideos31 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos30 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos29 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos28 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos27 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos26 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos25 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos24 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos23 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos22 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos21 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos20 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos19 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos18 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos17 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos16 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos15 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos14 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos13 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos12 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos11 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos10 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos9 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos8 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos7 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos6 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos5 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos4 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:2952709184 NOTICE: Thread CEC Adapter Update Thread start, auto delete: false
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos3 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos2 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos1 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to open database: MyVideos75 [1045](Access denied for user 'xbmc'@'xbian.local' (using password: YES))
16:02:22 T:3041141280 ERROR: Unable to create new databaseSo i cannot create databases. MySql server bind on 0.0.0.0. I can connect from xbian with mysql command line and create databases with same user and password.
This is my advanceconfig:
Code:
<advancedsettings>
<network>
<cachemembuffersize>20971520</cachemembuffersize>
</network>
<fanartres>720</fanartres>
<imageres>540</imageres>
<gputempcommand>echo "$(/opt/vc/bin/vcgencmd measure_temp | grep -o "[0-9]\{2\}") C"</gputempcommand>
<cputempcommand>echo "$(/opt/vc/bin/vcgencmd measure_temp | grep -o "[0-9]\{2\}") C"</cputempcommand>
<lookandfeel>
<webserver>true</webserver>
<guires>1080</guires>
</lookandfeel>
<bginfoloadermaxthreads>5</bginfoloadermaxthreads>
<video>
<adjustrefreshrate>
<override>
<fps>23.976</fps>
<refresh>24.0</refresh>
</override>
</adjustrefreshrate>
</video>
<gui>
<algorithmdirtyregions>3</algorithmdirtyregions>
<nofliptimeout>0</nofliptimeout>
<visualizedirtyregions>false</visualizedirtyregions>
</gui>
<destroywindowcontrols>0</destroywindowcontrols>
<useddsfanart>0</useddsfanart>
<videodatabase>
<type>mysql</type>
<host>192.168.0.110</host>
<port>3306</port>
<user>xbmc</user>
<password>xbmc</password>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.0.110</host>
<port>3306</port>
<user>xbmc</user>
<password>xbmc</password>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
</videolibrary>
</advancedsettings>So, why i get that errors?
RE: MySQL cannot create db - mk01 - 26th Jan, 2014 02:24 AM
by default MySQL granting system works by giving / revoking access to existing DBs, tables, or whatever.
role to create NEW db is not there by default. double check that. I started with creating mysqld package few weeks ago and there was no technical problem.
btw: still while you don't have databases, do a "chattr +C /var/lib/mysql". this will set NoCOW operations on new file within this directory (otherwise btrfs would be quite slow there).
RE: MySQL cannot create db - thebestneo - 26th Jan, 2014 02:30 AM
(26th Jan, 2014 02:24 AM)mk01 Wrote: by default MySQL granting system works by giving / revoking access to existing DBs, tables, or whatever.
role to create NEW db is not there by default. double check that. I started with creating mysqld package few weeks ago and there was no technical problem.
btw: still while you don't have databases, do a "chattr +C /var/lib/mysql". this will set NoCOW operations on new file within this directory (otherwise btrfs would be quite slow there).
So, i read that xbmc create db itself. If i connect with mysql -uxbmc -h192.168.0.110 -p then i can create db, but xbian cannot. What should i do?
RE: MySQL cannot create db - mk01 - 26th Jan, 2014 02:51 AM
unfortunately XBMC will try to create NEW DB with upgrades if structure changes. that leads to concern, that you have to give CREATE privilege but can be partially mitigated by telling XBMC to always name the DB with prefix (or instance 'xbmc_') and then you give full including create just to 'xbmc_%'
like this:
INSERT INTO `db` (`Host`, `Db`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`,`Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`, `Event_priv`, `Trigger_priv`) VALUES ('%','xbmc_%','xbmc','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
second row is dbname, third what you see as 'xbmc' is user name. so in you case 'xbmc'
)))prefix is defined in db definitions in advancedsettings, like pass or user :
<name>xbmc_MyVideos</name> =>
Code:
<videodatabase>
<type>mysql</type>
<host>192.168.0.110</host>
<port>3306</port>
<user>xbmc</user>
<password>xbmc</password>
<name>xbmc_MyVideos</name>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.0.110</host>
<port>3306</port>
<user>xbmc</user>
<password>xbmc</password>
<name>xbmc_MyMusic</name>
</musicdatabase>in that case xbmc will always alter only number and lla version will have name xbmc_MyVideos or Music.
RE: MySQL cannot create db - thebestneo - 26th Jan, 2014 04:29 AM
Uhm, but mine is a new installation, so I don't have any db to upgrade.
I read XBMC guide to setup mysql and this issue is not explained.
Anyway, I don't think I got your explanation..How can I force XBMC to create new databases? Can I create that databases manually?
RE: MySQL cannot create db - mk01 - 26th Jan, 2014 05:20 AM
doiesn't matter if you have or not.
in both cases xbmc wants to create new.
yes, you can create empty database (if you know the version for your current xbmc - because version number is in the name). but you hit the same problem when xbmc will updating db structure. later.
xbmc is ALWAYS in that case creating new first.
RE: MySQL cannot create db - thebestneo - 26th Jan, 2014 06:04 AM
Ok, so my solution is not good.
Can you re-explain me why it cannot create the new db? Permission problems?
RE: MySQL cannot create db - mk01 - 26th Jan, 2014 12:59 PM
yes. because mysql works by default by GRANTING privileges on object. not global.
try:
Code:
GRANT ALL ON *.* TO xbmc@%;RE: MySQL cannot create db - thebestneo - 26th Jan, 2014 08:50 PM
Same error: Unable to open database myvideos# or unable to create database.
I also did a flush privileges.
RE: MySQL cannot create db - thebestneo - 28th Jan, 2014 06:31 AM
Suggestions? I'm stuck
RE: MySQL cannot create db - teekay - 28th Jan, 2014 06:44 AM
Here is how I did it, maybe it helps.
Code:
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
GRANT ALL ON `MyMusic%`.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';
GRANT ALL ON `MyVideos%`.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';
GRANT TRIGGER ON `MyMusic%`.* TO 'xbmc'@'%';
GRANT TRIGGER ON `MyVideos%`.* TO 'xbmc'@'%';The last two only work on newer MySQL version >= 5.5 IIRC. Older ones need GRANT SUPER ON ...
Also read following about the <name> tag, mabe you have an issue with that one.
http://wiki.xbmc.org/index.php?title=HOW-TO:Share_libraries_using_MySQL/Setting_up_XBMC#Name_tag
R: RE: MySQL cannot create db - thebestneo - 28th Jan, 2014 06:53 AM
(28th Jan, 2014 06:44 AM)teekay Wrote: Here is how I did it, maybe it helps.
Code:
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
GRANT ALL ON `MyMusic%`.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';
GRANT ALL ON `MyVideos%`.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';
GRANT TRIGGER ON `MyMusic%`.* TO 'xbmc'@'%';
GRANT TRIGGER ON `MyVideos%`.* TO 'xbmc'@'%';
The last two only work on newer MySQL version >= 5.5 IIRC. Older ones need GRANT SUPER ON ...
Also read following about the <name> tag, mabe you have an issue with that one.
http://wiki.xbmc.org/index.php?title=HOW-TO:Share_libraries_using_MySQL/Setting_up_XBMC#Name_tag
First 3 lines are the same of mine.
I try others, i have mysql 5.5.
I didn't set the name tag...
RE: MySQL cannot create db - thebestneo - 1st Feb, 2014 09:10 PM
Same error, XBMC cannot create databases.
Should i try with root user?
RE: MySQL cannot create db - thebestneo - 2nd Feb, 2014 08:03 PM
Any help?
Done. It was a really stupid error:
Tag <password> instead tag <pass>.
Thank you