Error Code 1045 Sqlstate 28000 Mysql
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have mysql error 1045 sqlstate 28000 access denied for user Meta Discuss the workings and policies of this site About Us
Error 1045 Sqlstate 28000 (er_access_denied_error)
Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with error 1045 sqlstate 28000 access denied for user 'root'@'localhost' us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, sqlstate[28000] [1045] access denied for user 'root'@'localhost' (using password: yes) magento just like you, helping each other. Join them; it only takes a minute: Sign up SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES) Symfony2 up vote 8 down vote favorite 1 I tried to create my DB with Symfony2. I typed the command: php app/console doctrine:create:database The result is: Could not create database for
Magento Sqlstate[hy000] [1045] Access Denied For User 'root'@'localhost' (using Password: Yes)
connection named `jobeet` SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES) The contents of my app/config/parameters.yml file is: parameters: database_driver: pdo_mysql database_host: 127.0.0.1 database_port: ~ database_name: jobeet database_user: root database_password: 0000 mailer_transport: smtp mailer_host: 127.0.0.1 mailer_user: ~ mailer_password: ~ locale: fr secret: ThisTokenIsNotSoSecretChangeIt My OS is Ubuntu. I don't know what to do to correct this problem. Thanks for your help. mysql ubuntu symfony2 share|improve this question edited May 1 '13 at 19:41 wescrow 2,1901021 asked May 1 '13 at 19:36 mentaga 41113 5 Access denied for user 'root'@'localhost' (using password: YES) is a MySQL connection error. Usually implies invalid user and/or password. Sometimes you have to use localhost not 127.0.0.1 for this to work. –rncrtr May 1 '13 at 19:38 1 Is the password in quotes? –Patrik Karisch May 1 '13 at 22:15 3 Congratulation !!! The password need to be enter quotes. thank you very much!! How to do this post at resolved status? –mentaga May 1 '13 at
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 sqlstate 28000 error code 1045 access denied for user magento us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack pdo connection error sqlstate 28000 1045 access denied for user 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
#1045 Access Denied For User Localhost Using Password Yes
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. I'm http://stackoverflow.com/questions/16325115/sqlstate28000-1045-access-denied-for-user-rootlocalhost-using-password 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 'bill'@'localhost' http://stackoverflow.com/questions/10299148/mysql-error-1045-28000-access-denied-for-user-billlocalhost-using-passw (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,87081738 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 the most specif
Extensions Demos Logo Documentation Take the Tour Tutorials Class Reference Wiki Guide 2.0 Class Reference 2.0 Screencasts Resources Development Contribute to Yii Latest Updates Report a Bug Report a Security Issue Community Forum Live Chat News Hall of Fame Badges search Yii Framework http://www.yiiframework.com/forum/index.php/topic/50166-database-connection-probelm-sqlstate28000-1045-access-denied-for-user/ Forum: Database Connection Probelm / Sqlstate[28000] [1045] Access Denied For User - Yii Framework Forum Jump to content Sign In » New user? Register Now! Help Search Advanced ForumsMembers Yii Framework Forum > Yii 1.1.x > Installation and Setup View New Content Page 1 of 1 You cannot start a new topic You cannot reply to this topic Database Connection Probelm / Sqlstate[28000] [1045] Access Denied For User #1 sts Newbie Group: Members Posts: access denied 3 Joined: 26-December 13 Posted 26 December 2013 - 11:25 AM Hi, Spent quite some time to try to fix a connection problem following advice from older threads but can't solve this. I do get the Gii interface and I can connect to the database in terminal. But when I try to create a model Yii throws this error: CDbConnection failed to open the DB connection: SQLSTATE[28000] [1045] Access denied for user 'tom'@'localhost' (using password: access denied for YES) My settings are: 'db'=>array( 'connectionString' => 'mysql:host=127.0.0.1;dbname=my_db', 'class'=>'CDbConnection', 'emulatePrepare' => true, 'username' => 'tom', 'password' => 'my_password', 'charset' => 'utf8', ), If I try with localhost it gives me CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2002] No such file or directory Thanks for any help! 0 Back to top of the page up there ^ #2 JFReyes Advanced Member Group: Members Posts: 508 Joined: 28-October 09 Location:Puerto Rico Posted 26 December 2013 - 11:36 AM You must have the user defined in MySQL's user table: CREATE USER 'tom'@'localhost' IDENTIFIED BY 'my_password'; Notice that 'localhost' is not the same as '127.0.0.1'; if you want to be able to login from anywhere use '%' as the host address. José 0 Back to top of the page up there ^ #3 sts Newbie Group: Members Posts: 3 Joined: 26-December 13 Posted 27 December 2013 - 11:32 AM JFReyes, on 26 December 2013 - 11:36 AM, said: You must have the user defined in MySQL's user table: CREATE USER 'tom'@'localhost' IDENTIFIED BY 'my_password'; Notice that 'localhost' is not the same as '127.0.0.1'; if you want to be able to login from anywhere use '%' as the host address. Thanks for the help! I did create a user using the same SQL: CREATE USER 'tom'@'localhost' IDENTIFIED BY 'my_pass'; GRANT ALL ON wmm_db.* To 'tom