MySQL Says: Cannot connect: invalid settings

Question

We are using XAMPP in a shared environment in our local network. All the projects had the default mysql username and password. Recently I tried to change the user name and password of a project. And now I am not being able to access phpmyadmin. It just displays the following message:

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Now no one is able to access the phpmyadmin. How can I solve this?

did you edit MySQL default setting in php.ini ? – mohammad falahat Nov 09 '14 at 06:28 — mohammad falahat, Nov 09 '14 at 06:28

score 19 · Answer 1 · edited Oct 13 '16 at 04:33

19

Error:-Connection for controluser as defined in your configuration failed.

solution:- because of in your ubuntu system two mysql server running so get confusion solve this problem stop mysql servert first

open terminal
type command:
```
sudo /etc/init.d/mysql stop
```
type command:
```
sudo  /opt/lampp/lampp restart
```
open localhost in browser

edited Oct 13 '16 at 04:33

davejal

6,009
10
39
82

answered Oct 11 '16 at 09:31

Rahul chak

191
1
3

1

now your mysql server is stop if you want work with mysql that time stop xamp server and mysql restar – Rahul chak Oct 11 '16 at 09:37

score 8 · Answer 2 · edited May 23 '17 at 11:54

8

you can just solve this by editing the config.inc.php file from the phpmyadmin folder..

This will work fine if you edit the update password with the same username..

Find the line $cfg['Servers'][$i]['password'] =";

Just replace it with

$cfg['Servers'][$i]['password'] = ' ';

Please have a look here for more details

edited May 23 '17 at 11:54

Community

1
1

answered Nov 09 '14 at 06:25

Avinash Babu

6,171
3
21
26

Avinash thanks for the reply. It worked. But the problem I am facing now is a bit weird. The phpmyadmin now shows only a few databases. Not all them. Actually most databases are not shown. Could you suggest something? – radiopassive Nov 09 '14 at 06:41
2

@freerunner You should post your additional question as a new question so that it gets the attention it deserves. Additionally, if you found Avinash Babu's answer to this question helpful, you might wish to mark it as accepted so others can see what worked for you. – Isaac Bennetch Dec 30 '14 at 02:55

score 7 · Answer 3 · edited Apr 14 '16 at 09:56

7

Just add $cfg['Servers'][$i]['host']="127.0.0.1:3307"; if you change port.

edited Apr 14 '16 at 09:56

Tomasz

4,847
2
32
41

answered Apr 14 '16 at 09:16

Yagnesh Panchal

501
5
4

score 1 · Answer 4 · answered Nov 09 '14 at 06:31

1

There is a bat file 'resetroot.bat' located in the xammp MySQL folder ie: 'C:\xampp\mysql'

Run the bat file and it will reset the phpadmin passwords. Then start the MySQL service in xammp and try accessing phpmyadmin.

Hope it helps.

answered Nov 09 '14 at 06:31

Jitesh Golecha

11
1

score 1 · Answer 5 · answered Apr 19 '17 at 22:05

1

In my case it was just because I had forgotten to turn on the 'MySQL' service on the XAMPP control panel. *facepalm*

answered Apr 19 '17 at 22:05

Morgan Saville

61
6

score 1 · Answer 6 · edited Jan 04 '18 at 06:53

I am also getting the same error, and finally found the answer with help of first reply of above post. But that is wrong because this error prone due to changed password so all of need to do this to get resolve it. previous it look like:

" $cfg['Servers'][$i]['password']='';"

after I changed like:

" $cfg['Servers'][$i]['password']='root'; "

The actual reason behind this while installing the XAMMP there is no password but after the that I added password for security. But it did't get updated in config.inc.php so we need to update manually by following above steps.

score 0 · Answer 7 · answered Nov 10 '15 at 10:32

For my case it seems the mysql server crashed, while it was it running state without any special thing happened. My web app was connected to the db server and was ideal for long time. I was trying to open the phpmyadmin and it started to give issues(same errors mentioned in the question) while connecting to db. After 5 mins I found my db crashed and not at all starting even after trying lot of things.

score 0 · Answer 8 · answered Nov 15 '15 at 08:57

0

uninstall the xampp and reinstall it in differnt folder. but before uninstalling it please save the documents of 'htdocs' to the other location and after installing put ur data back to new "htdocs" folder

answered Nov 15 '15 at 08:57

gaurav choubey

1

score 0 · Answer 9 · edited Jun 14 '16 at 12:58

0

Remove all lines with $cfg['Servers'] , and keep ONLY the $cfg['Servers'][$i]['host']

edited Jun 14 '16 at 12:58

Nana Partykar

10,556
10
48
77

answered Dec 16 '15 at 13:29

Joseph

1,716
3
24
42

score 0 · Answer 10 · answered Jul 21 '17 at 14:11

0

Try accessing the phpmyadmin through the "127.0.0.1:8080"

answered Jul 21 '17 at 14:11

Ashraf Hefny

508
1
6
20

score 0 · Answer 11 · answered Apr 21 '19 at 16:29

First start the Apache server.

Then click config and open phpMyAdmin(config.inc.php)

Initially you would be having this statement in your config.inc.php

      ```$cfg['Servers'][$i]['host'] = '12.0.0.0';```

Change the IP address to 'localhost:' i.e., $cfg['Servers'][$i]['host'] = 'localhost:';

I did this and the problem solved for me. Hope it helps :)

score 0 · Answer 12 · answered Mar 29 '20 at 09:09

Step1: Go to xampp/phpMyAdmin/config.inc.php
Step2: Search this: $cfg['Servers'][$i]['host'] = '127.0.0.1';
Step3: Replace with $cfg['Servers'][$i]['host'] = '127.0.0.1:3307';

Here 3307 will be change  with your mysql port number, in my case it is 3307. Most of the times it will be 3306.

You can check your mysql port number from here : xampp/mysql/bin/my.ini

score 0 · Answer 13 · edited May 02 '20 at 06:06

0

find this line-:

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

replace it to this -:

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

it works for me.in my case I am using port 3306

edited May 02 '20 at 06:06

David Buck

3,752
35
31
35

answered May 02 '20 at 05:46

udaya perera

1
2

score 0 · Answer 14 · edited Sep 14 '21 at 10:00

0

For my case, I tried to modify Then click config and open with $cfg['Servers'][$i]['host']="127.0.0.1"; then it works.

edited Sep 14 '21 at 10:00

Alex Shesterov

26,085
12
82
103

answered Sep 14 '21 at 01:15

benchmarkgt

1

MySQL Says: Cannot connect: invalid settings

14 Answers14

Linked