Localhost on Cossacks

[Hoss212]

I have noticed that the movement with mysql back to localhost with cossacks has been complete. However my forums are still not up, do I have to change the host from mysql.x10hosting.com to localhost? If so, how because i'm totally stuck...

[Christopher]

You need to change the host back to localhost.
What script are you using?

[Hoss212]

SMF - Simple Machines Forum. How to change the host to localhost?

[Christopher]

Open the file settings.php
Find
########## Database Info ##########

change
$db_server = 'mysql.x10hosting.com';
to
$db_server = 'localhost';

[Hoss212]

Working like a charm now! Thanks mate, cheers!

[nbaulch]

I am having the same trouble locating where to make this change. I am using Coppermine image gallery and have searched the config.php which redirected me to admin.php.
I cannot find the mysql.x10hosting.com $db_server =

[Synkc]

searched the config.php which redirected me to admin.php.

Are you visiting the url directly?
You need to open the config file either with a file editor, or with the file manager in your cPanel.

[nbaulch]

Are you visiting the url directly?
You need to open the config file either with a file editor, or with the file manager in your cPanel.

I have been using the file manager in my cpanel. When I open the config.php I am getting: (without the slashes through the words)

define('IN_COPPERMINE', true);
require('include/init.inc.php');
if (!GALLERY_ADMIN_MODE) cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__);


$redirect = "admin.php";
$message = <<< EOT
You are trying to access Coppermine's <a href="admin.php">config page</a> using an outdated link - the file config.php has been renamed to admin.php. You probably updated your site and haven't changed your theme as suggested in the <a href="docs/theme/">theme upgrade guide</a>.<br />
You are now being redirected to the actual page you were looking for.
EOT;
pageheader($lang_info, "<meta http-equiv=\"refresh\" content=\"100;url=$redirect\" />");
msg_box($lang_info, $message, $lang_continue, $redirect);
pagefooter();
ob_end_flush();
?>

When I visit the url directly I am getting:

Coppermine critical error:
Unable to connect to database !

MySQL said: Lost connection to MySQL server at 'reading initial communication packet', system error: 110

I gathered that meant I have to open the admin.php... when I did I could not find anything like mysql.x10hosting.com :dunno:

BTW Thanks for your quick response
Edit:
oh..

username: nbaulch

www.baulch.x10hosting.com
cossacks

my image gallery is located at

www.baulch.x10hosting.com/gallery

[Synkc]

I'm downloading a copy of Coppermine at the moment so I can try and sort this out. I'll post back in a sec.

[Synkc]

Okay, the config settings for the database appear in the "config.inc.php" in the "includes" directory.

Simply change the $CONFIG['dbserver'] variable to equal 'localhost'.