2013-04-22, 12:34
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:
But it gave me always the same error, so I tried with:
stop! Then I've posted my log above...this is my advancedsettings:
ps. this is a new raspbmc installation!
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 xbmc@'%';
SHOW GRANTS FOR xbmc;
+--------------------------------------------------------------------------------------------------------------+
| Grants for xbmc@% |
+--------------------------------------------------------------------------------------------------------------+
| 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!