XMBC and MySQL

[rbthompsonv]

(3rd Sep, 2013 11:58 PM)mk01 Wrote:  with mysql, the steps to check would be:
1) check whether mysql is accessible from .101 itself. for instance with:

Code:

mysql -u user_name_you_set -p

2) check whether the mysql is accessible for the user from other IPs (by default the access is just for localhost (127.0.0.1). you can do that still from the optiplex.

Code:

mysql -u user_name_you_set -h 192.168.1.101 -p

3) then check this from RPI…

btw: /home/xbian/.xbmc/temp/xbmc.log is quite useful in that case, what is in on the RPI?

OK, I can connect TO 101 FROM 101, but only locally... If I try to connect with the -h I get can not connect to host.
It also seems as if there isnt a password set for the xbmc user... I tried reading the docs for MySQL... but I must have the syntax wrong for assigning the user xbmc the password of xbmc...
Any pointers? (Im using: SET PASSWORD FOR 'xbmc' = PASSWORD (xbmc); But it kicks back saying theres an error on line 1