I\'d like to use a mysql server on a different computer for my amarok collection. But when I try to connect I get an error similar to:
Host {ip} is not allowed to connect to this mysql server

What went wrong?

I think the user is not allowed to connect from a different computer than localhost.

How do I set up a user called \"amarok\" who is allowed? I tryed to look it up at mysql[dot]com, but I don\'t know where to look at.

Thanks
Calvin

hi calvin,
see the mysql FAQ:

use the GRANT command in the mysql shell an replace localhost through your other host.

----------------
$ mysql -p -u root
CREATE DATABASE amarokdb;
USE mysql;
GRANT select, insert, update, delete, create, drop, create temporary tables, index
ON amarokdb.* TO amarok@localhost IDENTIFIED BY \'PASSWORD_CHANGE_ME\';
FLUSH PRIVILEGES;
QUIT
---------------

harald