mysql server connection problem

[muniappan]

hellow friends,

this is Muniappan from Purple Green Technologies, India.

i found one error while accessing remote MySQL database.

about MySQL is

Verson :MySQL Server 4.1

my command for access remote machine is: c:/>MySQL/MySQL Server 4.1/bin>mysql -u pgt-04 -h root GRS

where

pgt-04: remote System name

GRS : database name in pgt-04 machine

Error i got: "ERROR 2005 <HY000>:unknown MySQL Server host 'root' <11001>"

i want solution to this problem. this is very urgent.

reply me soon

regards

muniappan

[Scarecrow Man]

It appears MySQL is looking for the hostname portion of the command where you are typing the root part of the command. What does the root mean? You could try

mysql -u root -h pgt-04 GRS

But, I have 0 experience with SQL so you may want to wait for a more solid answer.

[Scarecrow Man]

Did some googling:

mysql -u root -p pgt-04 GRC

mysql -u root -h localhost -p pgt-04 GRC

-u means user

-h means host

-p means server

[doug]

Report:

i yet solve my problem with MySQL

i need help pls.......

tell me the solution

regards

muniappan

Reply from muniappan which was misposted.

[Scarecrow Man]

Bump?

http://www.w3schools.com/sql/default.asp

[scuzzman]

OP: Are you still experiencing difficulty?

Bumping this just in case...