?
Solved

phpMyAdmin, login after changed root pwd

Posted on 2008-11-03
3
Medium Priority
?
635 Views
Last Modified: 2011-09-20
Hello,

I have a new phpMyAdmin installation on y Synology NAS-Server. On the main page it indicated that the root password should be set to avoid unauthorized access.

Therefor I want to set a password so that a user is asked the password when trying to access the phpMyAdmin or the DB:

- I set a password for the root@localhost account.
- Accidentally I removed the root@127.0.0.1 account.

In the conifg.inc.php I put the following information:

/* Authentication type */
$cfg[Servers][$i][host] = localhost;
$cfg[Servers][$i][auth_type] = config;
$cfg[Servers][$i][user] = root;
$cfg[Servers][$i][password] = new_root_pwd;

When I try to load the phpMyAdmin in the browser of my PC, the following message is displayed:
- #1045 - Access denied for user 'root'@'localhost' (using password: NO)

Does anyone have an Idea how to solve this?

Regards Chris
0
Comment
Question by:skiaholic
[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
3 Comments
 
LVL 4

Expert Comment

by:apcsolutionsuk
ID: 22865869
It says that your not using a password  you can try downloading a new version like xampp and just copying over the config files
0
 
LVL 26

Accepted Solution

by:
Umesh earned 750 total points
ID: 22865943

>> I set a password for the root@localhost account.
>>- Accidentally I removed the root@127.0.0.1 account.

Is there any user left in MySQL???  try to connect using that user and see if you can connect.. If you don't know the root password (any user who have grant privileges) then you want to reset root password and change values in phpmyadmin config file..

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html

Also after chaging root password did you run "FLUSH PRIVILEGES" statement????
0
 
LVL 7

Expert Comment

by:efg-uae
ID: 22866467
Problem is very simple
Actually you have deleted the User 'root' in mysql.
Please create a user root@127.0.0.1 and give it full access to mysql Server.
then update the root password in config file of phpMyAdmin.
it will solve your problem.
Cheers
ASIF
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

765 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