Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Unable to access phpMyAdmin

Posted on 2011-02-15
7
Medium Priority
?
572 Views
Last Modified: 2012-05-11
Hi:
When I try to access phpMyAdmin I get the following error:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

This is my config.inc.php file :                            

 * cookie
 */
$cfg['blowfish_secret'] = 'a8b7dafdferHJHJ^&U^45776TIUuiYc6d'; /* YOU MUST FI$
COOKIE AUTH! */

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

/*
 * First server
 */
$i++;
/* Authentication type */    
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* 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'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';

^G Get Help  ^O WriteOut  ^R Read File ^Y Prev Page ^K Cut Text  ^C Cur Pos
^X Exit      ^J Justify   ^W Where Is  ^V Next Page ^U UnCut Text^T To Spell

Thanks.
0
Comment
Question by:pcelements
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 34

Expert Comment

by:Beverley Portlock
ID: 34901045
If this is a new set up then it may be that root has no password set. Try logging into phpMyAdmin as root with no password. If that fails then try logging in as root with the existing root password.

0
 
LVL 11

Expert Comment

by:Ovid Burke
ID: 34901218
If your setup is on Windows with IIS and PHP 5.3 it will not accept 'localhost' ast the host. You should change this value to 127.0.0.1

So...
$cfg['Servers'][$i]['host'] = 'localhost';

Open in new window

... becomes...
$cfg['Servers'][$i]['host'] = '127.0.0.1';

Open in new window

0
 
LVL 2

Expert Comment

by:asadhaider
ID: 34901839
Is this a shared or your own server you are trying to use phpMyAdmin on? Only the server administrator should have access to the MySQL root account.

If you have just installed MySQL then the password will be blank, simply use root for the username and no password. If you still cannot login then you can reset your root password using the instructions below, I have used them many times myself. Simply run the commands on the server, replace "new-password" with a blank or password of your choice.
http://www.howtoforge.com/reset-forgotten-mysql-root-password

Once you restart MySQL then it should let you login with the password you have specified.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:pcelements
ID: 34902939
This is my server and it is running Centos 5.5. The account root has a password. It is a new setup. Thanks!!
0
 
LVL 2

Expert Comment

by:asadhaider
ID: 34903010
The MySQL root password is different to your centos root user password, if it is a new mysql setup then the default mysql root user password will be blank.

If it still does not work then try the fix I posted as a link.
0
 

Accepted Solution

by:
pcelements earned 0 total points
ID: 35719810
I was not able to get this to work so I ended up formatting the server and installing cPanel. Thanks everybody!
0
 

Author Closing Comment

by:pcelements
ID: 35759389
Unable to find solution.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question