2011-01-13, 08:07
Just wanted to drop a couple bits of knowledge that might be obvious to everyone else but took me quite a while to figure out while I was banging my head against the wall.
1) If you uninstall mysql on windows, it keeps any password you set unless (I think) you go in and manually delete the directory(s).
2) I had problems logging in from the command line, the command you want is mysql -u root -p
3) there is a bug in XBMC/mysql interactions, detailed here: http://trac.xbmc.org/ticket/10836
The workaround for that bug on windows is to make all of your sources have the format SMB://server/share . Anything else will fail.
1) If you uninstall mysql on windows, it keeps any password you set unless (I think) you go in and manually delete the directory(s).
2) I had problems logging in from the command line, the command you want is mysql -u root -p
3) there is a bug in XBMC/mysql interactions, detailed here: http://trac.xbmc.org/ticket/10836
The workaround for that bug on windows is to make all of your sources have the format SMB://server/share . Anything else will fail.