Error 1045 Access Denied For User Odbc Localhost
Contents |
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 Us Learn more about error 1045 access denied for user root localhost Stack Overflow the company Business Learn more about hiring developers or posting ads error 1045 28000 access denied for user odbc localhost using password no with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow got error 1045 access denied for user root localhost is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up how to overcome ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password:
Mysql Error 1045 Access Denied For User Root Localhost
NO) permanently up vote 6 down vote favorite 3 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:> mysql -u root -p and then typing the password, mysql is working. But when i close and open, mysqlcheck got error 1045 access denied for user root localhost 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:> mysql --user=admin --password=root, the following error is occuring: C:\Users\abhay kumar>mysql --user=admin --password=root ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password:NO) Any help will great mysql share|improve this question edited May 30 '14 at 9:04 user3678666 asked May 30 '14 at 9:00 user3690599 31112 Your post mentions 3 different users. root, admin and ODBC. Are you sure that the ODBC and admin users exist and they are allowed access from localhost? How did you create the users? Please also note that however you're connecting you are NOT using a password (using password: NO). Is your actual question that you cannot use the command line parameter --password on windows? –h2ooooooo May 30 '14 at 9:02 add a comment| 5 Answers 5 active oldest votes up vote 18 down vote 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' (us
& Configuration Issues Javascript Disabled Detected You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality. [SOLVED] Access access denied for user 'odbc'@'localhost' (using password no) in php denied for user 'ODBC'@'localhost' (using password: NO) Started by helpmeplease2, Feb 08 2007
Access Denied For User 'odbc'@'localhost' (using Password No) When Trying To Connect
03:43 AM Please log in to reply 8 replies to this topic #1 helpmeplease2 helpmeplease2 Advanced Member Members 87 posts
Error 1045 (28000): Access Denied For User 'odbc'@'localhost' (using Password: Yes)
Posted 08 February 2007 - 03:43 AM Hi, I am new to MySQL so this is probably an easy fix for you.I am running Windows XP Professional SP2 with PHP 5.2, the http://stackoverflow.com/questions/23950722/how-to-overcome-error-1045-28000-access-denied-for-user-odbclocalhost-u newest MySQL and the newest Apache. I have started up mysqld through the command prompt but when entering in "mysql" I get the error "Access denied for user 'ODBC'@'localhost' (using password: NO)". I do not have a password so whats wrong?Do I need to do anything else before I can start creating databases? Back to top #2 fenway fenway MySQL Si-Fu / PHP Resident Alien Staff https://forums.phpfreaks.com/topic/37571-solved-access-denied-for-user-odbclocalhost-using-password-no/ Alumni 16,199 posts LocationToronto, ON Posted 08 February 2007 - 03:46 PM Are you sure there's no password? Check the grants table. Seriously... if people don't start reading this before posting, I'm going to consider not answering at all. Back to top #3 helpmeplease2 helpmeplease2 Advanced Member Members 87 posts Posted 08 February 2007 - 03:54 PM Well I never set one. I do not know how to check the grants table, nothing works. Back to top #4 fenway fenway MySQL Si-Fu / PHP Resident Alien Staff Alumni 16,199 posts LocationToronto, ON Posted 08 February 2007 - 04:16 PM The root password should. Seriously... if people don't start reading this before posting, I'm going to consider not answering at all. Back to top #5 wildteen88 wildteen88 Advanced Member Staff Alumni 10,482 posts LocationUK, Bournemouth Posted 08 February 2007 - 06:22 PM Don't use the mysql command on its own. You should provide at least 1 or two paramters mainly the username (-u username here) followed by the -p parameter. So the command will look something like this: mysql -u root -p If the root user has a password set mysql will prompt for a password t
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: ERROR 1045 (28000): Access http://forums.mysql.com/read.php?60,200408,222836 denied for user 'ODBC'@'localhost' (using password: NO) Posted by: amit sinha () Date: August 16, 2008 07:55PM error 1045 : access denied for user 'ODBC'@'localhost'(using password:no) see, this is not a problem either of http://www.3dbuzz.com/forum/threads/94184-Access-denied-for-user-ODBC-localhost 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 u dont specify the correct things in the access denied 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 : ******** and you will get the mysql prompt: mysql> Isn't easy? amit sinha,india access denied for 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 Online» Products MySQL Enterprise Edition MySQL Standard Edition MySQL Classic Edition MySQL Cluster CGE MySQL Embedded (OEM/ISV) Services Training Certification Consulting Support Downloads MySQL Community S
to 9 of 9 Thread: Access denied for user 'ODBC'@'localhost' Thread Tools Show Printable Version Email this Page… Search Thread Advanced Search Rate This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-26-2004,05:01 AM #1 degrotegast View Profile View Forum Posts 3dbuzz newbie Join Date Sep 2002 Location Netherlands Posts 74 Access denied for user 'ODBC'@'localhost' hi , i am a total newbe, i was trying to connect php to my mysql database, .. but it didnt work. I made a username and a password to connect and modify this database. But when it didnt work. i thought to delete the mysql folder and reinstall it. But now when i am trying to connect this error is in my screen.. can i delete all privileges? and delete all mysql programs on my computer? or will there be files stored on my computer so i cant change anything? what should i do? (i am using mysql 4.1, and apache on windows 2000 computer.) error: D:\mysql\bin>mysql ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO) thanx Reply With Quote 11-26-2004,05:05 AM #2 NeoMT View Profile View Forum Posts Registered User Join Date Jul 2003 Location UK Posts 245 try using "mysql -u root -p" and press enter. it will ask you for the root password that you have set. The error message is just saying that you have removed the anonymous account and mysql is expecting you to login using an existing user account. Reply With Quote 11-26-2004,05:13 AM #3 degrotegast View Profile View Forum Posts 3dbuzz newbie Join Date Sep 2002 Location Netherlands Posts 74 yes i already did it... itbut the problem stays.. i cant type a password .. it just gives an error: D:\mysql\bin>mysql -u php -p; ERROR 1045 (28000): Access denied for user 'php'@'localhost' (using password: YES). Reply With Quote 11-26-2004,05:16 AM #4 NeoMT View Profile View Forum Posts Registered User Join Date Jul 2003 Location UK Posts 245 D:\mysql\bin>mysql -u php -p not D:\mysq