Mysql Error 1045 Odbc
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have
Access Denied For User 'odbc'@'localhost' Mysql
Meta Discuss the workings and policies of this site About Us Learn error 1045 28000 access denied for user odbc localhost using password yes more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us
Access Denied For User 'odbc'@'localhost' (using Password No) In Php
Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like access denied for user 'odbc'@'localhost' (using password no) when trying to connect you, helping each other. Join them; it only takes a minute: Sign up Access denied for user 'ODBC'@'localhost'
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Microsoft SQL Server :: ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) New Topic Advanced Search Re:
Mysqldump Got Error 1045 Access Denied For User Odbc Localhost
ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) Posted by: mysql access denied for user 'root'@'localhost' (using password no) amit sinha () Date: August 16, 2008 07:55PM error 1045 : access denied for user 'ODBC'@'localhost'(using password:no) see, this
Mysql Root Access Denied
is not a problem either of the server or connection. Hence you guys don't need to run after terms 'ODBC'@ 'localhost'. This message was a generic error that windows returns, when http://stackoverflow.com/questions/12083655/access-denied-for-user-odbclocalhost-using-password-yes u dont specify the correct things in the command. Just enter at your command line (make sure that you are in the bin folder of MySQL server 5.0) Open the MySQL command line client using -u root to specify the root user and -p to be prompted for a password mysql -u root -p this will prompt you for password : password : http://forums.mysql.com/read.php?60,200408,222836 ******** and you will get the mysql prompt: mysql> Isn't easy? amit sinha,india Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) tage jørgensen 03/12/2008 02:50AM Re: ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) Jason Lillywhite 03/25/2008 09:01AM Re: ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) sujil kola 01/22/2009 03:13AM Re: ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) amit sinha 08/16/2008 07:55PM Re: ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) lucky bee 09/28/2008 12:03PM Sorry, you can't reply to this topic. It has been closed. powered by phorum Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party. Contact Sales USA: +1-866-221-0634 Canada: +1-866-221-0634 Germany: +49 89 143 01280 France: +33 1 57 60 83 57 Italy: +39 02 249 59 120 UK: +44 207 553 8447 Japan: 0120-065556 China: 10800-811-0823 India: 0008001005870 More Countries» Contact Us Onli
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About http://dba.stackexchange.com/questions/123934/mysql-cant-login-and-or-reset-password Us Learn more about Stack Overflow the company Business Learn more about hiring developers https://bytes.com/topic/mysql/answers/453030-access-denied-user-odbc-localhost-using-password-no or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how access denied it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top MySQL can't login and/or reset password up vote 1 down vote favorite There are many similar questions, but none of them have helped me. I had been using MySQL on Windows with root/root credentials for a while, but since lately, I'm not able to login > mysql access denied for ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) > mysql -uroot ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) > mysql -uroot -p Enter password: **** ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) > mysql -uroot -proot mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) I've tried to reset root password: (in admin console) > cat C:\mysql-init ALTER USER 'root'@'localhost' IDENTIFIED BY 'root'; > mysqld --init-file=C:\mysql-init --console but there is an error line: 2015-12-17T10:34:14.616701Z 1 [ERROR] 1131 You are using MySQL as an anonymous user and anonymous users are not allowed to change passwords mysql logins share|improve this question edited Dec 17 '15 at 11:57 asked Dec 17 '15 at 10:40 pacholik 1268 add a comment| 4 Answers 4 active oldest votes up vote 2 down vote accepted Ok, I started mysqld with --skip-grant-tables option. After that, I was able to connect using mysql client and reset my password with mysql> FLUSH PRIVILEGES; mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass'; share|improve this answer answered Dec 18 '15 at 7:53 pacholik 1268 add a
Ask a Question Need help? Post your question and get tips & solutions from a community of 418,595 IT Pros & Developers. It's quick & easy. Access denied for user 'ODBC'@'localhost' (using password: NO) P: n/a SKB Hi, I am absolutely new to this area. I am getting the following difficulty : Access denied for user 'ODBC'@'localhost' (using password: NO) when I try the mysql command from within the C:\Program Files\MySQL\MySQL Server 5.0\bin on the command window. Please note that the MySQL is runnging as I have tried the command NET START MySQL and it gives the following output: The requested service has already been started. More help is available by typing NET HELPMSG 2182. However when I try the command mysqladmin ping, it gives error as: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: NO)' Thereafter giving mySQL at the command prompt gives the error: ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: N O) Since I am absolutely naive to this area...I am not getting any clues as to what needs to be done...Any pointers will be a lot help!! NOTE that I have first installed the myODBC driver (mysql-connector-odbc-3.51.12-win32_setup.exe) and on top of it I have installed the MySQL mysql-5.0.18-win32_Setup.exe file and without any root passwd(that is I have toggled off the root passwd box). Regards SKB Feb 4 '06 #1 Post Reply Share this Question 2 Replies P: n/a Aggro SKB wrote: Hi, I am absolutely new to this area. I am getting the following difficulty : Access denied for user 'ODBC'@'localhost' (using password: NO) Here are some things to test and try: http://dev.mysql.com/doc/refman/5.0/...on-errors.html Feb 4 '06 #2 P: n/a Bill Karwin "SKB"