Posts: 21
Joined: Apr 2012
Reputation:
0
would I need to install mysql client on the media pc to check that?
| Cooler Master MasterCase Maker 5 | Gigabyte Aorus X299 Ultra Gaming Motherboard | Intel Core i7 [email protected] | Corsair Vengence 16GB x 2 Ram | Samsung SSD 960 PRO 512GB M.2 |
| Western Digital 1TB HDD | HGST Ultrastar 4TB HDD | Gigabyte GeForce GTX 950 Extreme | Ubuntu 20.04 x86_64 | Windows 10 Pro 1909 |
Posts: 279
Joined: Dec 2010
Reputation:
1
Finchy
Senior Member
Posts: 279
Yes, I think permissions is one of the things I'm struggling with. I've tried loads of times now - uninstalling and reinstalling (removing all files in the process), tried the WPI version of MySQL, the latest 64 bit, tried using the standard installation (which doesn't open the firewall ports), customised installs.
I can usually connect locally and remotely using SQLyog and see the databases, but can't change user permissions in it, even when connected locally as root.
I had created a user for the WHS with folder access and the XBMC one for MySQL (as it feels a bit wrong having the same username and password for a Windows and SQL user and having the password as plain text in an XML file!) but the Windows XBMC user definately has file/folder permissions.
Posts: 279
Joined: Dec 2010
Reputation:
1
Finchy
Senior Member
Posts: 279
2012-04-06, 22:07
(This post was last modified: 2012-04-06, 22:07 by Finchy.)
...for example, when I try
mysqlcheck -op -u xbmc xbmc_video
in the command prompt on the WHS with MySQL Server installed I get a 1045 error.
Posts: 279
Joined: Dec 2010
Reputation:
1
Finchy
Senior Member
Posts: 279
2012-04-07, 15:51
(This post was last modified: 2012-04-07, 15:53 by Finchy.)
OK, so thid is the process I have used;
Pre installation;
Network shares on WHS for the media folders set up, read/write access given to all relevant users and Homegroup users. Control checked by creating and deleting dummy files form another PC on the LAN.
Network share set up for XBMCthumbs with full read/write permissions.
MySQL installation;
Installed MySQL on WHS2011 via the Windows WPI installer (MySQL v 5.1)
Ran the config with standard installtion, set admin password, did not tick 'allow root access from remote machines'.
Added "skip-name-resolve" to the Mysqld section of the 'my.ini' file.
Changed the MySQL service to log on with the local administrator, stopped and restarted the service.
Added incoming and outgoing firewall access rules for port 3306 for domain and private connections.
MySQL XBMC setup;
Open up MySQL command line client and created the xbmc user and DB;
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
CREATE database xbmc_video;
CREATE database xbmc_music;
GRANT ALL ON *.* TO 'xbmc';
At this point should I not be able to test the MySQL DB from another PC on the network for connection? I'm trying to connect with SQLyog and MySQL Workbench from my laptop using the IP and XBMC username/password but it's not connecting. I can however connect to it from SQLyog on the WHS as both root and XBMC, but when I check the user priveledges in there it doesn't have any for XBMC on the xbmc_video or xbmc_music databases, and if I try to add them it gives me a 1044 error.
Do I need to do anything else to the settings/priveledges in MySQL, and if so, how?
Also, for clarification, I have an ATV2 and a Windows 7 PC that I want to connect to the SQL server, although I'm looking at installing XBMCbuntu on the Win 7 PC. Do I need to open the firewall for the Win 7 client as well?