CODEWITHSUNDEEP
mysql
Hunter Mitchell
Hunter Mitchell

Reputation: 399

Unable to connect to MySQL instance after installing

I'm setting up a MySQL database following this tutorial. I installed it and successfully initialized an instance with a root password, but I am having trouble connecting to the instance via command line. When I click on the 'mysql' executable under bin, I get this message

ERROR 1045 (28000): Access denied for user 'hunter'@'localhost' (using password: NO)

and if I try to enter

> mysql -u root -p

in the terminal I get this message

-bash: mysql: Permission denied

It says in the instructions that I should be getting prompted to enter the password for the database, but for some reason it won't let me.

Upvotes: 0

Views: 68

Answers (1)

Menelaos
Menelaos

Reputation: 25727

I would suggest first off to try a mysql workbench. You can download it at https://dev.mysql.com/downloads/workbench/ .

It seems that calling mysql from bash is causing issues for you. If you are using a *Nix environment, it could be a permissions issue and you need to set the correct permissions on the mysql binary. However, usually a correct installation should have already done that. See: https://askubuntu.com/questions/229589/how-to-make-a-file-e-g-a-sh-script-executable-so-it-can-be-run-from-a-termi

Secondly, you should use the username root . hunter is not default username.

From the mysql documentation:

How to Reset the Root Password If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. However, this is insecure. For instructions on assigning a password, see Section 2.10.4, “Securing the Initial MySQL Account”.

Reference: https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html

Upvotes: 2

Related Questions