Hi
Ok, I'm struggling to set up MySQL on MrMC on my Dlink DNS 327l NAS using the NAS add on phpMyAdmin.
I've managed to set up a user via phpMyAdmin and granted full access.
I've set up the Server as my NAS drive 10.0.1.5 in the MySQL settings of MrMC and tried to define a video database name of mrmcvideos. When I click enable I get 'couldn't open database'.
My ATV 4 IP is 10.0.1.10
I tried some of the tips from the forum topic 'Enabling MySQL' with no luck. I get messages from phpMyAdmin like database doesn't exist etc.
e.g I tried GRANT ALL PRIVILEGES ON `mrmc%.*` To 'mrmc'@'10.0.1.10’ IDENTIFIED BY 'mrmc';;
flush privileges;
I'm at a loss, could be its just gone midnight, though it's likely just me.
Cheers
LS
Setting up MySQL on NAS using phpMyAdmin [SOLVED]
- timstephens24
- Posts: 894
- Joined: 09 Dec 2015, 22:43
Re: Setting up MySQL on NAS using phpMyAdmin [SOLVED]
When you run the following on your Dlink do you have any 'MyVideo', 'MyMusic', 'mrmcvideo', or 'mrmcmusic' databases?
Also make sure the user was created with the following:
If not create your user and define your permissions (I would recommend not setting an IP, but if you want to get more specific I would set something like 'mrmc'@'10.0.1.%'):
If so make sure the permissions are set properly:
Side note: If the only thing you're running MySQL for is Kodi/MrMC, then by all means use the following permissions:
Code: Select all
show databases;
Code: Select all
SELECT User FROM mysql.user;
Code: Select all
CREATE USER 'mrmc' IDENTIFIED BY 'mrmc';
GRANT ALL ON `mrmcvideos%`.* TO 'mrmc'@'%' IDENTIFIED BY 'mrmc';
GRANT ALL ON `mrmcmusic%`.* TO 'mrmc'@'%' IDENTFIEID BY 'mrmc';
FLUSH PRIVILEGES;
Code: Select all
SHOW GRANTS FOR 'mdmc';
Code: Select all
GRANT ALL ON *.* to 'mrmc';
Last edited by timstephens24 on 28 Dec 2015, 21:58, edited 1 time in total.
-
- Posts: 13
- Joined: 28 Dec 2015, 08:42
Re: Setting up MySQL on NAS using phpMyAdmin
timstephens24...You have have been a great help, hail to you!!
I followed your instructions and it's scanning movies as I type.
I did get a couple of syntax type errors, that I basically ignored as I wasn't she what they meant. However all is working.
I can't believe how fast the library scan is compared to what it used to ben my ATV2 Kodi install.
Thanks again for your help timstephens24.
Cheers
LS
I followed your instructions and it's scanning movies as I type.
I did get a couple of syntax type errors, that I basically ignored as I wasn't she what they meant. However all is working.
I can't believe how fast the library scan is compared to what it used to ben my ATV2 Kodi install.
Thanks again for your help timstephens24.
Cheers
LS
- timstephens24
- Posts: 894
- Joined: 09 Dec 2015, 22:43
Re: Setting up MySQL on NAS using phpMyAdmin
Glad it's working!
-
- Posts: 1
- Joined: 13 Aug 2016, 13:25
Re: Setting up MySQL on NAS using phpMyAdmin
I keep going around in circles with this and i'm getting annoyed. The support from the developers is not good at all.
I have a database setup with Kodi ip address/phpmyadmin.
All i want to do is set it up for mrmc as well. i'm far from an expert so i dont need any crazy computer lingo. i setup the original database while following a youtube video.
help me get this setup for mrmc please and make my $6 worth it.
I have a database setup with Kodi ip address/phpmyadmin.
All i want to do is set it up for mrmc as well. i'm far from an expert so i dont need any crazy computer lingo. i setup the original database while following a youtube video.
help me get this setup for mrmc please and make my $6 worth it.
- davilla
- Team MrMC
- Posts: 4377
- Joined: 26 Oct 2015, 17:01
Re: Setting up MySQL on NAS using phpMyAdmin
MrMC support MySQL under kodi v16.x series. If you are using Kodi v17 alpha/beta. Sorry, not compatible.r3vvedup wrote:I keep going around in circles with this and i'm getting annoyed. The support from the developers is not good at all.
I have a database setup with Kodi ip address/phpmyadmin.
All i want to do is set it up for mrmc as well. i'm far from an expert so i dont need any crazy computer lingo. i setup the original database while following a youtube video.
help me get this setup for mrmc please and make my $6 worth it.
http://forum.mrmc.tv/viewtopic.php?f=9&t=52 is a very clear explination of what do do.
As this is your 1st post, not sure why you say "support from the developers is not good at all". ?