Solved

phpMyAdmin, login after changed root pwd

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

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

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

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

707 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