Mysql Error Number 1045 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 mysql access denied for user 'root'@'localhost' (using password yes) site About Us Learn more about Stack Overflow the company Business Learn more
Mysql Access Denied For User Using Password Yes
about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x mysql access denied for user using password no 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 MySQL ERROR error 1045 sqlstate 28000 access denied for user 'root'@'localhost' 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 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
#1045 Access Denied For User Localhost Using Password Yes
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 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.
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 mysql drop anonymous user company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions error 1045 mysql windows Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million
1045 - Access Denied For User 000webhost
programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ERROR 1045 (28000): Access denied for user 'username'@'%' (using password: YES) up vote 3 down vote favorite 2 I Installed MySQL http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw on my CentOS 6.4 server. I logged into my root and changed its password. Later I thought that I should make a new user and use that user as my default user, So I created a new user name golden using the following command: CREATE USER 'golden'@'%' IDENTIFIED BY 'password'; Then I applied permission to the user golden: GRANT ALL PRIVILEGES ON * . * TO 'golden'@'%'; FLUSH PRIVILEGES; Now this user: golden http://stackoverflow.com/questions/19220085/error-1045-28000-access-denied-for-user-username-using-password-yes was able to do everything. So I finally Deleted the root user. Now I am stuck up on granting privilege to my one another new user. I created another user, when I was logged in through golden (At this time I had already deleted the root user and command successfully created and the new user I am able to see it in list also) CREATE USER 'fashion'@'%' IDENTIFIED BY 'password'; Then the following commands below gives me error: GRANT ALL PRIVILEGES ON *.* TO 'fashion'@'%'; ERROR: ERROR 1045 (28000): Access denied for user 'golden'@'%' (using password: YES) I also tried the following command the result is below: mysql> SELECT USER(),CURRENT_USER(); +------------------+----------------+ | USER() | CURRENT_USER() | +------------------+----------------+ | golden@localhost | golden@% | +------------------+----------------+ If I wont be able to give access to this user then how can I login and use the database? Kindly help. EDIT 1: The following command gives me the following result mysql> select user, host FROM mysql.user; +------------+-------+ | user | host | +------------+-------+ | golden | % | | fashion | % | +------------+-------+ mysql database permissions privileges grant share|improve this question edited Oct 7 '13 at 8:43 asked Oct 7 '13 at 8:26 Django Anonymous 935114084 So total how many users exist in your mysql?? –Jhanvi Oct 7 '13 at
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 marked this answer as accepted. Are you sure you want to unaccept 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 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 http://serverfault.com/questions/620694/mysql-remote-connection-access-denied-for-user-usernamelocalhost-using-p Share 0 Setup MySQL on Ubuntu Droplet getting error ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) December 3, 2015 28.3k views MySQL Hi guys, I am very new to using a service like access denied 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 '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 access denied for 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 5 CrypticDesigns December 3, 2015 Which one-click-setup did you use? You can check the configuration files probably and find the password. If you can't find it, neither root without pass is working you can reset it: Commands sudo /etc/init.d/mysql stop Now start up MySQL in safe mode, so you'll skip the privileges table: sudo mysqld_safe --skip-grant-tables & Login with root: mysql -uroot And assign the DB that needs to be used: use mysql; Now all you have
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 Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. 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 remote connection - Access denied for user 'username'@'localhost' (using password: YES) up vote 1 down vote favorite I am setting up a remote connection to a MySQL server but no matter what I try I am getting access denied error from the remote server. I added the user by: CREATE USER 'username'@'REMOTE_IP_ADDRESS' IDENTIFIED BY '***'; Then I gave permissions: GRANT ALL PRIVILEGES ON databasename.* to username@REMOTE_IP_ADDRESS; My user table on MySQL server shows (amongst other things): +---------------+--------------------+ | user | host | +---------------+--------------------+ | username | REMOTE_IP_ADDRESS | +---------------+--------------------+ If I show grants for the user I get: +------------------------------------------------------------------------------------+ | Grants for username@REMOTE_IP_ADDRESS +------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'username'@'REMOTE_IP_ADDRESS' IDENTIFIED BY PASSWORD '***' | GRANT ALL PRIVILEGES ON `databasename`.* TO 'username'@'REMOTE_IP_ADDRESS' +------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) On the remote server I then use: mysql -u username -p DB_SERVER_IP and get the error message: ERROR 1045 (28000): Access denied for user 'username'@'localhost' (using password: YES) I have done "flush privileges" but I still cannot connect - I notice that the error is username@localhost and I don't have any permissions set up for username@localhost but I have never had to do this before. I have some other remote accounts on the same server and none of them have @localhost as they only connect locally. What am I missing? Have I forgotten to do something or what else can I check? mysql share|improve this question edited Aug 15 '14 at 14:00 asked Aug 15 '14 at 13:48 bhttoan 2901519 1 -p is the