Hi guys

im after some help setting up Mysql for XBMC now please bare with me as  i have no linux/SQL knowledge what so ever!

Ive installed MySQL via Unmenu

with the following settings

 

Hostname: Tower

Disk Label: disk1

MySQL root Password: root

First Database: Tower

Database User: user

Database User Password: password

Custom parameters:

 

so from what i understand i need to logon to Mysql command line and Enter the following commands:

Type in: CREATE USER 'xbmc' IDENTIFIED BY 'xbmc'; and press return

Type in: GRANT ALL ON *.* TO 'xbmc'; and press return

 

I can telnet to my Unraid server and get the

root@Tower:~# command prompt

 

BUT now im stuck what do i have to do to enter the above Mysql commands

 

any help greatly appreciated

 

 

 

 

 

 

 

Type: mysql -u {user} -p

YOU SIR! are the MAN!

on another not having got home and gave this ago the only account it seems to let me in on is root with the password root

 

if i use  mysql -u {user} -p with the password root or password i get this error

ERROR 1045 (28000): Access denied for user '{user}'@'localhost' (using password: YES)

 

 

replace {user} with the actual username you want to log in as. According to your listing above that should be 'user' (sans quotes). So after you have entered the console write:

 

mysql -u user -p