[black_eagle]

Sounds like it should do.  You can check that the user you have set up has the correct privileges by logging into the command line with mysql - u root -p and then executing the following bit of code.

SHOW GRANTS FOR 'user'@'%'; substituting user with the user you created.  eg, for a user xbmc you would do this, and get the following reply.

Code:

mysql> SHOW GRANTS FOR 'xbmc'@'%';
+-------------------------------------------+
| Grants for xbmc@%                         |
+-------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' |
+-------------------------------------------+
1 row in set (0.00 sec)

mysql>

As long as that's right and you put the same username/password combo into your advancedsettings.xml, Kodi will have the right permissions to be able to create and modify it's databases as required from any machine on your local network.