MySQL problem

[tr-reallife]

is the mysql update ended?
because my forum etc. can't connect to the database.

I get this message:

SQL ERROR [ mysql4 ]

Can't connect to MySQL server on 'mysql-lotus.x10hosting.com' (4) [2003]

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

 

[Anna]

you need to set host to be 'localhost'

 

[tr-reallife]

but how can i do this?
I#m using phpbb 3 and wbb 3.1

 

[Anna]

I'm not familiar with wbb 3.1 but there should be a config file somewhere typically named config.php or settings.php, you can edit the file using code editor in cPanels file manager.

For phpbb3 the file you want to edit is config.php located in the root of the install. Open it with the code editor in cPanels file manager and make sure that line 5 reads: $dbhost = 'localhost'

 

[tr-reallife]

so, i have tried this with phpbb 3, but the same problem again:

SQL ERROR [ mysql4 ]

Can't connect to MySQL server on 'mysql-lotus.x10hosting.com' (4) [2003]

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

in the cpanel i can see my databases.

 

[Anna]

Might be server related then, you're not the only one on lotus reporting an issue with mysql, I'll alert an server administrator so they can check. Could be related to changes/upgrades as announced in the thread http://forums.x10hosting.com/news-announcements/110021-latest-news.html though

 

[Zubair]

so, i have tried this with phpbb 3, but the same problem again:


in the cpanel i can see my databases.

The error shows that your host is still 'mysql-lotus.x10hosting.com'

follow these steps.

1) go to cpanel file manager and find the file named 'config.php' it is located in forums root dir
2) edit this file in code editor.
3) make sure the data in file look like this

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'cpaneluser_dbname';
$dbuser = 'cpaneluser_dbuser';
$dbpasswd = 'password hidden';
$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';

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

 

[Anna]

The error shows that your host is still 'mysql-lotus.x10hosting.com'

It would still show that in the error as that is the actual address of the mySQL server, it is redirected there from 'localhost', and only access through that redirection is allowed on the database server which is why the host has to be 'localhost' for the script to work.

 

[tr-reallife]

so i have changed the dbhost to localhost but have the same problem:

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '';
$dbname = '*******';
$dbuser = '*******';
$dbpasswd = '*********';
$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';

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

i have this problem since tuesday/thurstday

Edit:
so does anyone have a clue why this don't want to work?
Is there a server-update?
Is something wrong with my phpb3 and wbb 3.1?

I think it must be something wrong with the databases.there are shown in the cpanel but i get this damn*d error.

Please help me....

regards,
tr-reallife

 

[diabolo]

Like ladyanna said,

Corey is working on a new version on the backend system. This may have caused mysql to go haywire. More info here: http://forums.x10hosting.com/news-announcements/110021-latest-news.html

 

[tr-reallife]

My MySql don't works yet.I thought the had fixed and updated the lotus.I just can't connect to the mysql databases.