Solved

phpMyAdmin, login after changed root pwd

Posted on 2008-11-03
3
630 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
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:
ushastry earned 250 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now