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 OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP 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: 338

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..
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Access Denied for ''@' localhost