General Question

polycinco's avatar

I need urgent help with a database!

Asked by polycinco (187points) May 3rd, 2012

I don’t know what I did wrong and now this message appears on the website:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user ‘steve_wff’@‘208.113.246.18’ (using password: YES) in /home/steve_wff/worldfamousflags.com/usssa/system/database/mysql.php on line 6
Error: Could not make a database connection using steve_wff@mysql.worldfamousflags.com
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in /home/steve_wff/worldfamousflags.com/usssa/system/database/mysql.php on line 67

What can I do about this and what did I do wrong, someone help me please!!

Observing members: 0 Composing members: 0

15 Answers

wundayatta's avatar

Are you using the correct password?

polycinco's avatar

I wasn’t, but I changed it, now I’m getting this:
Parse error: syntax error, unexpected ’.’, expecting ’)’ in /home/steve_wff/worldfamousflags.com/usssa/system/database/mysql.php on line 5

This is my code:
public function __construct($mysql.worldfamousflags, $steve_wff, $aqui_sigo_yo_2245, $wff_shop) {
if (!$this->connection = mysql_connect($mysql.worldfamousflags, $steve_wff, $aqui_sigo_yo_2245) {
exit(‘Error: Could not make a database connection using ’ . $steve_wff . ’@’ . $mysql.worldfamousflags.com);
}

wundayatta's avatar

Why are the periods showing up? It doesn’t seem to like them. Perhaps you have them in the wrong places.

I don’t understand why your code has an error message in it.

polycinco's avatar

I don’t understand either. I changed it to underscores now I get this:
Parse error: syntax error, unexpected T_EXIT in /home/steve_wff/worldfamousflags.com/usssa/system/database/mysql.php on line 7

This is my code:
exit(‘Error: Could not make a database connection using ’ . $steve_wff . ’@’ . $mysql_worldfamousflags_com);

wundayatta's avatar

Is your code the error message you are receiving, or is that error message in your code?

polycinco's avatar

That’s what I’m getting when I go to this site where the code is:
http://www.worldfamousflags.com/usssa/

wundayatta's avatar

My guess is that it is telling you you are not constructing the name properly. I would expect it to want your name in a standard email address format. But you’re getting those extra periods in the name. But that’s just a guess. I don’t know what the site is expecting.

polycinco's avatar

Thank you, I have no idea either

ninjacolin's avatar

worldfamousflags has to be specified as as string like this:

‘worldfamousflags’

with the quotation marks.

replace all instances of $mysql.worldfamousflags with $mysql.‘worldfamousflags’

and I see there’s one instance of $mysql.worldfamousflags.com.. replace that with: $mysql.‘worldfamousflags.com’

ninjacolin's avatar

mysql_connect(string, string, string, boolean)

more.

polycinco's avatar

Thanks I tried that and now I get this:
Parse error: syntax error, unexpected ’.’, expecting ’)’ in /home/steve_wff/worldfamousflags.com/usssa/system/database/mysql.php on line 5

This is line 5: public function __construct($mysql.‘worldfamousflags.com’, $steve_wff, $aqui_sigo_yo_2245, $wff_shop) {

ninjacolin's avatar

oh man.. this is getting technical and code specific. You’re not declaring your constructor properly and I don’t know what paramters you need.

Try: public function __construct(){ with nothing inside the brackets.

polycinco's avatar

Oh my gosh, that’s bad. Nothing now I get this: http://www.worldfamousflags.com/usssa/

Do you know a lot about coding? I’m just a beginner. Could you help me? I’ll pay you some cash, I don’t have much but I will pay for your help!

ninjacolin's avatar

lol. I have to run unfortunately. Hopefully someone can help you.
Yes, I can tell you’re a beginner. hahaha.

earlier you shared this:
public function __construct($mysql.worldfamousflags, $steve_wff, $aqui_sigo_yo_2245, $wff_shop) {*
if (!$this->connection = mysql_connect($mysql.worldfamousflags, $steve_wff, $aqui_sigo_yo_2245) {
exit(‘Error: Could not make a database connection using ’ . $steve_wff . ’@’ . $mysql.worldfamousflags.com);
}
...

Does that code start at line 5?

polycinco's avatar

ha I know, what did I get myself into.

Yes that is the beginning of line 5 and it ends in line 8.

Last night I changed the password of the database but I didn’t think it would have anything to do with this and then I pressed modify by accident and maybe that’s whats causing this? I tried restoring the database but nothing. Do you think that had something to do with this?

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther