Connecting from one server to mysql on another server

[StuntasticAudi]

I need to connect to a database that is on a different server. What do i put for the hostname and how do i connect to it.

Step by step would help..thanks

[phranque]

in general, you have to:
- grant access to the user on the remote host in the mysql database on the db server
- make sure the mysql ip port is open (3306)
- turn on networking in the configuration file (my.cnf)
- specify the remote host when connecting to mysql, either by providing the argument in the access library method or using the -h option in the command line.

[StuntasticAudi]

So i go to phpmyadmin and then what?

can i get step by step