2016-02-14, 22:26
Hi all,
Last day, I've begin to change all my network device with static ip to DHCP because I've got now a DNS Server at home.
But, I have some problem with my Kodi device.
I use it with Mysql for a while and when I created the user, I've use the IP to limit access to the kodi database:
I know, I didn't follow totally what the wiki said but as a sysadmin, I didn't want to allow all privileges to kodi user, and not on all my network (I have other database on my server)
But know, like I said I want to rename my [email protected] user to [email protected].
I did it, and it work except for view table (movie_view, tvshow_view, etc...). After some research I fount that they're triggers to some table and they didn't work because the user didn't exist anymore !!
I've read that we can't change the trigger user, I have to delete it and recreate it with the good one. I'm not very confortable with MySQL/MariaDB so I don't know what trigger really are...
So what the best to do here ??
1- Make an awesome query to delete and recreate the trigger correctly
2- Export database, create a new one with correct user and import my old database to it (with Kodi, not SQL)
3- Put a static address to my DHCP (<= Is what I do now, but when I want to put another Kodi device I will have the problem too...)
Thanks for you help
Last day, I've begin to change all my network device with static ip to DHCP because I've got now a DNS Server at home.
But, I have some problem with my Kodi device.
I use it with Mysql for a while and when I created the user, I've use the IP to limit access to the kodi database:
Code:
MariaDB [(none)]> select host, user, password from mysql.user;
+-----------------------+-------------+-------------------------------------------+
| host | user | password |
+-----------------------+-------------+-------------------------------------------+
| localhost | root | *D51CD80D02A472E2C61E8384E54D8482F98F0397 |
| 192.168.1.52 | kodi | *FAE53F8FFEF5EB8333496E10C050FFF76526FDE9 |
+-----------------------+-------------+-------------------------------------------+Code:
MariaDB [(none)]> show grants for 'kodi'@'192.168.1.52';
+----------------------------------------------------------------------------------------------------------------+
| Grants for [email protected] |
+----------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'kodi'@'192.168.1.52' IDENTIFIED BY PASSWORD '*FAE53F8FFEF5EB8333496E10C050FFF76526FDE9' |
| GRANT ALL PRIVILEGES ON `MyVideos93`.* TO 'kodi'@'192.168.1.52' |
+----------------------------------------------------------------------------------------------------------------+I know, I didn't follow totally what the wiki said but as a sysadmin, I didn't want to allow all privileges to kodi user, and not on all my network (I have other database on my server)
But know, like I said I want to rename my [email protected] user to [email protected].
I did it, and it work except for view table (movie_view, tvshow_view, etc...). After some research I fount that they're triggers to some table and they didn't work because the user didn't exist anymore !!
I've read that we can't change the trigger user, I have to delete it and recreate it with the good one. I'm not very confortable with MySQL/MariaDB so I don't know what trigger really are...
So what the best to do here ??
1- Make an awesome query to delete and recreate the trigger correctly
2- Export database, create a new one with correct user and import my old database to it (with Kodi, not SQL)
3- Put a static address to my DHCP (<= Is what I do now, but when I want to put another Kodi device I will have the problem too...)
Thanks for you help