[yomismo]

Hi!

I am having hard problems with the sql db. I have read this thread:

Server1 and Server3 merged with Server6

But I d not know how to add a new user: what user name I must use? And what password? How I make the pHpBB script can know the new user of the db?

[yomismo]

Anybody knows how to fix this problem?

[sizzlefire]

Go into your control panel, go to mysql, and from there you can create new users and databases.

[yomismo]

Thank you for your answer, but that's not the question. Creating a new user with his password is easy, but my problem is configurate phpBB to recognize the new user. How I do this step? Editing the config.php file?

Sorry if my English is bad, but my native tongue is Spanish.

My forum: http://www.derechocanonico.org/forum/

[sizzlefire]

Yes, you have to edit the config.php file and add the user, database, etc...

Also, we do have a spanish forum where you can get help in spanish...

[yomismo]

It's not working yet. I think the problem is now the server. The old config file indicates 'localhost' as server: it's that right? My cPanel indicates srv6 as server: is this the name of the db server too?

[yomismo]

This is the config.file of my pHpBB forum:

<?php


// phpBB 2.x auto-generated config file
// Do not change anything in this file!

$dbms = 'mysql4';

$dbhost = 'localhost';
$dbname = 'name';
$dbuser = 'new user';
$dbpasswd = 'new password';

$table_prefix = 'phpbb_';

define('PHPBB_INSTALLED', true);

?>

Everybody can see the answer of the db here:

http://www.derechocanonico.org/forum/

Anybody knows what's wrong?

[sizzlefire]

The database host is not localhost, this thread will help: MySQL & Name Servers

[yomismo]

Thank you, I have tried both server names, but not worked. My account is one of the oldest of 000webhost, and my cPanel is the old one; it doesn't show the server of the sql db, but pHpMyadmin shows localhost as server. By the way, pHpMyadmin can access correctly the db.

[sizzlefire]

Well, in that case, if its the old cpanel, that changes things, it IS localhost, login to the old cpanel, scroll down to mysql databases, and then the config page should look something like this:

<?php


// phpBB 2.x auto-generated config file
// Do not change anything in this file!

$dbms = 'mysql4';

$dbhost = 'localhost';
$dbname = 'dbname';
$dbuser = 'dbuser';
$dbpasswd = 'password';

$table_prefix = 'a*******_';

define('PHPBB_INSTALLED', true);

?>

Change the dbname, dbhost, password, and a*******_ to match your account.