phpMyAdmin Connection for controluser as defined in your configuration failed

Question

So, today for the first time i installed XAMPP/LAMPP on Ubuntu 15.10. Apache server is working fine, but when i try to go to 'localhost/phpmyadmin' I get the following error:

And believe me i searched through whole internet, stack overflow, apache friends, etc. and none of given solutions worked for me... So this is my config.inc.php file:

<?php
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie'; 
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
//$cfg['Servers'][$i]['host'] = 'localhost';
//$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = true;

/**
 * phpMyAdmin configuration storage settings.
*/

/* User used to manipulate with storage */
// $cfg['Servers'][$i]['controlhost'] = '';
// $cfg['Servers'][$i]['controlport'] = '';
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation'; 
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords'; 
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent'; 
// $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
// $cfg['Servers'][$i]['users'] = 'pma__users'; 
// $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
// $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
// $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
// $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
 // $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
 // $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
/* Contrib / Swekey authentication */
// $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';

So you can see that my user = root and password is empty. But it simply doesn't work, i tried to change user/pass, tried to change controluser and controlpass, but nothing seems to work. Do you have any idea on how i can fix this problem?

Do you have a user "pma" with no password, defined in this MySQL server? Because your configuration is asking phpMyAdmin to try a connection with such user. — Marc Delisle
– Marc Delisle, Commented Oct 27, 2015 at 20:13
No, i didn't define anything in MySQL server? Can you explain me how should i do it? — Filip785
– Filip785, Commented Oct 27, 2015 at 20:26

Community · Accepted Answer · 2016-11-17 21:27:25Z

20

reinstall phpmyadmin and try

Code:

sudo dpkg-reconfigure phpmyadmin

if that doesn't work then try Code:

sudo apt-get --purge remove phpmyadmin

then reinstall, if that doesn't work I'm willing to bet it doesn't matter and do Code:

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf.d/phpmyadmin.conf

and restart apache Code:

##sudo /etc/init.d/apache reload sudo service apache2 reload

edited Nov 17, 2016 at 21:27

CommunityBot

11 silver badge

answered Mar 19, 2016 at 9:20

Rujika Rajan

3112 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Codify.Work · Accepted Answer · 2017-01-27 13:51:54Z

According to the config.inc.php you've posted, your root user password is 1234 (as I see in the line $cfg['Servers'][$i]['password'] ='1234';), but later in the file when you're defining the controluser, you use a blank password.

I suggest setting up an actual controluser with fewer permissions than root has, but the quick fix would be to edit and make this change: $cfg['Servers'][$i]['controlpass'] = '1234';

To create a controluser account, use an SQL command similar to this:

GRANT SELECT, INSERT, UPDATE, DELETE ON <pma_db>.* TO 'pma'@'localhost'  IDENTIFIED BY 'pmapass';

substituting the name of your phpMyAdmin configuration storage database (probably 'phpmyadmin') for <pma_db> and a custom password for pmapass.

MikeVe · Accepted Answer · 2015-10-27 19:09:44Z

3

Uncomment: ...

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost'; //<--UNCOMMENT THIS
$cfg['Servers'][$i]['connect_type'] = 'tcp'; //<--UNCOMMENT THIS

...

Since you need this to connect via localhost.

answered Oct 27, 2015 at 19:09

MikeVe

1,1309 silver badges15 bronze badges

2 Comments

Filip785 Over a year ago

Thanks for answer. I tried it right now, and it didn't fix it.

MikeVe Over a year ago

OK. There must be something else with your config file. If I comment these two lines i get the exact same error on my machine.

Osama Rizwan · Accepted Answer · 2021-01-29 06:55:45Z

3

Start by commenting out the controluser and controlpass lines in config.inc.php. Then you'll be able to log in with root, and use the Privileges or User accounts menu to add this pma user. It's explained in the documentation.

edited Jan 29, 2021 at 6:55

Osama Rizwan

6131 gold badge7 silver badges19 bronze badges

answered Oct 27, 2015 at 20:31

Marc Delisle

9,0253 gold badges32 silver badges29 bronze badges

3 Comments

Filip785 Over a year ago

When i comment out 'controluser' and 'controlpass' in config.inc.php and try to login as root, the "Connection for controluser as defined in your configuration failed" error disappear but "Cannot log in to the MySQL server" stays.

