Page 2 of 3
Re: mySQL error 1045
Posted: 21 Jul 2018, 00:58
by jabohn
Thanks Tim. I had forgotten I had already run those commands last night. So now it enabled successfully in MrMC and I figure out what to do next as the instructions appear to end at setting up SQL on my computer.
Do I just go about and add a new source like usual, only now it silently stores in info in SQL?
Re: mySQL error 1045
Posted: 21 Jul 2018, 01:20
by timstephens24
Your sources should hopefully still be there, but yeah if they're not just add your sources and scan everything in. Now it'll all be stored on your
MySQL server instead of locally on your Apple TV.
Re: mySQL error 1045
Posted: 21 Jul 2018, 01:23
by jabohn
I had to delete my sources and start over right before doing this. I only added my TV sources before turning on SQL. What do I do to get that into SQL?
Re: mySQL error 1045
Posted: 21 Jul 2018, 01:24
by timstephens24
Long press on the source to get the context menu, and do a 'Set Content' (I think that's what it is) and set it as TV Shows.
Re: mySQL error 1045
Posted: 21 Jul 2018, 01:28
by jabohn
Thanks Tim. So I told it to refresh and it's now scanning. Doing that, then adding my Movies source and it should be good?
Re: mySQL error 1045
Posted: 21 Jul 2018, 01:33
by timstephens24
Yup, you'll be all set!
Re: mySQL error 1045
Posted: 21 Jul 2018, 03:27
by jabohn
Thanks for your help!
I had one observation since redoing my library, when I refresh the new source, in the bottom left corner is says "MAC failed" and then my computer name JMAC failed. But the library otherwise refreshes and works properly. I've never seen that before. I added the source using the Windows Network (
SMB) choice.
Re: mySQL error 1045
Posted: 21 Jul 2018, 03:38
by jabohn
Since the instructions in the Wiki are incomplete and incorrect for setting up on a Mac, here are the final steps I used to get this working, so it's all in one place should anyone need it in the future:
Setup Instructions for MySQL on a Mac:
1. Download a copy of
MySQL server from
http://dev.mysql.com/downloads/mysql/ and install it.
2. In macOS, go to System Preferences ->
MySQL, and click on “Start
MySQL Server”. You’ll also want to tick to enable the “Automatically … on Startup” option.
3. Now to set up the "mrmc" user in
MySQL and give it access. Launch Terminal.app on your Mac and issue the following commands, one line at a time:
Code: Select all
/usr/local/mysql/bin/mysql -u root -p
<Insert MySQL root password>
CREATE USER 'mrmc' IDENTIFIED BY 'mrmc';
GRANT ALL ON *.* TO 'mrmc';
exit
4. Now go into MrMC -> Settings -> Services ->
MySQL Client
5. In the server field, enter the IP address from your Mac. It can be found on your Mac in System Preferences -> Network.
6. In username and password fields, put mrmc
7. Check Enable at the top of the screen.
8. Now add your sources as usual and you're good to go.
Someone please correct me if I got anything wrong!
Re: mySQL error 1045
Posted: 21 Jul 2018, 13:47
by davilla
jabohn wrote: 21 Jul 2018, 03:27
Thanks for your help!
I had one observation since redoing my library, when I refresh the new source, in the bottom left corner is says "MAC failed" and then my computer name JMAC failed. But the library otherwise refreshes and works properly. I've never seen that before. I added the source using the Windows Network (
SMB) choice.
debuglog would show the error.
Re: mySQL error 1045
Posted: 17 Nov 2018, 07:12
by jabohn
davilla wrote: 21 Jul 2018, 13:47
jabohn wrote: 21 Jul 2018, 03:27
Thanks for your help!
I had one observation since redoing my library, when I refresh the new source, in the bottom left corner is says "MAC failed" and then my computer name JMAC failed. But the library otherwise refreshes and works properly. I've never seen that before. I added the source using the Windows Network (
SMB) choice.
debuglog would show the error.
The MAC error happened again multiple times. It appears to happen when adding a new source and then scraping it.
https://pastebin.com/Ekv07CQN