February 4, 201412 yr I've been running a MySQL install on a 4.7 server for many years to centralise an XBMC DB, all worked well. Recently upgraded to unRAID 5.05 and at first the MySQL install was fine, btw this was a package install of mysql-5.0.67-i486-1.tgz. Initially I had some issues with Couchpotato and other plugins and I tracked this down to an AirPlay package conflict. Now since then and all my plugins now working fine the MySQL install has stopped working with the following error when I try a re-install from the unMENU package manager Starting mysqld daemon with databases from /mnt/disk3/mysql/ ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) ERROR 1130 (00000): Host 'localhost' is not allowed to connect to this MySQL server It is as if the 'root' user has either been disabled or had it's password changed? My config settings via the package manager is for the 'root' to not have a password and this has worked fine up until a couple of days ago. Now I'm happy to move across to a new MySQL plugin install but in its current state I can't do a XBMC library export and then a re-import into a new DB. I know, I should of done this before the upgrade, I forgot! Any pointers or words of wisdom to get my current MySQL back up and running so I can export and save all my watched status of films/tv?
February 5, 201412 yr Just went through this myself with another app. I'm not an expert but the problem looks like you are accessing with root and no password but with 5 you need to use a user with a password to access. You can't use root any more to access shares. You may need to remove previous saved paths using root and make new ones using a user and password.
February 5, 201412 yr Author Think you are probably right about the security change in 5 and no password. I'm find to fix this on shares etc and have done so already but in this case I'm stuck not being able to gain access to my SQL instance in order to change it, if root is locked out, how do I change the root account to have a password? Seems a bit catch22! Also it didn't happen as soon as I upgraded to 5, it happened a few day later which I though was odd. So any wise words as to how I recovery access to a MySQL to a root account that's been locked out?
February 5, 201412 yr if root is locked out, how do I change the root account to have a password? If all else fails go back to an earlier version of 5 before 5.0.3 I think, I was running beta14, and change your root PW via the web interface then change back to your current version. I believe all you need to do is replace 2 files bzroot and bzimage if you stay with 5.
February 5, 201412 yr Author That seems like a fair idea. Don't know of any reason why I can't go back to an earlier version? All I would need to do is connect my XBMC box and export the data as a backup, then I can forget the old SQL and work with a new plugin once back to 5.0.5.
February 9, 201412 yr You sure the root password for mySQL is not "root"? The default user for the share data is nobody and the apps have to read and write files to the drives as nobody. Actually, you can read and write data to the shares as root but the files won't be accessible over the network. But, that has nothing to do with mySQL root user.
February 9, 201412 yr Author Nope, tried root as the password also. Thanks for the suggestion though. I've given up on my old SQL install and I'm recreating my XBMC library from scratch locally. Once that's finished I'll start with a new plugin version of MySQL and import.
Archived
This topic is now archived and is closed to further replies.