HI, i'm trying to create a user in mysql (my distro is SuSE 9.2). I rembember i had to use '@' or '%'. I'm trying to access from another host using Mysqladmin but it gives no answrr, if i use the console (ssh) from the same host or locally it does give me access.
any idea?

It sends the following error 2003 can't connect to MySQL server on "xxx.xxx.xxx.xxx" (10061)
SOcket error on connect. WSAGetLastError RETURN 10060 ($274C)

Thanks

could be one of two things:

1. You have your mysql server binding to your loopback device i.e 127.0.0.1

In/etc/mysql/my.cnf (location on gentoo dont know about suse) look for a part that says
replace "127.0.0.1" with the actual ip address, or hostname.

2. You only gave permission for your user to connect from localhost, and not a remote pc.

When you run mysql from the command line you enter users with this command:
change "localhost" to the actual ip/hostname of the pc.

Last thing, mysql-administrator won't let you alter users from remote PC's only when you connect from localhost. You might wanna try "phpmyadmin" as well...

Thanks Defi, it worked just fine:
GRANT ALL PRIVILEGES ON *.* TO 'monty'@'myipaddress' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;