[SOLVED] Websites Cannot Connct to my database

[Deewad]

Hello, Tried 2 different websites, Both say Database connection failed: Access denied for user 'Deewadd'@'192.168.1.1' (using password: YES)

I have a wildcard% Placed on from host, Allows any IP To connect to my sql database, Also I typed 71.72.227.115, But it seems to come back at me, With both websites as 192.168.1.1

Any idea's, Any at all that have the smallest chance to cause this problem?

 

[Epicblood]

Are your ports forwarded and open?

 

[Deewad]

Server is public, Friends can join, 3306 is open, Friends can connect to database, And that's it

 

[Deewad]

There opened under service name AIM, Is there another one I need to open for the database for websites? http? telnet?

 

[Cubes]

Make the user connection %

So it will be a user that can connect from anything, not wildcard%

 

[Deewad]

Yes cubes, It's set as %, I was Quoting what Faded called it

 

[Parranoia]

That IP is a LAN ip address. You need your "external" IP. Go to http://whatismyip.org and find your correct IP

 

[Deewad]

Oh yes, Believe me I know, I set my External IP Address in there, But it comes back as a LAN IP

<?php
// Database settings
define('DB_HOST', '71.72.227.115');
define('DB_USER', 'Deewadd');
define('DB_PASS', 'MyPassword');
define('DB_NAME', 'auth');

 

[Jiinx]

Sorry if this has already been resolved but...

the Access denied for user 'Deewadd'@'192.168.1.1' (using password: YES) indicates that the user is either not allowed from that IP address (in MySQL) or that the password is incorrect.

a couple of things to check;
1. User names are case specific.
2. Ensure that in MySQL that the user Deewadd is set to '%' (unless it will always come from a specifc IP, then set it to that IP (in this case 192.168.%)
3. Ensure the password matches

 

[Hyperion]

Sorry if this has already been resolved but...

the Access denied for user 'Deewadd'@'192.168.1.1' (using password: YES) indicates that the user is either not allowed from that IP address (in MySQL) or that the password is incorrect.

a couple of things to check;
1. User names are case specific.
2. Ensure that in MySQL that the user Deewadd is set to '%' (unless it will always come from a specifc IP, then set it to that IP (in this case 192.168.%)
3. Ensure the password matches

Username aren't case sensitive, only the passwords are. He attempted to use the wildcard & but it's not working..
I am assuming he has something mixed up or backwards because he shouldn't be getting a connection from his router IP unless it was locally.

 

[Hyperion]

~marking the obvious solved