Mysql Error Code 1045 Sqlstate 28000
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 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 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 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 22:54 add a comment| 6 Answers 6 active oldest votes up vote 6 down vote Try to login via the terminal using the following command: mysql -u root -p It will then prompt for your password. If this fails, then definitely the username or password is incorrect. If this works, then your database's password needs to be enclosed in quotes: database_password: "0000" share|improve this answer edited Apr 23 at 0:34 answered May 1 '13 at 19:52 Pier-Luc Gendreau 6,94923151 2 I can login via terminal to my mysql server. I don'
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 http://stackoverflow.com/questions/16325115/sqlstate28000-1045-access-denied-for-user-rootlocalhost-using-password the company Business Learn more about hiring developers or 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 http://stackoverflow.com/questions/17482834/sqlstate28000-1045-access-denied-for-user-xxexample-com-using-password 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SQLSTATE[28000] [1045] Access denied for user 'xx'@'example.com' (using password: YES) up vote 1 down vote favorite I got this error when I change my db password for security reasons. I also updated my /app/etc/local.xml There has been an error processing your request SQLSTATE[28000] [1045] Access denied for user 'xx'@'example.com' (using password: YES) Trace: #0 /var/www/vhosts/example.com/xxx/lib/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 /var/www/vhosts/example.com/xxx/lib/Varien/Db/Adapter/Pdo/Mysql.php(313): Zend_Db_Adapter_Pdo_Mysql->_connect() #2 /var/www/vhosts/example.com/xxx/lib/Zend/Db/Adapter/Abstract.php(459): Varien_Db_Adapter_Pdo_Mysql->_connect() #3 /var/www/vhosts/example.com/xxx/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array) #4 /var/www/vhosts/example.com/xxx/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array) #5 /var/www/vhosts/example.com/xxx/app/code/core/Mage/Core/Model/Resource.php(169): Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8') #6 /var/www/vhosts/example.com/xxx/app/code/core/Mage/Core/Model/Resource.php(110): Mage_Core_Model_Resource->_newConnection('pdo_mysql', Object(Mage_Core_Model_Config_Element)) #7 /var/www/vhosts/example.com/xxx/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(320): Mage_Core_Model_Resource->getConnection('core_write') #8 /var/www/vhosts/example.com/xxx/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(350): Ma
Index Search You are not logged in. Please login or register. Active topics Unanswered topics SQLSTATE[28000] [1045] Access denied for user Wolf CMS Forum »Installing »SQLSTATE[28000] [1045] Access denied for user Pages https://www.wolfcms.org/forum/topic449.html 1 You must login or register to post a reply RSS Topic Feed Posts [ 10 ] 1 Topic by pixeltarian 2010-04-08 15:40 pixeltarian Community member Offline Registered: 2010-04-08 Posts: 21 Topic: SQLSTATE[28000] [1045] http://askubuntu.com/questions/401449/error-104528000-access-denied-for-user-rootlocalhost-using-password-no Access denied for user upon trying to install I get: SQLSTATE[28000] [1045] Access denied for user 'deesignva_admin'@'localhost' (using password: YES)how do I fix this? I KNOW for a fact my DB i created, mysql error my username is correct, and my password is also correct. the only thing I can think of is that my webhost needs me to call it something other than "localhost" but i doubt it. Note to developers, this has been happening to me with a few CMSs lately. the answer is usually "go to phpmyadmin, delete this file and copy this and paste this there" perhaps wolfcms could mysql error code be the first to fix it so no one has to do those things. Last edited by pixeltarian (2010-04-08 15:43) 2 Reply by David 2010-04-08 15:47 David Wolf CMS support Offline From: Edinburgh, UK Registered: 2009-07-16 Posts: 2,333 User Karma: 67 Re: SQLSTATE[28000] [1045] Access denied for user Hi pixeltarian -Hope we can help you, but you haven't given us a lot to go on!- this could be a problem with the db server - do check with your webhost to find out what value to put for "Database server" - it is often localhost, but for two webhosts I use, there is a specific path to a specific server that I need to use.- if that isn't it, do tell us the versions of Apache, mySQL, and PHP that you're using - that might shed light on something.And just for the banter... ... perhaps wolfcms could be the first to fix it so no one has to do those things.Wouldn't it be lovely! But the thing is, there are so many different hosting arrangements, that systems like Wolf do need to ask the users to supply some values! There are always hosted solutions for those who can't quite manage that st
communities company blog Stack Exchange Inbox Reputation and Badges sign up 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 Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and answer site for Ubuntu users and developers. 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 ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no ) up vote 32 down vote favorite 10 I'm trying to install queXS cati app on my Ubuntu desktop and I installed MySQL server and PHP 5 and I cannot login into MySQL server as root without password: mysql -u root it says ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no ) But it's okay when I enter mysql -u root -p I can't figure out what the problem is. permissions mysql share|improve this question edited May 12 at 8:31 oerdnj 3,8661440 asked Jan 7 '14 at 10:42 user232705 161123 6 Try this: mysql -u root -p mysql Enter password: and you will get: mysql> –user273774 Apr 24 '14 at 18:47 add a comment| 3 Answers 3 active oldest votes up vote 29 down vote That is the normal behaviour. You set a root password for your database so from now on you can't access it without password. That is why it reports: Access denied for user 'root@localhost' (using password: no ) Obviously when you give the password with the -p switch you succeed. share|improve this answer answered Jan 7 '14 at 10:47 falconer 9,94721846 add a comment| up vote 2 down vote In simple words your "root" session do not know password to mysql root user. If you want to make easier to access your mysql create .my.cnf in /root/ and put in it [mysqladmin] user = root password = mysqlrootpassword [mysql] user = root password = mysqlrootpassword [mysqldump] user = root password = mysqlrootpassword where offcourse mysqlrootpassword is your password for mysql's root password so when you execute mysql it uses this password Remeber about safety of this file - put secure rights, so nobody on your server can read it! share|improve this answer answered Jan 16 '14 at 22:25 pl_ 491 1 It's bad to encourage others to put root pass