Error 1045 Mysql 28000 Windows
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 Stack Overflow the company mysql error 1045 sqlstate 28000 access denied for user Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs mysql.connector.errors.programmingerror 1045 (28000) Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, error 1045 (28000) access denied for user (using password yes) 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: NO) permanently up vote 6 down vote favorite 3
Error 1045 (28000) Access Denied For User @'localhost' (using Password Yes)
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, the same problem is recurring. One more thing is that i have created error 1045 access denied for user ''@'localhost' to database 'mysql' 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' (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
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 Stack Overflow error 1045 (28000) access denied for user 'root'@'127.0.0.1' (using password yes) the company Business Learn more about hiring developers or posting ads with us Stack Overflow
Error No 1045 Access Denied For User
Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of
Connect Error (1045) Access Denied For User 'root'@'localhost' (using Password Yes)
4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Mysql: Access denied for user 'root'@'localhost' up vote 10 down vote favorite I know, it's really sad, but http://stackoverflow.com/questions/23950722/how-to-overcome-error-1045-28000-access-denied-for-user-odbclocalhost-u I'm not able to connect to MySQL database. I simply donwloaded and unzipped mysql-5.6.10-win32.zip from MySQL site. I followed this tutorial, but I'm not able to connect to my MySQL database as root. I know it's not secure to connect as a root without the password, but I just need to do some test, so it's ok for me to do it now (and if I know how to connect as a root http://stackoverflow.com/questions/15765168/mysql-access-denied-for-user-rootlocalhost I know how to add another user too). my.ini # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the # *** default location during install, and will be replaced if you # *** upgrade to a newer version of MySQL. [mysqld] # Remove leading # and set to the amount of RAM for the most important data # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%. # innodb_buffer_pool_size = 128M # Remove leading # to turn on a very important data integrity option: logging # changes to the binary log between backups. # log_bin # These are commonly set, remove the # and set as required. basedir=c:\Programs\mysql-5.6.10-win32 datadir=c:\Programs\mysql-5.6.10-win32\data port=3306 server_id=1 # Remove leading # to set options mainly useful for reporting servers. # The server defaults are faster for transactions and fast SELECTs. # Adjust sizes as needed, experiment to find the optimal values. # join_buffer_size = 128M # sort_buffer_size = 2M # read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [client] port=3306 When I start mysqld I see: > mysqld --console --init-file=..\set_root_password.sql 2013-04-02 13:48:24 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-
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 http://forums.mysql.com/read.php?11,34014,46593 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 error 1045 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 comment|
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: Install & Repo :: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) New Topic Advanced Search Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Posted by: Shawn Tucker () Date: September 27, 2005 12:40PM I had the same problem, this solution worked for me. You will need to reset the password. First start the mysql server instance or daemon with the --skip-grant-tables option. (security setting) Then Execute these statements. # mysql -u root mysql mysql> UPDATE user SET Password=PASSWORD('your_new_password') where USER='root'; mysql> FLUSH PRIVILEGES; Finally, restart the instance/daemon without the --skip-grant-tables option. You should be able to connect with your new password. # mysql -u root -p Enter password: your_new_password Hope this helps. Shawn Tucker Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Daniel Ho 07/12/2005 01:16PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Daniel Ho 07/12/2005 07:49PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) carminda timas 05/11/2007 02:20PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Eric Okorie 05/21/2007 10:57PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) pigeret john 07/22/2007 01:59AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Me izme 10/11/2007 08:04AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Christopher Armstrong 12/27/2007 07:40PM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) kandy kavitha 09/01/2009 12:03PM Re: ERROR 1045 (28000):