MySQL Forums
Forum List  »  PHP

Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES).
Posted by: germayne poh
Date: November 27, 2006 09:58PM

I have the same problem as Ned. I tried everything I could but it still didn't work. I am running MySQL server 5.0, php-4.3.10-Win32, Apache 2.0.47-win32-x86no_ssl, phpmyadmin 2.9.1-rc2 and it's on local. Everything works until i get to phpmyadmin login in page and everytime i tried to login, it returns error #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES).

Here are my codes in config.inc.php

$cfg['Servers'][$i]['auth_type'] = 'config';
/* 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'] = 'mysql';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pmausr';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin2';
$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';

When I tried changing 'pmausr' and 'pmapass' to 'root' and my own password but it returns error #1251. I tried changing different passwords and editing the codes but it still doesn't work!! I am desperate!! What's wrong? Can anyone help this poor rookie??

Germayne

Options: ReplyQuote


Subject
Written By
Posted
October 17, 2006 11:45PM
October 18, 2006 09:46AM
November 14, 2006 01:38PM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES).
November 27, 2006 09:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.