Moving DB from 2k3 server to 2K8 R2 causing remote connectivity issues

[Mark Gutierrez]

This is my first post and attempt to tackle something with SQL, my apologies if something i mention makes no sense. But as we upgraded servers the task to migrate SQL server is at a stand still, from 2003 to 2008 R2. I read that to move the database a dump needed to be made and then imported to avoid issues. Well another tech here copied directory over to the new server.
Now this is what is going on or needs to happen from research:

Another host record (same permissions) needs to be added for connecting from multiple remote hosts .
This is the “%” host record (user “root”) which saves adding individual remote hosts records.
There should be two host records in mysql (database) user (table) meeting these requirements.
Both records have same permissions set.

But where in the heck do i enter these records, i am thinking of something like active directory and adding member of permissions or is it syntax? Im a novice on this so bear with me.

Thanks in advance