Sorry to post something that's already in the stickies, but the old one was closed. Anyway, I have a question for those of you who may be PHP savvy--although this question actually refers more to SQL than PHP.

I have an SQL database, let's say that it's on localhost and the username is user and the password is pass. Now, when I try I get the output Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'user'@'remotehost' (using password: YES) in /home/content/47/9044447/html/new/index.php on line 12

Line 12 being, of course, the mysql_connect() function. And of course, remotehost is the actual IP address of the remote mySQL host.

phpMyAdmin seems to think that the SQL server is fine, and I KNOW the user name password and everything are correct, because I copied and pasted them from plain text into phpMyAdmin when I was creating the database, but it still isn't working. Is there something I have to do to enable PHP to connect to an outside server? If it makes any difference, I'm using GoDaddy as a host.

There are multiple reasons why its not working:
1. Most of the time you should be using localhost, or at least that is what I use most the time.
2. You didn't specify a database to connect to so you should add mysql_select_db("Database Name Here");

I can't remember if I used remote host on shared godaddy hosting or not but try localhost and add the query I gave you listed in #2.

JigSaw : Hmm, no change with either, and then both of those. I installed a couple of other softwares one the site, and they were able to connect just fine, and create tables and such all over the place, but my own custom code won't do it for some reason, and at this point, all I want to do is connect. It's a very simple script with just some html and the connect string.

Edit: Well, I'm not sure WHY it was happening, but it seemed to be a problem with the database I was trying to connect to, I've since made a new db and it connects just fine. Thanks for the help anyway!

Since your question has been answered can I close this thread? Or would you like to keep it open if others have questions relating to this topic?

RequiemHaunt : Well, I'm pretty sure this isn't the last question I'll ask, and I don't think I'm the only person who will ever ask a question, so I'd prefer not, unless you reopen the original PHP sticky.

I'll keep this thread open then unless told otherwise. I just wanted to make sure that it still had some use.

I know bad me double posting but I decided to reopen the original sticked thread and to close this one.