Topic: Trying to install phpBB but can't connect to database

[WEBlance]

I'm trying to install phpBB but can't connect to database. Just getting this message:

phpBB : Critical Error

Could not connect to the database

What could it be?

MySQL is up and running. I have a couple of osCommerse running on the server without problems. I'm running SME 7.

/Carl

[pippin]

Well i have 3 phpbb forum on my server and you just have to look in the root directory there is the root password for your sql database or you have to make a new user in mysql.Its your choice

[Mjohnson]

phpBB works quite well with SME 7.  

Did you create a new database??

Did you create a new database user?

If so  did you give the appropriate permisions to the user??

Is your config.php file correctly modified??

Folder/File permissions set up per phpBB recommendations?

Some more information would be very helpful in accessing the issue.

Thanks

MJ

[WEBlance]

Ok, I might not have explained myself correctly.

It goes like this:

I access the domain - domain.dk/forum (where the installation files are located)

I get the installation screen, fill out the fields and click "Start Install"

And the screen says:

phpBB : Critical Error

Could not connect to the database

[cactus]

Well i have 3 phpbb forum on my server and you just have to look in the root directory there is the root password for your sql database

... which you should never use for any application because this user has way to many privileges for an application account.

or you have to make a new user in mysql.Its your choice

That's indeed your only good choice.

I access the domain - domain.dk/forum (where the installation files are located)

I get the installation screen, fill out the fields and click "Start Install"

And the screen says:

phpBB : Critical Error

What values have you filled in? Perhaps a user account for mysql that does not exist? A database that does not exist?

To create a database:

Code: [Select]

mysql
create database databasename;
To make a user after you have created a database with full privileges on all tables of the newly created database:

Code: [Select]

grant all privileges on databasename.* to user@domain identified by `password`;(Be carefull don't forget the ticks around the password.

[WEBlance]

Well i have 3 phpbb forum on my server and you just have to look in the root directory there is the root password for your sql database

... which you should never use for any application because this user has way to many privileges for an application account.

or you have to make a new user in mysql.Its your choice

That's indeed your only good choice.

I access the domain - domain.dk/forum (where the installation files are located)

I get the installation screen, fill out the fields and click "Start Install"

And the screen says:

phpBB : Critical Error

What values have you filled in? Perhaps a user account for mysql that does not exist? A database that does not exist?

To create a database:

Code: [Select]

mysql
create database databasename;
To make a user after you have created a database with full privileges on all tables of the newly created database:

Code: [Select]

grant all privileges on databasename.* to user@domain identified by `password`;(Be carefull don't forget the ticks around the password.

Thanks cactus!

This worked for me!

/Carl

[byte]

Moving this topic to the SME 7.x contribs forum, it is more appropriate there. Thanks!

[pippin]

I know its not a good choice to use the root account of mysql or databse,but i am the only one to access the databse and in front i have smoothie taking care of unwanted dicheads trying to get access

Maybe it can be dangerous to do so cactus but i take the chance.

[cactus]

I know its not a good choice to use the root account of mysql or databse,but i am the only one to access the databse and in front i have smoothie taking care of unwanted dicheads trying to get access

Maybe it can be dangerous to do so cactus but i take the chance.

The problem is not you as only user but anyone who accesses the forum. If they somehow manage to include some code which will be interpretated by mysql they can alter stetings or even worse delete tables or data, this is called sql injection.

Please take a little bit of time and create a mysql user for your phpBB system it will only take a few seconds and will improve security as SME is developed for security. How to do this is in one of the posts above.