mysql access error
#1
Hi, I've tried to add mysql into raspbmc (locally for now), following the wiki instruction, but I have this problem: "ERROR: Unable to open database: xbmc_video14 [1045](Access denied for user 'xbmc'@localhost (using password: YES))"
as you can see in my log: http://xbmclogs.com/show.php?id=13464

This is the command I did:
Code:
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
CREATE database xbmc_video;
CREATE database xbmc_music;

GRANT ALL ON *.* TO 'xbmc';

SELECT host,user from mysql.user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | xbmc             |
| 127.0.0.1 | root             |
| ::1       | root             |
| localhost |                  |
| localhost | debian-sys-maint |
| localhost | root             |
| raspbmc   |                  |
| raspbmc   | root             |
+-----------+------------------+
8 rows in set (0.00 sec)

SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
| xbmc_music         |
| xbmc_video         |
+--------------------+

flush privileges;

But it gave me always the same error, so I tried with:

Code:
GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%';
GRANT ALL ON xbmc_video.* TO 'xbmc';
GRANT ALL ON `MyMusic%`.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';
GRANT ALL ON `MyVideos%`.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc';
GRANT ALL PRIVILEGES ON xbmc_video.* TO [email protected]'%';

SHOW GRANTS FOR xbmc;
+--------------------------------------------------------------------------------------------------------------+
| Grants for [email protected]%                                                                                            |
+--------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD '*EC4F5173DE994BFEAB7040A4A32B4ED6DE26F6F0' |
| GRANT ALL PRIVILEGES ON `MyVideos%`.* TO 'xbmc'@'%'                                                          |
| GRANT ALL PRIVILEGES ON `MyMusic%`.* TO 'xbmc'@'%'                                                           |
| GRANT ALL PRIVILEGES ON `xbmc_%`.* TO 'xbmc'@'%'                                                             |
| GRANT ALL PRIVILEGES ON `xbmc_video`.* TO 'xbmc'@'%'                                                         |
+--------------------------------------------------------------------------------------------------------------+

flush privileges;

stop! Then I've posted my log above...this is my advancedsettings:
Code:
<advancedsettings>
    <videodatabase>
        <type>mysql</type>
        <host>localhost</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
        <name>xbmc_video</name>
    </videodatabase>
    <musicdatabase>
        <type>mysql</type>
        <host>localhost</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
        <name>xbmc_music</name>
    </musicdatabase>
</advancedsettings>

ps. this is a new raspbmc installation!
Reply
#2
Why are you creating the databases? Stop doing that, you don't need to do that as XBMC will create the databases when required.

You need to allow localhost access, so create user accounts that permit localhost access:

Code:
CREATE USER 'xbmc'@'localhost' IDENTIFIED BY 'xbmc';
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
GRANT ALL ON *.* TO 'xbmc';
quit;

That's all you need to do in MySQL, leave the rest up to XBMC (creating databases etc.).
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Reply
#3
thanks, now it works!! Smile
Reply



Logout Mark Read Team Forum Stats Members Help
mysql access error0
This forum uses Lukasz Tkacz MyBB addons.