Updating to MYSQL 5

[dotchan]

My server has recommended that I change all of my databases over to MYSQL 5.  So I have, and now there's a shiny new database called "username_database" instead of the old "database" (not the actual names, obv, just using them as an example).

However, when I try to change the Config file to pull from this new database, it keeps giving me a "cannot connect to database" error.

My current config file, with some of the information changed for security's sake:

$db_servertype = "mysql";
$db_host = "localhost";
$db_name = "database";
$db_user = "user";
$db_password = "password";

$table_prefix = "4images_";

The information on my new DB server host is as follows (with the username changed for security's sake)

MySQL

    * Server: Localhost via UNIX socket
    * Server version: 5.0.82-msl-usrs-sure2-log
    * Protocol version: 10
    * User: username@localhost
    * MySQL charset: UTF-8 Unicode (utf8)

Web server

    * Apache
    * MySQL client version: 5.0.82
    * PHP extension: mysqli

What am I doing wrong?

[V@no]

Hello, dochan. Welcome to 4images forum.

Did you have 4images running on this server before?

As you said the new database is "username_database", however in your config.php it's "database"
Also, maybe as username you need use "username@localhost" ?

[dotchan]

Did you have 4images running on this server before?

Yes, I still have a 4images gallery running on xxx: dotchanxxx: /gallery with the old MYSQL 4 database.

As you said the new database is "username_database", however in your config.php it's "database"
Also, maybe as username you need use "username@localhost" ?

I've tried both of those.  Neither work.

*EDIT* Nevermind, I've asked my host, and I'll try their suggestions first.