• Register
1 vote
101 views

Problem :

I am very new to XAMPP. I have recently installed the XAMPP on the Windows machine. But suddenly I have started getting below error:

“Connection for controluser as defined in your configuration failed.”

I had my MySQL database installed on my Windows machine and it also had the password. I tried to change my old password and also tried to put the password in my config.inc.php for my MySQL and after that change I started getting above error: If ever I try to access my index.php I guess something is wrong with my XAMPP installation. Can I have expert help on above issue to fix it?

8 5 2
3,230 points

Please log in or register to answer this question.

2 Answers

1 vote

Solution :

First of all you need to check if you have correct  password at your command line login to the mysql you can easily do it using the below command:

mysql -u phpmyadmin -p

After that you need to try the blank password I had found and I got access denied then I entered the command again using my password which I set during installation. Now if your password logs in you so know what your password is. Then you need to edit /etc/phpadmin/config-db.php and you need to change $dbpass=''; to the $dbpass='Your Password'; and after that you need to save the file. Now you need to edit /etc/dbconfig-common/phpmyadmin.conf the you need to change the dbc_dbpass=''; to the  dbc_dbpass='Your Password'; and then save your file. Finally you need to close your browser and then try to reload it then you will now find the old  message has gone way.

 

8 4 1
5,680 points
0 votes

The main reason for this error that the database password has not been set correctly. To solve this error first determine that MySQL server is running the check have you change the password recently. If yes then the reason for the error is the PHPMyAdmin console. To solve this error edit your config. Php file and set the password properly.

Linux based system:

For Linux based system this file is located as;

/etc/phpMyAdmin/config-db.php

OR

/etc/phpmyadmin/config-db.php

You can notice the difference between the above two directory paths. For Linux based the system the directory name are case sensitive while under windows operating system the directory names are not case sensitive. For windows operating system first you have to specify which server you are using WAMP or XAMPP. Mostly the configuration files are located under the phpMyAdmin but for XAMPP server the config file is located under the phpMyAdmin directory as;

/path/to/xampp/phpMyAdmin/config.inc.php.

Set the password:

So the password is set as;

$dbuser =’root’;

$dbpass = ‘password’;

$basepath=’’;

$dbname= ‘phpmyadmin’;

$dbserver =’’;

$dbport=’’;

$dbtype= ‘mysql’;

Check right password:

To check the right password for mysql at the command line login to mysql by using the following command

mysql –u phpmyadmin -p

 

11 5 2
3,890 points

Related questions

0 votes
1 answer 2 views
2 views
Problem: When I try to access index.php, it seems like something is wrong with the XAMPP installation. What can I do to fix this problem?
asked 3 days ago muktaa 10.8k points
0 votes
1 answer 12 views
12 views
Problem: I have just installed XAMPP on my Windows XP machine, and I get an error saying connection for control user as defined in your configuration failed. When I try to access index.php, it seems like something is wrong with the XAMPP installation. What can I do to fix this problem?
asked Feb 25 Umar Ahmad 4.1k points
0 votes
1 answer 58 views
58 views
Problem : Any help on this issue: Mysqli_real_connect(): (hy000/1045): access denied for user 'pma'@'localhost' (using password: no) .
asked Mar 6 Wafa Abu Yousef 6.1k points
0 votes
2 answers 4.8K views
4.8K views
Problem : I keep getting a below error with mysql connection through a XAMPP and I really don't know what to do: “Mysqli_real_connect(): (hy000/1045): access denied for user 'pma'@'localhost' (using password: no)” I have already reset my password from a MySql from a ... a changes to my code and to my php.ini file, but at each time it goes back to a error. Any help on this issue?
asked Jan 31, 2020 jwilliam 3.9k points
0 votes
0 answers 49 views
49 views
Problem: mysql said: documentation cannot connect: invalid settings.
asked Feb 18 Ethan ross 2.7k points
0 votes
1 answer 16 views
16 views
Problem Access to the requested object is only available from the local network.
asked Feb 9 charles mathews 5.5k points
0 votes
1 answer 113 views
113 views
Problem : I am trying to import mySql database which was originally an access database into phpmyadmin and its giving me following error: incorrect table definition; there can be only one auto column and it must be defined as a key
asked Nov 14, 2019 peterlaw 6.9k points
0 votes
1 answer 597 views
597 views
Problem : Currently I am facing many problems because of below message I have tried everything that I could, but below message is not going away: “The secret passphrase in configuration (blowfish_secret) is too short.” I am working on Windows, I have already restarted ... to clear the browser history and cookies in my browser but still I am facing the error. How can I fix the error?
asked Feb 24, 2020 mphil 2.3k points
0 votes
0 answers 11 views
11 views
Problem: the configuration file now needs a secret passphrase (blowfish_secret).
asked Feb 12 Dan phillip 4.8k points
0 votes
1 answer 18 views