Error 1045 Access Denied For User Using Password Yes
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
Mysql Hosts Allow
more about Stack Overflow the company Business Learn more about hiring developers or error 1045 28000 mysql posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community #1045 - access denied for user 000webhost Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using
#1045 - Access Denied For User 000webhost Phpmyadmin
password: YES) up vote 238 down vote favorite 116 First let me mention that I've gone 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
#1045 - Access Denied For User 00webhost
the privileges to user bill: grant all privileges on *.* to 'bill'@'%' with grant option; Then I exit from root user and try to login 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,86581738 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 281 down vote accepted
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 #1045 access denied for user localhost using password yes Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs
000webhost Access Denied For User
Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just mysql access denied for user using password yes 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 asked http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw 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 the http://stackoverflow.com/questions/15989030/mysql-error-1045-access-denied-for-user-userlocalhost-using-password-ye 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 80.7k20133198 asked Apr 13 '13 at 14:47 Carlos Eugenio Thompson Pinzón 6323717 1 show how u create a new user in mysql –Tamil Selvan 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 match unix socket
have one accepted answer. Are you sure you want to replace the current answer with this one? Yes, I'm sure. Changed your mind? You previously https://www.digitalocean.com/community/questions/setup-mysql-on-ubuntu-droplet-getting-error-error-1045-28000-access-denied-for-user-root-localhost-using-password-yes marked this answer as accepted. Are you sure you want to unaccept http://dba.stackexchange.com/questions/38803/mysql-error-1045-28000-access-denied-for-user it? Yes, I'm sure. Sign Up Log In submit Tutorials Questions Projects Meetups Main Site logo-horizontal DigitalOcean Community Menu Tutorials Questions Projects Meetups Main Site Sign Up Log In submit View All Results By: greg535417 Subscribe Subscribed Share 0 Setup MySQL on Ubuntu Droplet getting error ERROR 1045 (28000): access denied Access denied for user 'root'@'localhost' (using password: YES) December 3, 2015 26.8k views MySQL Hi guys, I am very new to using a service like digitalocean (opposed to a one click setup of mediatemple or godaddy) and I am trying to setup and configure a new DB using MySQL but I keep getting the error ERROR 1045 (28000): Access denied for user access denied for 'root'@'localhost' (using password: YES) I have googled this, and searched the community for answers but cannot seem to solve this issue. Am I missing something? I have tried running it as root, and running it with sudo through another user and cannot get around it. If I offer no password it gives the same error but instead of using password: YES, it's NO. Thanks. 3 comments 0 mikionline20 January 19, 2016 I faced like this error while i want check my database ERROR 1045 (28000): Access denied for user 'user02'@'localhost' (using password: NO) do you have solution about this 0 CrypticDesigns January 19, 2016 Same solution, just login as root and then change password of the user: update user set password=PASSWORD("YOURPASSWORDHERE") where User='user02'; 0 sergeyvlasov July 3, 2016 Experienced the same problem. This particular explanation and solution made sense for me and helped as well: http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw Log In to Comment Leave a Comment Add comments here to get more clarity or context around a question. To answer a question, use the “Answer” field below. Log In to Comment 5 Answers 4 CrypticDesigns D
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 Us Learn more about Stack Overflow the company Business Learn more about hiring developers 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 it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top MySQL - ERROR 1045 (28000): Access denied for user up vote 5 down vote favorite 3 I just installed a fresh copy of Ubuntu 10.04.2 LTS on a new machine. I logged into MySQL as root: david@server1:~$ mysql -u root -p123 I created a new user called repl. I left host blank, so the new user can may have access from any location. mysql> CREATE USER 'repl' IDENTIFIED BY '123'; Query OK, 0 rows affected (0.00 sec) I checked the user table to verify the new user repl was properly created. mysql> select host, user, password from mysql.user; +-----------+------------------+-------------------------------------------+ | host | user | password | +-----------+------------------+-------------------------------------------+ | localhost | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | server1 | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | 127.0.0.1 | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | ::1 | root | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | | localhost | | | | server1 | | | | localhost | debian-sys-maint | *27F00A6BAAE5070BCEF92DF91805028725C30188 | | % | repl | *23AE809DDACAF96AF0FD78ED04B6A265E05AA257 | +-----------+------------------+-------------------------------------------+ 8 rows in set (0.00 sec) I then exit, try to login as user repl, but access is denied. david@server1:~$ mysql -u repl -p123 ERROR 1045 (28000): Access denied for user 'repl'@'localhost' (using password: YES) david@server1:~$ mysql -urepl -p123 ERROR 1045 (28000): Access denied for user 'repl'@'localhost' (using password: YES) david@server1:~$ Why is access denied? mysql share|improve this question edited May 16 at 18:59 culix 1035 asked Mar 28 '13 at 19:44 davidjhp 2141313 have you tri