Configuring Phpadmin

[qman]

Everything seems to be uploaded but I am getting config error.

"You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server."

 

Are the three lines below what is needed to configure my server? Do I need to enter anything other than user name and password?

 

If these are the correct lines, is localhost what neets to be in line 1?

If so should it be entered between quotation like "localhost" or 'localhost'?

 

$cfg['Servers'][$i]['host'] = "localhost"; // MySQL hostname or IP address

 

Does user name go in the line below?

 

$cfg['Servers'][$i]['controluser'] = "xusername''; // MySQL control user settings

 

Does password go in the line below?

// (this user must have read-only

$cfg['Servers'][$i]['controlpass'] = "pasword''; // access to the "mysql/user"

 

Thanks

 

Q

[TCH-Bruce]

Welcome to the forums gman

 

I am sorry I don't know if what you have is correct but someone will be along to confirm.

[TweezerMan]

Welcome to the forums, qman!

 

If these are the correct lines, is localhost what neets to be in line 1?

If so should it be entered between quotation like "localhost" or 'localhost'?

>$cfg['Servers'][$i]['host'] = "localhost"; // MySQL hostname or IP address

Yes, localhost is the proper value for host. Enclosing it in single quotes is recommended ('localhost'), although enclosing it in double quotes shouldn't cause any issues.

 

Does user name go in the line below?

>$cfg['Servers'][$i]['controluser'] = "xusername''; // MySQL control user settings

Does password go in the line below?

>$cfg['Servers'][$i]['controlpass'] = "pasword''; // access to the "mysql/user"

Part of your problem is that you're trying to enclose the controluser and controlpass values with a double quote on the left and 2 single quotes on the right (which can be seen above).

 

Unless you're installing phpMyAdmin on a dedicated server, I don't believe you can use the controluser and controlpass settings. Instead, you'd set the MySQL user and password here:

>$cfg['Servers'][$i]['user']          = 'xusername'; // MySQL user
$cfg['Servers'][$i]['password']      = 'password';  // MySQL password (only needed
                                                    // with 'config' auth_type)

I'm not sure if you're aware of this, but TCH accounts already have phpMyAdmin installed on them. You can access it by logging into your CPanel, clicking on the "MySQL Databases" icon, then scroll down to the very bottom of the page and click on the 'phpMyAdmin' link.

 

Hope this helps...

[TCH-Don]

Welcome to the forums, qman

[TCH-Rob]

Welcome to the forums, qman

[TCH-Thomas]

Welcome to the forum, qman.

[qman]

That will save me a lot of time. All I really need to do is to back up my bboard and install the new version. I got an email from Total Choice saying that I had to replace by bboards with newer versions. That is all I am really trying to accomplish.

 

Thanks

 

Jamws

 

I'm not sure if you're aware of this, but TCH accounts already have phpMyAdmin installed on them.  You can access it by logging into your CPanel, clicking on the "MySQL Databases" icon, then scroll down to the very bottom of the page and click on the 'phpMyAdmin' link.

 

Hope this helps...

<{POST_SNAPBACK}>

[TCH-Don]

You can also backup your database in cpanel>backup

download a database

And while you are in the backup page,

you can downlaod a home backup

to back up all your files.

depending on what forum you have and how new it is

you may be able to just upload changed files.

See your forums home page for more information.

 

Or let us know if you need any help.

[qman]

My problem is that I don't know anything.

I got my board up and running by pure luck. It is working perfectly and I wouldn't change anything if I wasn't required to. To me a phpbb is just a black box.

I need to find a way to start from the beginning.

 

For example, until today I didn't know that I had a database in addition to the bboard. Is there anywhere I can go and find out how to do this step by step with all of the terms explained.?

 

Thanks

 

James

 

You can also backup your database in cpanel>backup

download a database

And while you are in the backup page,

you can downlaod a home backup

to back up all your files.

depending on what forum you have and how new it is

you may be able to just upload changed files.

See your forums home page for more information.

 

Or let us know if you need any help.

<{POST_SNAPBACK}>

[TweezerMan]

If you mean explain how to upgrade your forum step by step, you might take a look at the installation instructions (which also covers upgrading) in the User Guide on the phpBB web site.