MySQL/Setting up MySQL: Difference between revisions
< MySQL
Jump to navigation
Jump to search
(sudo restart mysql doesn't work anymore on newer Ubuntu builds. It's now sudo service mysql restart) |
(clearer warning in restricting rights) |
||
Line 215: | Line 215: | ||
#<code>GRANT ALL ON `MyVideos%`.* TO 'kodi'@'%' IDENTIFIED BY 'kodi';</code> | #<code>GRANT ALL ON `MyVideos%`.* TO 'kodi'@'%' IDENTIFIED BY 'kodi';</code> | ||
{{ | {{redv|'''Careful'''|The limited grants on this page don't give the kodi user permissions to create required TRIGGERs during install or upgrade. '''Kodi requires these TRIGGERs to function properly.''' <br /> | ||
The limited grants on this page don't give the kodi user permissions to create required TRIGGERs during install or upgrade. | Use the broader grant *.* statement that is explained on the previous tabs while creating or upgrading the tables. Only restrict rights afterwards, if you need to. <br> | ||
'''Kodi requires these TRIGGERs to function properly.''' | |||
Use the broader grant *.* statement that is explained on the previous tabs while creating or upgrading the tables. Only restrict rights afterwards, if you need to. | |||
Alternatively, figure out how to specifically give the account the right to create the require TRIGGERS - this varies between MySQL versions. }} | Alternatively, figure out how to specifically give the account the right to create the require TRIGGERS - this varies between MySQL versions. }} | ||
<headertabs /> | <headertabs /> |
Revision as of 16:28, 6 February 2017
Share libraries w/MySQL, guide: |
MySQL | Setting up MySQL |
You'll need to choose which of your computers, Kodi devices, or NAS will be the MySQL server. The server needs to be on 24/7 or have wake-on-lan (preferably the former), and needs to have a local static IP. You will probably want the Kodi device that is hosting most or all of your videos and music to also be the MySQL server, but this is not required.
Please Note: Don't create the MySQL databases on your server. Simply set up the MySQL server itself, as Kodi will create the specific databases by itself.
Also: Some versions of MySQL set their passwords to expire by default, even the root password! If the password expires, Kodi cannot access the database and the TV Series and Movies libraries will disappear.
To avoid this and/or fix it after it happens, make sure the account's password does not expire. (See: https://dev.mysql.com/doc/refman/5.7/en/password-expiration-policy.html )
To avoid this and/or fix it after it happens, make sure the account's password does not expire. (See: https://dev.mysql.com/doc/refman/5.7/en/password-expiration-policy.html )
MySQL can be installed on just about every major OS:
Next step: | Setting up Kodi |