Marc Delisle Over a year ago

This means that you don't have the correct login information, or that the MySQL server is not running.

Filip785 Over a year ago

Alright man, i was not running MySQL server from XAMPP manager. Thanks for answer man, you are legend. So much time spent on this... Anyway, thank you very much.

Tunaki · Accepted Answer · 2016-01-10 09:57:52Z

2

Find the file config.default.php and replace

$cfg['Servers'][$i]['host'] = 'localhost';

with

$cfg['Servers'][$i]['host'] = '127.0.0.1';

then log in.

edited Jan 10, 2016 at 9:57

Tunaki

138k46 gold badges370 silver badges443 bronze badges

answered Jan 10, 2016 at 9:56

jeffrey

211 bronze badge

Comments

Krishneel Singh · Accepted Answer · 2020-10-01 09:20:00Z

I had a similar issue. I was able to do fix by following the video tutorial https://www.youtube.com/watch?v=NSX-ib2aMDQ

i just added skip-grant-tables to my.ini file. Below is a sample portion of my.ini file.

# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.
#
# You can copy this file to
# C:/xampp/mysql/bin/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is C:/xampp/mysql/data) or
# ~/.my.cnf to set user-specific options.
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.

# The following options will be passed to all MySQL clients
[client]
# password       = your_password 
port=3306
socket="C:/xampp/mysql/mysql.sock"


# Here follows entries for some specific programs 

# The MySQL server
default-character-set=utf8mb4
[mysqld]
skip-grant-tables
port=3306
socket="C:/xampp/mysql/mysql.sock"
basedir="C:/xampp/mysql"
tmpdir="C:/xampp/tmp"
datadir="C:/xampp/mysql/data"
pid_file="mysql.pid"
# enable-named-pipe
key_buffer=16M
max_allowed_packet=1M
sort_buffer_size=512K
net_buffer_length=8K
read_buffer_size=256K
read_rnd_buffer_size=512K
myisam_sort_buffer_size=8M
log_error="mysql_error.log"

Draken · Accepted Answer · 2017-04-21 10:41:13Z

1

It happened the same to me. But here's how I fixed it. Just reboot your browser whenever it gives you that error and log into the phpMyAdmin again. No code required, no configurations manipulation required

edited Apr 21, 2017 at 10:41

Draken

3,19614 gold badges38 silver badges56 bronze badges

answered Apr 21, 2017 at 10:17

XY-JOE

1,8021 gold badge13 silver badges10 bronze badges

Comments

ObSoft · Accepted Answer · 2018-09-11 14:56:25Z

1

Hey pal no need to change any file.. Its basically because your mysqli isnt running .. Check control panel for "action" column . You should see "Start" meaning its off, Your php can't speak to a sleeping database gate's locked.. That's why

To Solve it... Open the folder you installed the xampp app into, then click on xammp start and then accept all necessary approvals..

answered Sep 11, 2018 at 14:56

ObSoft

211 bronze badge

Comments

Zahirul Haque · Accepted Answer · 2019-04-24 15:44:29Z

1

sudo reboot

then start mysql if not auto start

sudo service mysql start

answered Apr 24, 2019 at 15:44

Zahirul Haque

1,66918 silver badges24 bronze badges

Comments

Samsul Islam · Accepted Answer · 2021-10-06 15:21:18Z

1

sudo chown -R mysql:mysql /var/lib/mysql

worked for me.

edited Oct 6, 2021 at 15:21

Samsul Islam

2,6192 gold badges20 silver badges24 bronze badges

answered Aug 9, 2018 at 17:59

Pavan Yogi

1782 silver badges7 bronze badges

Comments

Monal Soft · Accepted Answer · 2016-12-29 06:14:49Z

-2

Purging the phpmyadmin and install again worked for me.

Purge phpmyadmin using this command:

    sudo apt-get purge --auto-remove phpmyadmin

and install again:

    sudo apt-get install phpmyadmin

answered Dec 29, 2016 at 6:14

Monal Soft

3201 gold badge2 silver badges5 bronze badges

Collectives™ on Stack Overflow

phpMyAdmin Connection for controluser as defined in your configuration failed

11 Answers 11

Comments

Comments

2 Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

11 Answers 11

Comments

Comments

2 Comments

3 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related