Skip navigation links

MySQL Forums :: PHP :: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES).


Advanced Search

Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES).
Posted by: Paul Simpson ()
Date: February 09, 2009 05:35PM

#1045 - Access denied for user: 'root'@'localhost' (Using password: NO).

Look in the phpmyadmin folder for this file: config.inc.php

Open the file with any web editor so you can view the file in HTML mode.

Look for the following lines of code below. Usually the problem is that the line of code that holds the password — has no password entered. In the forth line of code below, enter the password (between the single quotes) that you gave when you installed MySQL. The “User Name” defaults to 'root' — as shown in the error message above. If the error message has something other than: 'root'@'localhost', leave the third line of code below as is, otherwise, replace the value 'root' with what ever value is between the single quotes in the error message that comes before the @ symbol.

This will correct the error and phpMyAdmin should now connect to MySQL. However, you may also encounter another error message when phpMyAdmin loads. This is caused by one or both of the last two lines of code below containing a value; in this case, the seconded line from the bottom contained the value: 'pma'. The third line of code from the bottom is the original line of code; I commented it out by adding the two slashes at the beginning of the line — just in case I forgot what value it originally contained if it needed to be changed back later.

Save the file and close the page. phpMyAdmin should now load without any errors occurring.

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

/* User for advanced features */
// Original Line of Code: $cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';

Options: ReplyQuote


Subject Written By Posted
phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). Ned Wilsher 10/10/2006 08:46AM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). Dave Walker 10/11/2006 03:38AM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). Ned Wilsher 10/12/2006 01:40AM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). Richard Ward 10/12/2006 04:30AM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). xu wenjie 10/16/2006 10:47PM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). nguyen tin 04/06/2007 01:55AM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). edward ji 11/12/2006 03:02PM
Working now!! phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). Mario Oestert 10/13/2006 07:58AM
Try this code it openends phpMyAdmin the first time!! after hours playing !#1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). Mario Oestert 10/13/2006 08:02AM
Tried Mario Oestert's Config Kail Ceannai 10/17/2006 11:45PM
Solved my own problem Kail Ceannai 10/18/2006 09:46AM
Re: Correct you have to use your Personal userName and Password if you use it on the real webserver. Mario Oestert 10/18/2006 03:42PM
Re: I will try to solve this one Mario it is not easy many setups avalebel!! Mario Oestert 10/18/2006 03:32PM
Re: Tried Mario Oestert's Config martin jarvis 12/16/2006 09:00PM
Re: Tried Mario Oestert's Config Mario Oestert 12/18/2006 07:44AM
Error nr. 1045 - Access denied lars Andersen 11/14/2006 01:38PM
Re: Error nr. 1045 - Access denied [MySQL Administrator on Linux] Martin Wirth 12/28/2008 02:58AM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). germayne poh 11/27/2006 09:58PM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). Mario Oestert 12/15/2006 12:52AM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). Velimir Kojic 05/10/2009 04:53AM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). angel woman 01/03/2007 03:34PM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). Triel Paggen 01/29/2007 11:56PM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). Triel Paggen 01/30/2007 01:25AM
THE ULTIMATE SOLUTION !!!! BE HAPPY !!!! Afranio Junior 02/14/2007 11:43PM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). Nyle Davis 03/06/2007 11:01PM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). sim diggles 12/03/2008 07:05AM
Re: phpMyAdmin - #1045 - Access denied for user 'pmausr'@'localhost' (using password: YES). Paul Simpson 02/09/2009 05:35PM


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.