Page 1 of 1

Could not connect to the database - ideas?

Posted: Sat Feb 18, 2006 3:18 am
by unktehi
Template(s) used:

Any and all MODs:

Do you use a port of phpBB:

I'm getting this error when I try to install phpbb:

"phpBB : Critical Error

Could not connect to the database "

I'm not sure if the mySQL/MySQLadmin is installed properly (as the host has never installed either before). I'm not sure if it's a problem with phpbb (me) or with php or mysql/mysqladmin...any ideas?


Version of phpBB:
Version of PHP: unsure
Which database server and version:
Host: MySQL 3.23.54
Did someone install this for you/who: I'm trying to
Is this an upgrade/from what to what: no
Is this a conversion/from what to what: no
Have you searched for your problem: yes
If so, what terms did you try: connect, critical
State the nature of your problem: unable to connect to database
Do you have a test account for us:

Posted: Sat Feb 18, 2006 3:21 am
by Psychotic_Carp
You usually get that when your typing the wrong item in the wrong field.

Posted: Sat Feb 18, 2006 3:25 am
by unktehi
Well, I'm not sure what would be typed in the wrong field. I've looked over it several times, and re-tried it several times (and have also installed a forum on another server and it worked fine).

Posted: Sat Feb 18, 2006 3:30 am
by Psychotic_Carp
Could your server be running something other than php4?

Posted: Sat Feb 18, 2006 3:31 am
by unktehi
It could be, but I thinkt this is most likely the problem. When I log into the mysql admin this error is displayed:

Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account. Your MySQL server is running with this default, is open to intrusion, and you really should fix this security hole.

Any idea where the host can get information on fixing this?

Posted: Sat Feb 18, 2006 5:07 pm
by unktehi
Is there an article or someplace I can get information on setting up the mysql and php correctly - so that I can send to my hoster?

Posted: Sat Feb 18, 2006 5:18 pm
by AcousticJames
The initial MySQL accounts have not been setup. When MySQL is installed, there are two accounts named "root"; one for localhost and one for a hostname/IP address. By default, these accounts do not have a password set, you need to set one. Then you also need to setup two separate user accounts with the same user/pass that aren't admin accounts. One for localhost, one for a hostname/IP address.

Right now, you are trying to use MySQL with the root accounts that have no password set for them. This is a HUGE security risk.

Look at the MySQL documentation at http://dev.mysql.com for information on Securing the initial MySQL accounts and setting up new user accounts. Use that account information in config.php.

Posted: Sat Feb 18, 2006 5:23 pm
by unktehi
Thanks - I'll send this info on to the host. Hopefully it'll help them understand things a little bit better.

Posted: Sat Feb 18, 2006 5:33 pm
by Lumpy Burgertushie
why are you using a host that doesn't know what they are doing. I hope you aren't paying for this.

robert

Posted: Sat Feb 18, 2006 6:33 pm
by unktehi
No, I'm not paying for it. If it were my choice, I'd switch. I'm helping a friend with his website, and the hoster is his brother - who didn't have php or mysql installed, let alone mysqladmin.