“Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP

  1. Open phpMyAdmin in a browser and log in as root.
  2. Create a database called phpmyadmin
  3. Create a user called pma and set the “host” to the hostname or IP address of your web server (if the web server and MySQL are on the same box use localhost), make a note of the password, and grant the new user full control over the phpmyadmin database. It is recommended that this user does not have access to anything other than this database.
  4. Go to the phpMyAdmin installation directory, where you should find a sub-directory called sql.
  5. In sql you will find a file called create_tables.sql. Open it in a text editor.
  6. In phpMyAdmin, select the phpmyadmin database and click on the “SQL” tab.
  7. Copy/paste the entire text from create_tables.sql into the text box, and run the query.
  8. Open the config.inc.php file in the phpMyAdmin install directory, and add the following lines (or change the existing settings if they are already there):$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';
  9. Save and close the file.

IMPORTANT – PMA loads the config on login, evaluates it and stores it into the session data so the message will not disappear until you do this:

  1. Log out of phpMyAdmin and log in again

Problem solved.

Related Posts:

  1. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  2. How to log in to phpMyAdmin with WAMP, what is the username and password?
  3. mysqli_real_connect(): (HY000/2002): No such file or directory
  4. XAMPP Port 80 in use by “Unable to open process” with PID 4
  5. phpMyAdmin: secret passphrase?
  6. Forbidden :You don’t have permission to access /phpmyadmin on this server
  7. mysqli_real_connect(): (HY000/2002): No such file or directory
  8. How do I run a file on localhost?
  9. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  10. Xampp Access Forbidden php
  11. MySQL Daemon Failed to Start – centos 6
  12. Auto increment in phpmyadmin
  13. How to set 777 permission on a particular folder? [closed]
  14. count() parameter must be an array or an object that implements countable in laravel
  15. regex match any whitespace
  16. PHP page redirect
  17. phpMyAdmin Error: The mbstring extension is missing. Please check your PHP configuration
  18. Mysql query- How to use contains?
  19. How do I resolve a HTTP 414 “Request URI too long” error?
  20. xajax expanding list query
  21. Data source name not found, and no default driver specified
  22. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given in
  23. How do I redirect a page in jQuery?
  24. How to echo or print an array in PHP?
  25. Fatal error: Call to undefined function mysqli_connect()
  26. Resize image in PHP
  27. Illegal string offset Warning PHP
  28. What’s the purpose of ini_set() in php? (especially for error reporting)
  29. Send email with PHP from html form on submit with the same script
  30. PHP: $_SERVER variables: $_SERVER[‘HTTP_HOST’] vs $_SERVER[‘SERVER_NAME’]
  31. Illegal string offset Warning PHP
  32. Fatal error: Call to undefined function mysqli_connect()
  33. Could not open input file: artisan
  34. How to call a JavaScript function from PHP?
  35. Print array to a file
  36. I have a string with “\u00a0”, and I need to replace it with “” str_replace fails
  37. Finding the number of days between two dates
  38. MySqli Commands out of sync; you can’t run this command now
  39. Trying to get property of non-object in
  40. CURL ERROR: Recv failure: Connection reset by peer – PHP Curl
  41. PHP mail not working for some reason
  42. Get Root Directory Path of a PHP project
  43. How to reformat date in PHP?
  44. Returning JSON from PHP to JavaScript?
  45. Cannot simply use PostgreSQL table name (“relation does not exist”)
  46. How to create cron job using PHP?
  47. How do I expire a PHP session after 30 minutes?
  48. In_array not working
  49. How to make a countdown using PHP
  50. Imploding an associative array in PHP
  51. curl POST format for CURLOPT_POSTFIELDS
  52. Can’t use method return value in write context
  53. PHP get domain name
  54. How to solve “Fatal error: Class ‘MySQLi’ not found”?
  55. Running a Python script from PHP
  56. Object of class DateTime could not be converted to string
  57. HTTP Error 411, The request must be chunked or have a content length
  58. mysqli::query(): Couldn’t fetch mysqli
  59. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  60. Fatal error: Call to undefined function sqlsrv_connect()
  61. NotFoundHttpException in RouteCollection.php line 161: in laravel 5
  62. Easy way to password-protect php page
  63. Html encode in PHP
  64. file_put_contents: Failed to open stream, no such file or directory
  65. PHP $_POST not working?
  66. PHP cURL HTTP PUT
  67. Convert timestamp to readable date/time PHP
  68. PHP sessions that have already been started
  69. Contact Form 7 – Custom Validation
  70. How to output JavaScript with PHP
  71. file_get_contents(“php://input”) or $HTTP_RAW_POST_DATA, which one is better to get the body of JSON request?
  72. file_get_contents( ) not working
  73. WRONGTYPE Operation against a key holding the wrong kind of value php
  74. What is the advantage of using try {} catch {} versus if {} else {}
  75. Check if URL has certain string with PHP
  76. Subtracting days, months or years from date using php
  77. Laravel – Model Class not found
  78. Fatal error: Call to a member function fetch_assoc() on a non-object
  79. Strict Standards: Only variables should be assigned by reference PHP 5.4
  80. mysqlworkbench giving version error on exporting database
  81. Steam Market API?
  82. PHP array delete by value (not key)
  83. PHP mail: Multiple recipients?
  84. Having a problem getting mysqli_query to execute
  85. Returning JSON from a PHP Script
  86. PHP Multiple Checkbox Array
  87. Session variables not working php
  88. Get JSON object from URL
  89. How to push both value and key into PHP array
  90. Find the last element of an array while using a foreach loop in PHP
  91. Popup window in PHP?
  92. How can you use php in a javascript function
  93. How to bypass (deprecated) reCAPTCHA V1?
  94. Start and stop a timer PHP
  95. PHP variables don’t evaluate in the query [duplicate]
  96. Adding days to $Date in PHP
  97. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ””)’ at line 2
  98. I installed WordPress locally now how do I login?
  99. Plugin can’t write to database even though permissions appear correct?
  100. why not selecting multiple rows of same standard_id using SQL query from database?

Leave a Comment

tech