Jump to content



Photo

Trying To Connect From A Different Machine On Which Mysql Is Running In A Local Area Network.


  • Please log in to reply
1 reply to this topic

#1 lalo

lalo

    Newbie

  • Members
  • Pip
  • 6 posts

Posted 4 July 2011 - 8:37 AM

Hi:
I want to connect my computer from a different computer on
which MySQL is running in an ethernet network (local area network).That
means that I don t want to use the localhost hostname.
What is the hostname in the command ?:
GRANT privileges ON database.* TO 'username'@'hostname' IDENTIFIED BY
'password'.
Please give a specific example.
I have installed MySQL (on Windows) with the option :root access from
a remote machine enabled.

Thank you in advance.
  • 0

#2 Larry

Larry

    Administrator/Writer

  • Administrators
  • 3,783 posts
  • LocationState College, PA (USA)

Posted 4 July 2011 - 10:07 PM

The hostname would be the IP address of the client machine connecting.
  • 0