Install Problems - My SQL Server Name - IP changes by itself

[mnp13]

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

Help!!!

[mnp13]

I did a serach here and found a post that said to try changing 'localhost' to the actual address in the install file. When I refreshed the install page, the correct IP came up, but again changed itself when I hit 'proceed'

[beemer]

Just leave as localhost is shouldnt matter what your server name is

localhost works 99% of the time

[mnp13]

localhost does not work, I called my hosting provider to double check.

They specifically stated that I had to use the IP address for it to work. What I don't understand is that the installer is changing the IP number that I put in. How do I make it behave?

[mnp13]

bump...

[dtm.exe]

localhost does not work, I called my hosting provider to double check.

Your ISP has no control over your LAN.  In the IP field, try 127.0.0.1.

[mnp13]

127.0.0.1 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...

[Oldiesmann]

Did you try editing Settings.php?

[mnp13]

that is beyond my programming level, unless you can point me in the direction of the lines of code that I would change?