mySQL error 1045

[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?

[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.

[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?

[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.

[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?

[timstephens24]

Yup, you'll be all set!

[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.

[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!

[davilla]

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.

[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.

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