wood burning stoves
The moose likes PHP and the fly likes Access Denied for ''@' localhost Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Languages » PHP
Bookmark "Access Denied for Watch "Access Denied for New topic

Access Denied for ''@' localhost

Mahtab Alam
Ranch Hand

Joined: Mar 28, 2012
Posts: 388

When i try to create a database or any other thing mysql says Access Denied for ''@' localhost.

I have changed my root password to 'a'.
i have to use phpmyadmin
Tell me how to create database through command line.

or i have to create another user.

And what is the command to connect to mysql(like in oracle sql connect username\password )

Hope to get a working answer soon.

Oracle Java Programmer , Oracle SQL Expert , Oracle Java Web Component Developer, Oracle Web Service Developer
Kumar Barun

Joined: Oct 14, 2011
Posts: 20
If you are working with PHP, you have phpmyadmin tool with WAMP or XAMPP that you can access via url http://localhost/phpmyadmin. It allows you to work with MySQL in GUI mode.

To work from command line (on windows):

1. Ensure MySQL bin is set to your PATH environment variable.
2. Type in on the cmdline
mysql -u root -p
it will then ask for password. root is username

Supun Lakshan Dissanayake
Ranch Hand

Joined: Oct 26, 2012
Posts: 135

what is the mysql username?
It seems like '' not 'root'

Are you better than me? Then please show me my mistakes..
I agree. Here's the link: http://aspose.com/file-tools
subject: Access Denied for ''@' localhost
It's not a secret anymore!