Now that we have installed the MySQL service, we need to add a new user. These credentials will be used by XBMC instances to interact with the database.
Firstly, we need to bring up the MySQL command-line interface. In Linux and OS X, this can be done by typing mysql
in the terminal/console. On Windows systems, go to Start Menu | Programs | MySQL and select MySQL Command Line Client. You will then need to enter the root password you set up during installation.
We can now create a new user called xbmc
and grant them sufficient privileges, as follows:
CREATE USER 'xbmc' IDENTIFIED by 'xbmc'; GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'localhost' IDENTIFIED BY 'xbmc'; GRANT ALL PRIVILEGES ON *.* TO 'xbmc'@'%' IDENTIFIED BY 'xbmc'; FLUSH PRIVILEGES