This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes PHP and the fly likes Unable to login as root in Php My admin Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Languages » PHP
Bookmark "Unable to login as root in Php My admin" Watch "Unable to login as root in Php My admin" New topic
Author

Unable to login as root in Php My admin

Swela Jathar
Greenhorn

Joined: Aug 19, 2011
Posts: 22
Hi,
i have installed wamp server 2.2 package.After insatllation i am not able to login as user root .iam able to login as pma(ie php my admin) but this user has no privileges to create database.And I have not given password to user root still it gives error
]
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Please help me..
Thanks in advance.............
K. Tsang
Bartender

Joined: Sep 13, 2007
Posts: 2247
    
    7

It seems there is NO default for user root because of "using password: NO". If it needs one then it should "using password: YES". Once inside php myadmin you can change it.

Swela Jathar wrote:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)


K. Tsang JavaRanch SCJP5 SCJD/OCM-JD OCPJP7 OCPWCD5
abani patra
Ranch Hand

Joined: Oct 11, 2011
Posts: 70
Hi,
Go the installation directory from there to phpmyadmin dir then edit config.inc.php for your username and password
.
 
Don't get me started about those stupid light bulbs.
 
subject: Unable to login as root in Php My admin
 
Similar Threads
Unable to open the service Tomcat5
connecting JSP(resin) to MYSQL with out root
Login ID and Password for WebSphere admin console
LDAP - Allowing user to change his own attributes
authentication failed weblogic 7 SP2