mysql connection issues using port

[stary]

Hi all,

i'm helpless and totally no clues to what is to be done in order to connect to mysql using port. It seems that what is to be done has been done and mysql still can't connect using port.

okie.. my problem -- in mysql database, under user table, i've grant the required privileges and set the host name. However, when i try to connect using mysql -u user -ppassword -h hostname, i get this error, Unknown MySQL Server Host 'hostname'(1).

i've checked /etc/hosts on the hostname, the hostname is there and the correct host is also in the user table. but why issit that i still can't connect using port to mysql database?

pls help.

Cheers,
Stary

[hand]

Sorry, but I have to ask:
Do you take a real hostname, or do you write "hostname"
(Because of the error message "Unknown MySQL Server Host 'hostname'(1)

Is thery any firewall blocking between you and the host?
Which port? 3306? Take a look to my.cnf or my.ini.

A common problem here is that the Host value in the user table entry specifies an unqualified hostname, but your system's name resolution routines return a fully qualifieed domain name (or vice-versa). For example, if you have an entry with host 'tcx' in
the user table, but your DNS tells MySQL that your hostname is 'tcx.subnet.se', the entry will not work. Try adding an entry to the user table that contains the IP number of your host as the Host column value. (Alternatively, you could add an entry
to the user table with a Host value that contains a wild card|for example, 'tcx.%'. However, use of hostnames ending with `%' is insecure and is not recommended!)

mysqld writes all errors to the stderr, which the safe_mysqld script redirects to a file called 'hostname'.err. (On Windows, mysqld writes this directly to `\mysql\data\mysql.err'.)
This contains information indicating when mysqld was started and stopped and also any critical errors found when running.

Can you find there some further informations?

[stary]

Hand, thank you for replying.

some clarification --

(1) hostname is a real hostname
(2) the port is also set correctly in .my.cnf
(3) i've found out that i can only connect through localhost and 'abc'(hostname). but when i try to specify another entry in /etc/hosts, it would give me an error as i've posted earlier.
(4) the user table for host and privileges is set correctly, i have three rows whereby under the host column is the ip address, alias and the address similiar to the entry in host file.

My questions --
issit that mysql can only connect through port using one hostname? if this is not true.. how can i specify another hostname instead of using the default (abc) which already exists.. what changes need to be made and where can i make these changes?

thanks for any advice again.

cheers!

stary