Solutions For Error 1045 Access Denied For User Odbc

 

Over the past few days, some users have encountered error 1045 Access Denied for user odbc. Several factors can cause this problem. Now we will deal with them.

Approved: Fortect

1. Download Fortect and install it on your computer

2. Launch the program and click "Scan"

3. Click "Repair" to fix any issues that are found

Speed up your computer's performance now with this simple download.

 

 

when I try to open mysql in windows cmd by typing it directly into mysql. the following error occurs.

  ERROR 1045 (28000): Access denied for ODBC user @ localhost (with password: then no) 

and doing similar research I found a workaround using C:> mysql -u root -p and then entering the password, mysql does its job. But when I close and become receptive, the same problem comes up again.

One last thing: I have created a user with administrator rights. but when I try to open mysql using C:> mysql --user = admin --password = root command the following error occurs:

  C:  Users  abhay kumar> mysql --user = admin --password = rootERROR 1045 (28000): access denied to user admin @ localhost (with password: NO) 

requested May 30, 2014 found at 9:00 AM

581 11 Your unwanted watch badge 44 silver badges 33 light brown badges

Not The Answer You Are Looking For? Browse Other Questions Tagged Mysql Or Ask Your Own Question.

For some reason, the ODBC user might be the default Windows username, even if you didn’t create that user during installation. just type

  mysql 

without specifying a username, probably trying to log in with a non-existent ODBC username and typing:

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

  mysql -u root -p 

where -u root is the username root and -p help to create a password prompt.

15.2k 99 badges from your old watch 5050 silver badges 107 107 brown badges

answered March 18, 2015 1:42

1221 11 gold badges 88 silver badges 44 light brown badges

You must create any type of “ODBC” user for MySql without anyone. Do it in PHPMyAdmin. This will definitely solve your problem.

But remember, this is just your new local development environment, no problem. Create is usually a serious vulnerability in your development environment.

Career end May 29, 2015 6:47 am

2337 22 unusual metal badges 2323 silver badges 3030 badges

  C:  cd MySQL installation path  MySQL -yourusername -pyourpassword 

4,362 44 rare badges 3,434 silver badges 4545 brown badges

answered Jun 6 15 at 13:58

  C:  Users  abhay kumar> mysql --user = admin --password = root .. 

This command only works for root users

  c:  users  lelaprasad> mysql --password = rootWelcome to MySQL Monitor. Complete orders with; or  g.Your MySQL Connection ID is 4Server version 5: 5.47 MySQL Community (GPL)Copyright Server (c) 2000, 2015, Oracle and / or its subsidiaries. All rights   protected.Indeed, Oracle is a registered trademark of Oracle and / or its consortium.Member organizations. Other names may be trademarks corresponding toOwn them.Enter "help; "Or for ' h', please support. Enter ' c' to remove the current insert statement. 

119k 4040 gold badges 291291 silver badges 377377 brown badges

answered Apr 12 ’16 at 11:39

I know this question was asked three years ago, but I just solved this problem myself. I used outfile and got an error. When I commented on this part of the request, it was accepted.

The FILE right is different from all others and must be granted to the user running the script.

  ALLOW FILE ON *. * TO 'asdfsdf' @ 'localhost'; 

answered Jun 23, 2017 at 20:18

If you are probably using dj-database-url, check the schema in someone else’s DATABASES

  'default': dj_database_url.config (default = 'mysql: // USER: PASSWORD @ localhost: PORT / NAME') 

  mysql -u user -p 

 

 

Speed up your computer's performance now with this simple download.