can't get into phpMyAdmin [SOLVED]

Problems with the Windows version of XAMPP, questions, comments, and anything related.

can't get into phpMyAdmin [SOLVED]

Postby attaboy » 29. March 2012 06:13

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.
attaboy
 
Posts: 11
Joined: 27. March 2012 17:59
Location: Boulder Creek, CA
Operating System: windows XP pro, Unbuntu

Re: can't get into phpMyAdmin

Postby ThePLERKS » 29. March 2012 07:44

Hello I'm ThePLERKS :D. 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 :D
ThePLERKS
 
Posts: 1
Joined: 29. March 2012 07:21
Operating System: Windows Xp SP2

Re: can't get into phpMyAdmin

Postby attaboy » 29. March 2012 19:22

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?
attaboy
 
Posts: 11
Joined: 27. March 2012 17:59
Location: Boulder Creek, CA
Operating System: windows XP pro, Unbuntu

Re: can't get into phpMyAdmin[SOLVED]

Postby attaboy » 29. March 2012 21:23

The warning message about the ports looks like a separate issue so I'll mark this as solved and create a new post.
attaboy
 
Posts: 11
Joined: 27. March 2012 17:59
Location: Boulder Creek, CA
Operating System: windows XP pro, Unbuntu


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 64 guests