PHP+MYSQL site transfer from Wamp localhost to web server.

[rickey84]

I have several sites running on local host. Recently i bought a website and i have been trying to transfer my ite from local host to web server and i have been getting this error.
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'root'@'localhost' (using password: YES) in /home/intmecco/public_html/Connections/UHD.php on line 9

Fatal error: Access denied for user 'root'@'localhost' (using password: YES) in /home/intmecco/public_html/Connections/UHD.php on line 9

The password for root is correct on localhost and web server but for some reason i keep getting this error.i have spent alot of time trying to figure it out but no luck.

i'll really appreciate if someone can help me with step by step transfer .I am using phpmyadmin, i have exported/imported the database already.
Databasses transfered:
mydata
mysql

I transfered the following folders/file to public_html on web server:
mmServerScripts
notes
Connections
mypage.php

Please tell me what i am missing here.

[big_nerd]

rickey84:

The password could not possibly be correct. The 'root'@'localhost' refers to the fact that you are attempting to sign on as root (which you never should, by the way) from the local machine.

There are many reasons why it may not be working, however I would double check the password that is being used or better yet - create a user with permissions for the specific databases that you have imported.

You can find a good tutorial here for this.

You will have to log on to your MySQL console to make these adjustments (using you root password).

I can not say enough not to use root for any of your websites, nor should you store the root password anywhere on the system.

With root access someone could very well destroy the databases for ALL of your websites if they wished to.

Once you have created the new user, and granted access to the database (which should be specified in UHD.PHP) adjust the login & pass from these PHP files to the new one that you have created.

Good luck!