to the remote server

By sending the Database to the remote server I exported the talbes as sql.
But when I attempted to open at the remote server I got:

Could not connect: Access denied for user 'root'@'localhost' (using password: NO)

How can this be changed?

localhost is not a remote server; it's your own computer. Check with your hosting provider (given that's what you actually mean) whether they allow remote connections and, if so, what's your login info: server, user and password.

Very likely, the control panel of your hosting plan allows you to create users and databases. Have a look at it.

THis is what I get:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'gillumin'@'64.191.114.150' (using password: YES) in /www/.../index.php on line 14
Could not connect: Access denied for user 'gillumin'@'64.191.114.150' (using password: YES)

http://www.heidisql.com/forum/viewtopic.php?t=238

Ok let me make myself clear.

If I upload to an online host is there anything I should do to the database and the php script?

The message "Access denied" can have different causes, which are described here. Please check that.

However, most common causes in my opinion are:
- there is something wrong in the username or password you're passing in your script or client
- your user-account is not allowed to connect from the specific host you're currently on (in your case that is 64.191.114.150). Solvable by editing the user account on the server.