Solved

PHP MyAdmin Issues

Posted on 2011-09-16
4
469 Views
Last Modified: 2012-05-12
I just installed WAMP. Once logged in it said I needed to change the password. I went into the privileges tab & changed the password. I closed the browser & now when I open PHP myadmin I get the following screen HELP!!! How can I change theh password in a conf file ro something? What do I need to do?
eeeerrrrr.JPG
0
Comment
Question by:wantabe2
  • 2
4 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
you need first to check the config file config.inc.php file inside the phpmyadmin folder?


otherwise, please check this FAQ: http://www.phpmyadmin.net/documentation/#faqconfig
2.6 I get an "Access denied for user: 'root@localhost' (Using password: YES)"-error when trying to access a MySQL-Server on a host which is port-forwarded for my localhost.

When you are using a port on your localhost, which you redirect via port-forwarding to another host, MySQL is not resolving the localhost as expected.
Erik Wasser explains: The solution is: if your host is "localhost" MySQL (the command line tool mysql as well) always tries to use the socket connection for speeding up things. And that doesn't work in this configuration with port forwarding.
If you enter "127.0.0.1" as hostname, everything is right and MySQL uses the TCP connection.

Open in new window



0
 
LVL 15

Author Comment

by:wantabe2
Comment Utility
I'm looking at it now....what am I looking for? The only thing I see regarding the password is thispart of the code fromt eh file"

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
Comment Utility
that's it. possibly, the mysql itself has a non-empty password (hopefully), so you would need to put that password in there ...
0
 
LVL 30

Assisted Solution

by:Marco Gasi
Marco Gasi earned 250 total points
Comment Utility
Look at this: http://www.experts-exchange.com/Database/MySQL/Q_27307711.html?cid=1576

Maybe you have to reset MySql password: If this is the case, download this file and foolow instructions: I had the same problem and so I solved it - http://www.delphicoding.com/ResetMysql.zip

Cheers
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

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 …
This article discusses four methods for overlaying images in a container on a web page
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

771 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

10 Experts available now in Live!

Get 1:1 Help Now