The installer was unable to access the "xyz3_dev" database

[Artimidor]

SMF Version: SMF 1.1 RC2
Hello there!

I wanted to install SMF on my website, SMF V 1.1 RC2 to be precise, however I've encountered a problem already very early on, which to me seems unexplainable.

Problem is at the MySQL Server Settings. I get the following message:

"The installer was unable to access the "xyz3_dev" database. With some hosts, you have to create the database in your administration panel before SMF can use it. Some also add prefixes - like your username - to your database names."

Well. Actually I have prepared such a database already for SMF, which I've named "dev" - the xyz3 is added by the server itself obviously to identify the database. I've also added a user and provided the correct password etc. That the user is correct seems to be proven, because if I enter a wrong user I get another error message.

I think putting in the name "xyz3_dev" is correct as the name of the database, just as my user is called "xyz_username". However, there seems to be no chance to get the thing to work, whatever I try.

I'd like to note that I have a guestbook as well on the server which uses MySQL, and I've added the same user there, same password of course etc. and everything works perfectly fine there. Besides I can access the (empty) database through phpMyAdmin, so why is the installer incapable of doing so? - Any ideas?

Artimidor

[redone]

Check your MySQL information entered. Generally that means you have not either

a) created the database for use with SMF

or

b) created a user with access rights to the newly created database.

[Artimidor]

Yes, generally it means that, I assume... At my control panel I see however:

Database
xyz_dev

User
xyz_username (Privileges: ALL PRIVILEGES)

Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:xyz_dev:localhost","xyz_username","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "xyz_username", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("xyz_dev"); 

So... I don't see anything wrong with that...

[Artimidor]

Ok, I've managed to resolve the issue by now, so don't bother;) - At any rate, thanks for the help!

[redone]

What fixed the problem?

[Artimidor]

Problem was not SMF related, so no need to worry here.

My host decided to move the site to another server, which he did very well (no downtimes and such), but he failed to inform me in time about this... So while my FTP program uploaded to the domain address as it was configured, my bookmarked Control Panel pointed to the old server (which still existed). So adding databases and users at the old server of course had no effect on the domain... 

Artimidor