SQL Error

[Northsider]

I have read the sticky but I am a newbie at this and need further assistance/guidance.

I just got this message when trying to access my forum:

General Error

SQL ERROR [ mysql4 ]

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [2002]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

-domain: http://thebluline.co.nr (http://www.theblueline.x10hosting.com/northsider/phpbb3/phpBB3/)
-cPanel login: northsid
-free package

Thanks in advance for the help.

 

[Synkc]

Are you using "localhost" as the address for the MySQL database server?
If so, you need to change it to: mysql.x10hosting.com

 

[Northsider]

When I installed phpBB3 I believe I set it to localhost...how would I go about changing it? Thanks for the response!

EDIT: I changed my config.php to this:

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'mysql.x10hosting.com';
$dbport = '';
$dbname = 'northsid_phpbb3';
$dbuser = 'northsid_admin';
$dbpasswd = 'misfits';

$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);

It's working now...was that really the only problem?

EDIT 2: Blah! Now I get this message after logging in:

General Error
SQL ERROR [ mysql4 ]

Access denied for user 'northsid_admin'@'absolut.x10hosting.com' (using password: YES) [1045]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

 

[Synkc]

Go to the directory that phpBB3 is installed on and open the file called config.php. Now just change the variable "$dbhost" to have the value: "mysql.x10hosting.com".

By the way, good luck with your site

 

[Northsider]

Please see my edits above

 

[Synkc]

I think Corey is in the middle to transferring Absolut's MySQL database to the new server; check the Serve Alerts section of the forums for information.

If that's not the problem, then I'm not sure what the problem could be; I'm not hosted on Absolut, so I can't look it up on my account. Best just to wait for a staff member.

 

[Northsider]

Ok, I will do that. Thanks for the help Synkc

 

[devedse]

i get a sql error to (i just want to say that)