how to overcome ERROR 1045 28000 Access denied for user ODBC localhost using password NO permanently

Question

when am trying to open mysql in windows cmd by typing mysql  the following error is occuring   ERROR 1045  28000   Access denied for user ODBC localhost  using password  NO    And then by looking similar queries i somehow got a temporary solution by using  C  gt  mysql -u root -p and then typing the password  mysql is working  But when i close and open  the same problem is recurring   One more thing is that i have created a user  admin   but when am trying to open mysql using the command C  gt  mysql --user admin --password root  the following error is occuring   C  Users abhay kumar gt mysql --user admin --password root ERROR 1045  28000   Access denied for user  admin   localhost   using password NO    Any help will great

User · Answer

Why you can t just use mysqlsh   PS C  Users artur Desktop gt  mysqlsh --user root MySQL Shell 8 0 17  Copyright  c  2016  2019  Oracle and or its affiliates  All rights reserved  Oracle is a registered trademark of Oracle Corporation and or its affiliates  Other names may be trademarks of their respective owners   Type   help  or      for help    quit  to exit  Creating a session to  root localhost  Fetching schema names for autocompletion    Press  C to stop  Your MySQL connection id is 13  X protocol  Server version  8 0 17 MySQL Community Server - GPL No default schema selected  type  use  lt schema gt  to set one   MySQL  localhost 33060  ssl  JS  gt

User · Answer

I encountered this problem today  I tried mysql -u root -p  but it doesn t work  I restarted the mysql service by two commands  net stop mysql and net start mysql then tried the command mysql  It worked

User · Answer

i entered in Mysql Workbench and i changed the password  It seem the password was expired  it works

User · Answer

Try using following command it work   mysql --user root --password root password

User · Answer

I know it s been three years since this was asked  but I just figured out this problem for myself  I was using into outfile and getting the error  When I commented out this part of the query  it worked    The FILE privilege is separate from all the others and must be granted to the user running the script   GRANT FILE ON     TO  asdfsdf   localhost

User · Answer

Just create a file my ini file in installation dir and have the below config as part of this file to solve this permanently    mysql  user root password root

User · Answer

open command line  run as admin  go into Mysql server bin folder run command  mysqldump -u root -p mydbscheme   mydbscheme dump sql give your password here against root    It will work perfect

User · Answer

It seems like You haven t set the Mysql server path  Set Environment Variable For MySql Server  Then restart the command prompt and enter mysql -u root-p then it asks for a password enter it  Thank you  Happy learning

User · Answer

You need to create an user  ODBC  for MySql with no password  Do that in PHPMyAdmin  That will solve your problem   But remember  if it s only your local development environment  no problem  It ll create a serious security hole in your production environment

User · Answer

I tried this and it worked     C  cd MySQL installed path MySQL -uyourusername -pyourpassword

User · Answer

You can create user with no password in phpmyadmin and it solves the problem  Lebbar Abdelhadi

User · Answer

C  Users abhay kumar gt mysql --user admin --password root     This command is working for root user  you can access mysql tool from any where using command prompt    C  Users lelaprasad gt mysql --user root --password root Welcome to the MySQL monitor   Commands end with   or  g  Your MySQL connection id is 4 Server version  5 5 47 MySQL Community Server  GPL   Copyright  c  2000  2015  Oracle and or its affiliates  All rights reserved   Oracle is a registered trademark of Oracle Corporation and or its affiliates  Other names may be trademarks of their respective owners   Type  help   or   h  for help  Type   c  to clear the current input statement

User · Answer

for some reason  the ODBC user is the default username under windows even if you didn t create that user at setup time  simply typing  mysql   without specifying a username will attempt to connect with the non-existent ODBC username  and give      Error 1045  28000   Access denied for user  ODBC   localhost   using password  NO    Instead  try specifying a username that you know  for example   mysql -u root -p   where -u root specified the username root and -p will make the command prompt for a password

User · Answer

If you are using dj-database-url check the schema in your DATABASES  https   github com kennethreitz dj-database-url  MySQL is   default   dj database url config default  mysql   USER PASSWORD localhost PORT NAME      It solves the same error even without the PORT  You set the password with   mysql -u user -p

[mysql] how to overcome ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) permanently

Examples related to mysql