Apache Friends Support Forum

Error

MySQL said: Documentation
Cannot connect: invalid settings.
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.

I looked in the phpmyadmin folder but didn't this configuration file.

Hello I'm ThePLERKS . Newbie. In Regards to your problem. I hope this works for you too. What I Did....

Step 1: Stop Apache, MySql, FileZilla, TomCat and Others.
Step 2: Exit Xammp Control Panel.
Step 3: Go to C:\xampp\phpMyAdmin Folder.
Step 4: Open config.inc.php in Wordpad or NotePad. ( make sure to backup config.inc.php )
Step 5: Add / Update text lines from config.inc.php

Code: Select all

         /* Authentication type and info */
        $cfg['Servers'][$i]['auth_type'] = 'config';
        $cfg['Servers'][$i]['user'] = 'root';
        $cfg['Servers'][$i]['password'] = '';
        $cfg['Servers'][$i]['extension'] = 'mysql';
        $cfg['Servers'][$i]['AllowNoPassword'] = true;

into this:

Code: Select all

        /* Authentication type and info */
       $cfg['Servers'][$i]['host'] = 'localhost';
       $cfg['Servers'][$i]['auth_type'] = 'cookie';
       $cfg['Servers'][$i]['connect_type'] = 'tcp';
       $cfg['Servers'][$i]['compress'] = false;
       $cfg['Servers'][$i]['user'] = 'root';
       $cfg['Servers'][$i]['password'] = 'your_password';
       $cfg['Servers'][$i]['extension'] = 'mysql';
       $cfg['Servers'][$i]['AllowNoPassword'] = false;


Step 6: Save and Close config.inc.php file
Step 7: Run the Xammp Control Panel. Start the Apache, MySql, FileZilla, TomCat and Others.
Step 8: Open Web Browser and type http://localhost/phpmyadmin/ and press Enter
the phpadmin should work now. God Bless.

thePLERKS

Oddly enough when I booted up this morning it worked. I made the changes you suggested and now I have to log in which is good. I noticed yesterday and again today I have these messages in cp3
11:03:18 AM [apache] Possible problem detected: Port 80 in use by "httpd.exe"!
11:03:18 AM [apache] Possible problem detected: Port 443 in use by "httpd.exe"!
So what's httpd and what's it doing to my ports?

The warning message about the ports looks like a separate issue so I'll mark this as solved and create a new post.