aspose file tools*
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

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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: 172

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.

Mahtab Alam (OCJP )
Blogs : ,
Kumar Barun

Joined: Oct 14, 2011
Posts: 13
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: 131

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:
subject: Access Denied for ''@' localhost
Similar Threads
Which database should I use in java swing?
MySQL Error
Help- unable to connect to MySQL Connector/J
PreparedStatement to pass user input to MySQL not working
Access denied Error in the Ant