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
« Next Oldest | Next Newest »
Post Reply 


Messages In This Thread
MySQL cannot create db - thebestneo - 26th Jan, 2014 01:40 AM
RE: MySQL cannot create db - mk01 - 26th Jan, 2014, 02:24 AM
RE: MySQL cannot create db - thebestneo - 26th Jan, 2014, 02:30 AM
RE: MySQL cannot create db - mk01 - 26th Jan, 2014, 02:51 AM
RE: MySQL cannot create db - thebestneo - 26th Jan, 2014, 04:29 AM
RE: MySQL cannot create db - mk01 - 26th Jan, 2014, 05:20 AM
RE: MySQL cannot create db - thebestneo - 26th Jan, 2014, 06:04 AM
RE: MySQL cannot create db - mk01 - 26th Jan, 2014, 12:59 PM
RE: MySQL cannot create db - thebestneo - 26th Jan, 2014, 08:50 PM
RE: MySQL cannot create db - thebestneo - 28th Jan, 2014, 06:31 AM
RE: MySQL cannot create db - teekay - 28th Jan, 2014, 06:44 AM
R: RE: MySQL cannot create db - thebestneo - 28th Jan, 2014, 06:53 AM
RE: MySQL cannot create db - thebestneo - 1st Feb, 2014, 09:10 PM
RE: MySQL cannot create db - thebestneo - 2nd Feb, 2014, 08:03 PM

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

Current time: 23rd Nov, 2024, 03:24 AM Powered By MyBB, © 2002-2024 MyBB Group.