MySQL Access Denied for user ''@'localhost'

Question

I am having trouble creating a database on my local server using MySQL.

Approach:

Start mysqld as administrator
Start MySQL as administrator

mysql> create database db_name;

MySQL throws an error indicating, "Access Denied for user ''@'localhost to database 'db_name'.

What do I need to specify to MySQL to create a database?

Type show grants for 'administrator'@'localhost'; What do you see? — Tim Biegeleisen
– Tim Biegeleisen, Commented Jun 10, 2015 at 2:41

Vhortex · Accepted Answer · 2015-06-10 02:39:43Z

2

You need to provide a valid user/password combination to gain access to MYSQL. You also need that the user you are using have the privileged to create a database.

On default, new users have zero access to the database management including creation.

answered Jun 10, 2015 at 2:39

Vhortex

3811 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user4640007 Over a year ago

I recall being able to login just fine. I guess I forgot how to login

Vhortex Over a year ago

Usually the problem is with the user access. This might help but it is worth a shot, you can strictly forced a username to be able to access with only a specific hostname/ip address. NOTE: @Tim Biegeleisen beats me to is

user4640007 Over a year ago

Alright. Thanks. Perhaps if I can just burn this into my brain (or save a text file) MySQL will only work through the command prompt.

Collectives™ on Stack Overflow

MySQL Access Denied for user ''@'localhost'

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related