Forum
  • Search
  • Member List
  • Calendar
Hello There, Guest! Login Register — Login with Facebook

[PROBLEM] MySQL cannot create db
Thank you for your donation

Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Threaded Mode | Linear Mode
Problem: MySQL cannot create db
26th Jan, 2014, 01:40 AM
Post: #1
thebestneo Offline
Registered
Posts: 9
Joined: Jan 2014
Reputation: 0
MySQL cannot create db
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 database

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:

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>
[/term]

So, why i get that errors?
Find all posts by this user
Quote this message in a reply
26th Jan, 2014, 02:24 AM
Post: #2
mk01 Offline
Registered
Posts: 2,485
Joined: Mar 2013
Reputation: 209
RE: MySQL cannot create db
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).

Please read rules and do a search before you post! . FAQs . How to post log file? . Looking for answers? Please start here
Find all posts by this user
Quote this message in a reply
26th Jan, 2014, 02:30 AM
Post: #3
thebestneo Offline
Registered
Posts: 9
Joined: Jan 2014
Reputation: 0
RE: MySQL cannot create db
(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?
Find all posts by this user
Quote this message in a reply
26th Jan, 2014, 02:51 AM
Post: #4
mk01 Offline
Registered
Posts: 2,485
Joined: Mar 2013
Reputation: 209
RE: MySQL cannot create db
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' Smile)))

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.

Please read rules and do a search before you post! . FAQs . How to post log file? . Looking for answers? Please start here
Find all posts by this user
Quote this message in a reply
26th Jan, 2014, 04:29 AM
Post: #5
thebestneo Offline
Registered
Posts: 9
Joined: Jan 2014
Reputation: 0
RE: MySQL cannot create db
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?
Find all posts by this user
Quote this message in a reply
26th Jan, 2014, 05:20 AM
Post: #6
mk01 Offline
Registered
Posts: 2,485
Joined: Mar 2013
Reputation: 209
RE: MySQL cannot create db
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.

Please read rules and do a search before you post! . FAQs . How to post log file? . Looking for answers? Please start here
Find all posts by this user
Quote this message in a reply
26th Jan, 2014, 06:04 AM
Post: #7
thebestneo Offline
Registered
Posts: 9
Joined: Jan 2014
Reputation: 0
RE: MySQL cannot create db
Ok, so my solution is not good.

Can you re-explain me why it cannot create the new db? Permission problems?
Find all posts by this user
Quote this message in a reply
26th Jan, 2014, 12:59 PM
Post: #8
mk01 Offline
Registered
Posts: 2,485
Joined: Mar 2013
Reputation: 209
RE: MySQL cannot create db
yes. because mysql works by default by GRANTING privileges on object. not global.

try:
Code:
GRANT ALL ON *.* TO xbmc@%;

Please read rules and do a search before you post! . FAQs . How to post log file? . Looking for answers? Please start here
Find all posts by this user
Quote this message in a reply
26th Jan, 2014, 08:50 PM
Post: #9
thebestneo Offline
Registered
Posts: 9
Joined: Jan 2014
Reputation: 0
RE: MySQL cannot create db
Same error: Unable to open database myvideos# or unable to create database.
I also did a flush privileges.
Find all posts by this user
Quote this message in a reply
28th Jan, 2014, 06:31 AM
Post: #10
thebestneo Offline
Registered
Posts: 9
Joined: Jan 2014
Reputation: 0
RE: MySQL cannot create db
Suggestions? I'm stuck
Find all posts by this user
Quote this message in a reply
28th Jan, 2014, 06:44 AM
Post: #11
teekay Offline
Registered
Posts: 20
Joined: Jan 2014
Reputation: 9
RE: MySQL cannot create db
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
Find all posts by this user
Quote this message in a reply
28th Jan, 2014, 06:53 AM
Post: #12
thebestneo Offline
Registered
Posts: 9
Joined: Jan 2014
Reputation: 0
R: RE: MySQL cannot create db
(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...
Find all posts by this user
Quote this message in a reply
1st Feb, 2014, 09:10 PM
Post: #13
thebestneo Offline
Registered
Posts: 9
Joined: Jan 2014
Reputation: 0
RE: MySQL cannot create db
Same error, XBMC cannot create databases.

Should i try with root user?
Find all posts by this user
Quote this message in a reply
2nd Feb, 2014, 08:03 PM
Post: #14
thebestneo Offline
Registered
Posts: 9
Joined: Jan 2014
Reputation: 0
RE: MySQL cannot create db
Any help?

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

Thank you
Find all posts by this user
Quote this message in a reply
« Next Oldest | Next Newest »
Post Reply 


  • View a Printable Version
  • Send this Thread to a Friend
  • Subscribe to this thread
Forum Jump:

Current time: 11th May, 2025, 12:54 AM Powered By MyBB, © 2002-2025 MyBB Group.