Problem with XP and PhpMyAdmin error 1045

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

Problem with XP and PhpMyAdmin error 1045

Postby nostradamus » 09. April 2010 09:27

Hi,

I am a newbie... I have tried almost everything on the web to try and fix this problem but to no avail.

When I open the XAMPP control panel both apache and mysql are running.
when I click Admin button for mysql I get Firefox window opening saying...
Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
Connection for controluser as defined in your configuration failed.
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.

below is my config.inc.php file in folder c:\xampp\phpmyadmin\ folder

Any help is always appreciated

thanks

Richard

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
<?php
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

/*
* Servers configuration
*/
$i = 0;

/*
* First server
*/
$i++;

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

/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;

/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysqli';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'blavatsky3';

/* Advanced phpMyAdmin features */
$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]['designer_coords'] = 'pma_designer_coords';

/*
* End of servers configuration
*/

/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

$cfg['AllowAnywhereRecoding'] = true;
$cfg['DefaultCharset'] = 'utf-8';
$cfg['DefaultLang'] = 'en-utf-8';
$cfg['DefaultConnectionCollation'] = 'utf8_unicode_ci';

$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman/5.1/en';
$cfg['MySQLManualType'] = 'searchable';

?>

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
nostradamus
 
Posts: 11
Joined: 09. April 2010 09:09

Re: Problem with XP and PhpMyAdmin error 1045

Postby Narrowboyy » 09. April 2010 11:11

Did you set your MySQL\phpMyAdmin password from the Security menu link in the XAMPP Demo Page at http://localhost/index.php

If not then remove any changes you made in the config.inc.php file and go to the Security link and then set your passwords.

TIP
Select Cookie or http authentication instead of config.

See if there are any helpful posts in these advanced search results.

This post from the many in the above search seems to have had a positive result even though it is a bit long winded:
viewtopic.php?f=16&t=38844
Narrowboyy
 
Posts: 64
Joined: 16. February 2009 02:56

Re: Problem with XP and PhpMyAdmin error 1045

Postby nostradamus » 09. April 2010 12:08

I deleted XAMPP folder and did a re-install

SORRY Nothing seems to be working.

Even after re-install ... it's really weird I am still getting the same error when I go to click MYSql 'Admin' button...
error 1045 in Firefox window.. Now I will try system restore point

More weirdness restore point did not work.

choosing a different restore point.....
nostradamus
 
Posts: 11
Joined: 09. April 2010 09:09

Re: Problem with XP and PhpMyAdmin error 1045

Postby nostradamus » 09. April 2010 12:27

2nd Restore Point attempt using more recent Restore Point also failed.

But now when I click "Admin" button for MySql it WORKS now.

EUREKA...

I am not sure if I ever want to touch passwords in XAMPP ???
nostradamus
 
Posts: 11
Joined: 09. April 2010 09:09

Re: Problem with XP and PhpMyAdmin error 1045

Postby nostradamus » 09. April 2010 20:21

I have added password/s

but now when I create database 'moodle' I don't see the edit action icon.

Does anyone know why this is so?
nostradamus
 
Posts: 11
Joined: 09. April 2010 09:09


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 75 guests