Solved

phpMyAdmin, login after changed root pwd

Posted on 2008-11-03
3
632 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone 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

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

821 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