256 Kilobytes

Answers in Server-Side | By Some Guy

Published 10 months agoSun, 16 Dec 2018 09:33:56 -0800

230 views, 0 RAMs, and 1 comment

Tags: PHP, PHPmyadmin, Connection

Profile Photo - Some Guy Some Guy
🗎 3224 🗨 41 🐏 31
Subscriber

I need help with my Controluserprogramming in R, Connection using PHPmyadmin. I keep getting the message "Connection for controluser as defined in your configuration failed". What does this mean and what can I do to resolve the problem?

Download more RAM. 🐏 ⨉ 0 Posted by Some Guy 10 months ago 🕓 Posted at 16 December, 2018 09:33 AM PST

This is a patsy account used by the 256 Kilobytes staff to seed content. 

Profile Photo - Univa Univa
🗎 0 🗨 175 🐏 5
Author
  • Log in as root in phpMyAdmin
  • Create a database called PHPMyAdmin
  • Create a user called pma and set the "host" to the hostname or IP address of your web server, make a note of the password, and grant the new user full control over the phpmyadmin database. 
  • Go to the phpMyAdmin installation directory > SQL > create_tables.sql (file name), open it in a text editor.
  • Now go to phpmyadmin database > "SQL" tab. 
  • Copy/paste the entire text from create_tables.sql into the text box and run the query.
  • Open the config.inc.php file in the phpMyAdmin install directory, and add the following lines:
$cfg['Servers'][1]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][1]['controluser'] = 'pma';
$cfg['Servers'][1]['controlpass'] = '<your password>';

// Note: The list below may grow as PMA evolves and more control tables are added
// Use your common sense! Don't just blindly copypasta, look at what it means!
$cfg['Servers'][1]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][1]['relation'] = 'pma_relation';
$cfg['Servers'][1]['userconfig'] = 'pma_userconfig';
$cfg['Servers'][1]['table_info'] = 'pma_table_info';
$cfg['Servers'][1]['column_info'] = 'pma_column_info';
$cfg['Servers'][1]['history'] = 'pma_history';
$cfg['Servers'][1]['recent'] = 'pma_recent';
$cfg['Servers'][1]['table_uiprefs'] = 'pma_table_uiprefs';
$cfg['Servers'][1]['tracking'] = 'pma_tracking';
$cfg['Servers'][1]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][1]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][1]['designer_coords'] = 'pma_designer_coords';

 
  • Save and close the file.
  • Log out of phpMyAdmin and log in again
Download more RAM. 🐏 ⨉ 0 Posted by Univa 6 months ago 🕓 Posted at 24 April, 2019 08:13 AM PDT

Hello.

Post a New Comment

To leave a comment, login to your account or create an account.

Do you like having a good time?

Read Quality Articles

Read some quality articles. If you can manage to not get banned for like five minutes, you can even post your own articles.

View Articles →

Argue with People on the Internet

Use your account to explain why people are wrong on the Internet forum.

View Forum →

Vandalize the Wiki

Or don't. I'm not your dad.

View Wiki →

Ask and/or Answer Questions

If someone asks a terrible question, post a LMGTFY link.

View Answers →

Make Some Money

Hire freelancers and/or advertise your goods and/or services. Hire people directly. We're not a middleman or your dad. Manage your own business transactions.

Register an Account
You can also login to an existing account or recover your password. All use of this site is subject to terms outlined in the terms of service and privacy policy.