Jump to content
qman

Configuring Phpadmin

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Welcome to the forums, qman! :thumbup1:

 

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...

Share this post


Link to post
Share on other sites

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...

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...