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

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.

http://www.mahtabalam.net , 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: 133

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