Error 1045 Sqlstate 28000
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 Business Learn more about hiring developers or posting ads error 1045 sqlstate 28000 access denied for user with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack error 1045 sqlstate 28000 (er_access_denied_error) Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign error 1045 sqlstate 28000 access denied for user 'root'@'localhost' up MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using 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. error code 1045 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 with bill: mysql -u bill -p entered the correct password and got this error: ERROR 1045 (28000): Access denied for user
Mysql Error 1045 Sqlstate 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 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 sorted order. The server uses the first row that matches the client host name and user name. (...) The server uses sorting rules that order rows with the most-specific Host values first. Literal host names [such as 'localhost'] and IP addresses are th
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
Error 1045 28000 Access Denied For User Using Password Yes
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation #1045 access denied for user localhost using password yes Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just pdo connection error sqlstate 28000 1045 access denied for user like you, helping each other. Join them; it only takes a minute: Sign up How do I fix this error: [1045] SQLSTATE[28000] [1045] up vote 0 down vote favorite I am working on a server that is not http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw my localhost for the first time. I am renting hosting space from hostgator. I created a form that is supposed to take the user's information and put it in the database. I keep on recieving the following error message when I try to submit the form: Failed to open database [1045] SQLSTATE[28000] [1045] Access denied for user 'username@localhost'@'gator7899.hostgator.com' (using password: YES) I have seen other posts in which people ask the same question but none http://stackoverflow.com/questions/14698256/how-do-i-fix-this-error-1045-sqlstate28000-1045 of the answers given are working for me. Also, username is not my actual username and gator7899 is not the actual server. For security purposes I did not post them here. Does anyone know how to fix this? mysql database localhost share|improve this question edited Feb 5 '13 at 0:36 Lion 9,613135385 asked Feb 5 '13 at 0:34 Philip7899 1,7441648 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Make sure privledges are assigned in your CPanel -> mysql admin -> add user to database then you need to change your config to be localhost username = username of CPanel password = password of Cpanel share|improve this answer answered Feb 5 '13 at 0:39 Val 364110 I can't find the configuration file in the control panel or in the file directory. Any idea on where it would be? Thank you. –Philip7899 Feb 5 '13 at 0:47 I would look at the page that is displaying the error, look at the code/line where there is a connection to mysql and append the username and password accordingly. –Val Feb 5 '13 at 0:48 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a g
that make connections all over the world. Join today Community Community Home Getting Involved Chat Forum SupportPost installation PDOException: SQLSTATE[28000] [1045] Access denied https://www.drupal.org/node/1059244 for user Posted by estevan_carlos on February 11, 2011 at 11:59pm https://www.drupal.org/node/1915820 I randomly got this error and it shows the username for my database. PDOException: SQLSTATE[28000] [1045] Access denied for user '******'@'localhost' (using password: YES) in lock_may_be_available() (line 165 of /home/*****/public_html/******.com/includes/lock.inc). What exactly do I do? It's completely random. I accessed the site last night. No problems. Now error 1045 this. Suggestions? Log in or register to post comments ⋅ Categories: Drupal 7.x Comments same error ... mine spits out thrivehd commented February 15, 2011 at 10:12pm same error ... mine spits out Dreamhost shenanigans. PDOException: SQLSTATE[28000] [1045] Access denied for user '***'@'apache2-**.dreamhost.com' (using password: YES) in lock_may_be_available() (line 165 of /home/**/**.INFO/includes/lock.inc). Thanks everyone! Log in or register access denied for to post comments My solution mister_t commented April 28, 2011 at 2:48pm I was having the same error message when starting an existing project on another computer. As the repository wasn't online already, I had to copy the whole D7 folder from PC1 to PC2, and import the database in phpMyAdmin. I've got this error as result when accessing my (localhost) homepage. So I went looking in the users table where I found the problem, the Drupal user for the database was missing. To solve this problem, I started with removing the whole database. Next step I created a new user and database in phpMyAdmin, following this steps. When the users has been created, the next step is to import the existing database. To do so, I've deleted the (empty) database to prevent error messages about the database already existing. Now you can import the database of your project and you're ready to go. I realize this might take some detour, but it's a pretty basic solution and not hard to understand
that make connections all over the world. Join today Download & Extend Drupal Core Distributions Modules Themes Web service clientIssues This issue is not for reporting "Access denied for user" problems Closed (works as designed)Project:Web service clientVersion:7.x-1.x-devComponent:User interfacePriority:NormalCategory:Support requestAssigned:tasoslpReporter:imihir92Created:February 13, 2013 - 03:57Updated:July 11, 2016 - 00:07 Log in or register to update this issue Jump to:Most recent comment PDOException: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO) in lock_may_be_available() (line 167 of /home/designar/public_html/includes/lock.inc). i have uploading my web site fro local server to web server....but again again showing the same problem upload all files and db to the server bu t shows an error report "PDOException: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: NO) in lock_may_be_available() (line 167 of /home/designar/public_html/includes/lock.inc)." Comments Comment #1 klausi CreditAttribution: klausi commented April 7, 2013 at 10:26pm Status: Active » Postponed (maintainer needs more info) Looks like your database connection is not configured correctly on the server. Does the installation work without wsclient? Log in or register to post comments Comment #2 tboyd@commplus.ca CreditAttribution: tboyd@commplus.ca commented May 10, 2013 at 9:08pm I have a similar Error. My error reads: PDOException: SQLSTATE[28000] [1045] Access denied for user 'bdaportal'@'localhost' (using password: YES) in lock_may_be_available() (line 167 of C:\Inetpub\websites\portal.bd-a.ca\includes\lock.inc). I checked the database from the c prompt and I can certainly access it with the user name and password I have assigned it and which is in the settings file on the drupal website. I am runnin