Win a copy of Transfer Learning for Natural Language Processing (MEAP) this week in the Artificial Intelligence and Machine Learning forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Paul Clapham
  • Devaka Cooray
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Knute Snortum
  • Liutauras Vilda
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Piet Souris
Bartenders:
  • salvin francis
  • Carey Brown
  • Frits Walraven

Access Denied for ''@' localhost

 
Ranch Hand
Posts: 391
1
MySQL Database PHP Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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


 
Ranch Hand
Posts: 143
Android Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
what is the mysql username?
It seems like '' not 'root'
 
It was the best of times. It was the worst of times. It was a tiny ad.
Two software engineers solve most of the world's problems in one K&R sized book
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic