Mysql Error Code 1045
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 access denied for user 'root'@'localhost' Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs
Error 1045 Sqlstate 28000 Access Denied For User 'root'@'localhost'
Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers,
#1045 Access Denied For User Localhost Using Password Yes
just like you, helping each other. Join them; it only takes a minute: Sign up MySQL Error 1045, “Access denied for user 'user'@'localhost' (using password: YES)” up vote 5 down vote favorite This question seem to be
1045 - Access Denied For User 000webhost
asked a lot however I cannot find a definitive answer. I am making some webapp tests using MySQL, and at the beginning I used the 'root' user (with a non-empty password). My root user is working fine from the apps (tested from PHP and Python's Django), from the command line, and with PHPMyAdmin. However I don't wanted to use the the root user, so I created another user, and I granted all privileges to #1045 - access denied for user 000webhost the databases that user should need. (I used PHPMyAdmin logged as 'root' for this task). The new user cannot log in to MySQL. Neither from the Django app, nor PHPMyAdmin, nor the command line. I have two possible suspicions: there is a global privilege the user lacks. (As I said, I granted all database privileges, however I have not granted any global privileges); the user's configured host. ('root' has four lines in the mysql.user table, for hosts 'localhost', 'my-pc-name', '127.0.0.1' and '::1'; while the new user has one line for host '%') (I have double-checked the password, so I am confident this is not a password problem.) mysql mysql-error-1045 share|improve this question edited Apr 13 '13 at 14:55 Álvaro González 81.1k20133201 asked Apr 13 '13 at 14:47 Carlos Eugenio Thompson Pinzón 6373717 1 show how u create a new user in mysql –Tamil Selvan C Apr 13 '13 at 14:50 Did you try granting privileges specifically for user@localhostinstead of using % wildcard? –Uby Apr 13 '13 at 14:59 @Tamil: I created the new user with PHPMyAdmin. –Carlos Eugenio Thompson Pinzón Apr 13 '13 at 15:03 @Uby: I finally did it and it worked. –Carlos Eugenio Thompson Pinzón Apr 13 '13 at 15:04 1 @CarlosEugenioThompsonPinzón Good, keep in mind that % would not matc
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 Business Learn error 1045 mysql windows more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags 000webhost access denied for user Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, #1045 - access denied for user phpmyadmin helping each other. Join them; it only takes a minute: Sign up MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) up vote 240 down vote favorite 118 First let me mention that I've gone http://stackoverflow.com/questions/15989030/mysql-error-1045-access-denied-for-user-userlocalhost-using-password-ye through many suggested questions and found no relevent answer. Here is what I'm doing. I'm connected to my Amazon EC2 instance. I can login with MySQL root with this command: mysql -u root -p Then I created a new user bill with host % CREATE USER 'bill'@'%' IDENTIFIED BY 'passpass'; Granted all the privileges to user bill: grant all privileges on *.* to 'bill'@'%' with grant option; Then I exit from root user and try to login http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw with bill: mysql -u bill -p entered the correct password and got this error: ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES) mysql access-denied share|improve this question edited Sep 6 at 17:44 Jaap 1,2101431 asked Apr 24 '12 at 13:42 Ali 1,88081738 14 Did you FLUSH PRIVILEGES? –eggyal Apr 24 '12 at 14:10 1 Nope. Let me try that –Ali Apr 24 '12 at 14:15 1 Okay, I tried this without any success. Any other suggestion please. –Ali Apr 25 '12 at 4:35 1 What version of the server are you running? I've seen 5.1 behave oddly about this. –Poodlehat Jun 27 '12 at 14:27 1 This happened to me while installing Magento and I made a much sillier mistake. Putting 'mysql -u magento -p magento' was prompting me for a password and instead of the default password I was putting the root password in. –AmirHd Oct 29 '13 at 3:26 | show 4 more comments 26 Answers 26 active oldest votes up vote 282 down vote accepted You probably have an anonymous user ''@'localhost' or ''@'127.0.0.1'. As per the manual: When multiple matches are possible, the server must determine which of them to use. It resolves this issue as follows: (...) When a client attempts to connect, the server looks through the rows [of table mysql.user] in sorte
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 http://stackoverflow.com/questions/19989418/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-n Learn more about Stack Overflow the company Business Learn more about hiring developers or http://forums.mysql.com/read.php?11,34014,46593 posting ads with us 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 you, helping each other. Join them; it only takes a minute: Sign up ERROR 1045 (28000): Access denied for user 'root'@'localhost' access denied (using password: NO) up vote 7 down vote favorite 3 I lost the access onto MySQL v. 5.6.14. I had access and suddenly I lost it. Looking for notes I found out the url below. I did the steps, but not success. http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html C:\Program Files\MySQL\bin>mysqld 2013-11-14 19:46:01 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details) C:\Program Files\MySQL\bin>mysql access denied for -u root mysql1 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Notice: I don't have mysqld_safe or safe_mysqld files in MySQL version Could you please help me? Below you can see the dump file generated by the command: C:\mysqld --init-file=C:\\mysql-init.txt C:\Program Files\MySQL\bin>mysqld --init-file=C:\\mysql-init.txt --console 2013-11-14 17:57:20 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2013-11-14 17:57:20 5180 [Note] Plugin 'FEDERATED' is disabled. 2013-11-14 17:57:20 5180 [Note] InnoDB: The InnoDB memory heap is disabled 2013-11-14 17:57:20 5180 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2013-11-14 17:57:20 5180 [Note] InnoDB: Compressed tables use zlib 1.2.3 2013-11-14 17:57:20 5180 [Note] InnoDB: Not using CPU crc32 instructions 2013-11-14 17:57:20 5180 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2013-11-14 17:57:20 5180 [Note] InnoDB: Completed initialization of buffer pool 2013-11-14 17:57:20 5180 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode 2013-11-14 17:57:20 5180 [ERROR] InnoDB: The system tablespace must be writable! 2013-11-14 17:57:20 5180 [ERROR] Plugin 'InnoDB' init function returned error. 2013-11-14 17:57:20 5180 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2013-11-14 17:57:20 5180 [ERROR] Unknown/unsupported storage engine: InnoDB 2013-11-14 17:57:20 5180 [ERROR] Aborting 2013-11-14 17:57:20
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): Access denied for user 'root'@'localhost' (using password: NO) Majid Farr Amini 06/23/2010 07:33AM Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Meenakshi Gaur 12/29/2010 08: