File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Languages » PHP
Bookmark "Access Denied for Watch "Access Denied for New topic
Author

Access Denied for ''@' localhost

Mahtab Alam
Ranch Hand

Joined: Mar 28, 2012
Posts: 249

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
Kumar Barun
Greenhorn

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: 132

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