My SQL Server Name - IP changes by itself

[mnp13]

I was told that this might be a 'bug issue' and not a 'support issue'

--------------------------------------------------------------------------------------------

On my host the server name is not 'localhost' it is 10.10.0.229

when I hit 'proceed' the script attempts to access my database using 10.10.0.121 it does it automatically and we can't get it to actually use the information that I am putting in. The 121 is the address of the server my site is on, and for whatever the script wants to go there.

The customer service guy at my host company also tried it from there, and got the same message.

I have tried it 4 times now, and it is definately not me putting in a typo.

MySQL version 5.0.16
PHP version 5
SMF 1.0.5 new install

I posted about this on another part of the forum and was told to try 'localhost' (which I already knew didn't work) and 127.0.0.1 (which is localhost anyway)

with 127.0.0.1

Cannot connect to the MySQL database server with the supplied data.

If you are not sure about what to type in, please contact your host.
Can't connect to MySQL server on '127.0.0.1' (111)

When I use 10.10.0.229

Some of the queries were not executed properly. This could be caused by an unsupported (development or old) version of MySQL.

Technical information about the queries:
Line #17: CREATE command denied to user 'pitbullplace10'@'10.10.0.121' for table 'smf_attachments'
Line #43: CREATE command denied to user 'pitbullplace10'@'10.10.0.121' for table 'smf_banned'
Line #55: CREATE command denied to user 'pitbullplace10'@'10.10.0.121' for table 'smf_board_permissions'
Line #131: INSERT command denied to user 'pitbullplace10'@'10.10.0.121' for table 'smf_board_permissions'
Line #161: CREATE command denied to user 'pitbullplace10'@'10.10.0.121' for table 'smf_boards'
Line #169: INSERT command denied to user 'pitbullplace10'@'10.10.0.121' for table 'smf_boards'
Line #185: CREATE command denied to user 'pitbullplace10'@'10.10.0.121' for table 'smf_calendar'
(etc)

why is it changing the IP that I am putting in? That is the correct IP for the location of the database...

original thread:
http://www.simplemachines.org/community/index.php?topic=62845.0

Thank you,

Michelle

[Dannii]

Just a guess, but 10.10.0.121 is the server where your website/php files are located, but 10.10.0.229 is the mySQL server? I don't think it's changing the mysql server but it's something to do with your user. I would guess that you need to be 'pitbullplace10'@'10.10.0.229' to have access, wheras because the php files are on 10.10.0.121 you are trying to log into the server as 'pitbullplace10'@'10.10.0.121'. I don't know how to fix it, but I'd yell at your host a whole lot more until they can help you more

[mnp13]

Just a guess, but 10.10.0.121 is the server where your website/php files are located, but 10.10.0.229 is the mySQL server?

Yes.

I don't think it's changing the mysql server but it's something to do with your user. I would guess that you need to be 'pitbullplace10'@'10.10.0.229' to have access, wheras because the php files are on 10.10.0.121

I'm not sure I'm 'getting' what you mean about the first part, but yes, I need to have 229 to access MySQL. the PHP files are on 121, the installer is changing my input of 229 to 121 on it's own.

you are trying to log into the server as 'pitbullplace10'@'10.10.0.121'. I don't know how to fix it, but I'd yell at your host a whole lot more until they can help you more

LOL I tried that.

They have no idea why my input of 229 is being changed to 121 which is why they pointed me here. they can't move the database to 121 for me, because all of the databases live at 229. If the installer would leave the 229 alone everything would run fine.

*sigh*

why me?