MySQL database on to a different host

[Simon James]

Hi I am new to MySQL - i seem to have a problem with connecting to the database on everything i try! At the moment I am trying to connect moodle to my MySQL database. I want the MySQL host to be pcol-webtest - as this is the server host - not locahost at all.

How do I change the host, do I have to set the database data directory onto that host?

Through MySQL Administrator its telling me the following:

Connected to MySQL Server Instance

Username: mooldeadmin (set this in command line)
Hostname: localhost
Port: 3306

Server Info

MySQL version: MySQL 4.1.10-nt via TCP/IP
Network Name: pcol-webtest
IP: 212.219.110.235
OS: Windows 2k

Can anyone help?

Thanks