Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => Install and Upgrade Help => Aiheen aloitti: Hops - syyskuu 05, 2006, 06:15:50 IP

Otsikko: database problem during installation
Kirjoitti: Hops - syyskuu 05, 2006, 06:15:50 IP
SMF Version: SMF 1.1 RC3
Hi!
What a good job!

I've a problem with installation.
I've created a database on my host, hence I run install.php file to complete the installation. but when I fill every field with the correct data, the following message appears: 

The installer was unable to access the "smf" 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.

Click here to try this step again.

How can I solve the problem?
Thank u in advance

Otsikko: Re: database problem during installation
Kirjoitti: sawz - syyskuu 05, 2006, 06:20:50 IP
did you create a user to access the database?
Otsikko: Re: database problem during installation
Kirjoitti: Hops - syyskuu 05, 2006, 06:24:19 IP
Thanks 4 your quick reply! :)

I only have

HOST: sql.avianoland.com
USERID e DBNAME: xxxxxxxx
PASSWORD: ddddddd

that the host gave me the first time I created the database

Otsikko: Re: database problem during installation
Kirjoitti: sawz - syyskuu 05, 2006, 06:49:43 IP
so you have a:
host name
user name
db name
password
Otsikko: Re: database problem during installation
Kirjoitti: Hops - syyskuu 05, 2006, 06:51:41 IP
Lainaus käyttäjältä: sawz - syyskuu 05, 2006, 06:49:43 IP
so you have a:

host name: sql.avianoland.com
user name: xxx
db name: xxx
password: yyy


User name and dbname are the same

Otsikko: Re: database problem during installation
Kirjoitti: sawz - syyskuu 05, 2006, 06:53:34 IP
perhaps the db name is prefixed with your user name?

username_dbname
Otsikko: Re: database problem during installation
Kirjoitti: Hops - syyskuu 05, 2006, 06:56:55 IP
I try it....fingerscross! :P
Otsikko: Re: database problem during installation
Kirjoitti: Hops - syyskuu 05, 2006, 07:00:24 IP
no... :( it doesn't work

I tried:

host: sql.avianoland.com
MYSQl username: xxx_xxx
MYSQL PW: yyy

but I got this message


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.
Access denied for user 'xxx@'111.22.333.444' (using password: YES)
Click here to try this step again.

What do u think? Could it be a host problem?
Otsikko: Re: database problem during installation
Kirjoitti: Hops - syyskuu 05, 2006, 07:14:31 IP
I don't know why, but now it works and installation 's complete!
Perhaps it was a little error of my hoster, don't u think?

Thank u sawz! :)