Forum

Hi, i created xbmc user on my mysql server and gave grants to it, but i get these errors:


So 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:

[/term]

So, why i get that errors?

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).

(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?

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> =>

in that case xbmc will always alter only number and lla version will have name xbmc_MyVideos or Music.

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?

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.

Ok, so my solution is not good.

Can you re-explain me why it cannot create the new db? Permission problems?

yes. because mysql works by default by GRANTING privileges on object. not global.

try:

Same error: Unable to open database myvideos# or unable to create database.
I also did a flush privileges.

Suggestions? I'm stuck

Here is how I did it, maybe it helps.


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

(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...

Same error, XBMC cannot create databases.

Should i try with root user?

Any help?

---

Done. It was a really stupid error:
Tag <password> instead tag <pass>.

Thank you