Home/ Questions/Error 1045 (28000): access denied for user 'odbc'@'localhost' (using password: no) - how can I circumvent the error?
Next
Answered
Jade Taylor
  • 21
Asked: 2022-05-18T21:44:09+00:00 In:

Error 1045 (28000): access denied for user ‘odbc’@’localhost’ (using password: no) – how can I circumvent the error?

  • 21

. Advertisement .

..3..

. Advertisement .

..4..

Hi everyone, I’m learning about sql. While working, I try to open MySQL in Windows cmd by typing mysql. As a result, I get the message:

ERROR 1045 (28000): Access denied for user ODBC@localhost (using password: NO)
C:\Users\abhay kumar>mysql --user=admin --password=root
 ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password:NO)

What can I do about the “error 1045 (28000): access denied for user ‘odbc’@’localhost’ (using password: no)” issue? Is there a better approach?

error 1045 (28000)
Share

2 Answers

  1. Best Answer
    Expert

    The cause:

    You are having a trouble with the error ”access denied for user ‘odbc’@’localhost’ (using password: no)” because you do not determine an username and give it correct password, so it will try to connect with the ODBC username that does not exist.

    Solution:

    You have to creat a definite username which you believe or in PHPMyAdmin you can create an ODBC user for MySQL without using a password.

    However, there is no problem in the case it’s only your local development environment. If it’s in your working environment, it will leave a significant security gap.

    • 0

  2. For some reason, even though you did not create it at setup, the default username for Windows is the ODBC user. Simply type 

    mysql

    Without specifying a username, the username will be used to attempt to connect with an ODBC username that is not present.

    Error 1045 (28000): Access denied for user ‘ODBC’@’localhost’ (using password: NO)

    Try instead to specify a username you already know. 

    mysql -u root -p

    -u root was the username root, -p will prompt you for a password.

    • 20

Leave an answer

You must login to add an answer.

Need An Account,