Mysql Error 1045 Sqlstate 28000
Contents |
Get Kubuntu Get Xubuntu Get Lubuntu Get UbuntuStudio Get Mythbuntu Get Edubuntu Get Ubuntu-GNOME Get UbuntuKylin Ubuntu Code of Conduct Ubuntu Wiki Community Wiki Other Support Launchpad Answers Ubuntu IRC Support AskUbuntu Official Documentation User error 1045 28000 access denied for user using password yes Documentation Social Media Facebook Twitter Useful Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: mysql access denied for user using password yes Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu mysql access denied for user root Official Flavours Support New to Ubuntu [SOLVED] MySQL giving Error 28000, Access Denied ...(using password: YES) Having an Issue With Posting ? Do you want to help us debug the posting issues ? < is
Mysql Drop Anonymous User
the place to report it, thanks ! Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 11 Thread: MySQL giving Error 28000, Access Denied ...(using password: YES) Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode May 24th, 2012 #1 Senior_Buckethead View Profile View Forum Posts Way Too Much Ubuntu Join Date Jan 2012 Beans 250 mysql access denied for user using password no MySQL giving Error 28000, Access Denied ...(using password: YES) Hello all, I have installed mysql using instructions from: https://help.ubuntu.com/community/ApacheMySQLPHP Note: If you have already set a password for the mysql root, you will need to use: mysql -u root -p(Did you forget the mysql-root password? See MysqlPasswordReset.) But when I follow this up using terminal: Code: glenn@acer:~$ mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) glenn@acer:~$ Why is it giving me that error when I have already set the password? Adv Reply May 24th, 2012 #2 Senior_Buckethead View Profile View Forum Posts Way Too Much Ubuntu Join Date Jan 2012 Beans 250 Re: MySQL giving Error 28000, Access Denied ...(using password: YES) Oh come on people..someone has to know the answer...!! Adv Reply May 24th, 2012 #3 agillator View Profile View Forum Posts Private Message Tea Glorious Tea! Join Date Aug 2011 Beans 343 DistroXubuntu 14.04 Trusty Tahr Re: MySQL giving Error 28000, Access Denied ...(using password: YES) There are a number (large) of possibilities. First, try the obvious. Try logging in without a password. If that works, then IMMEDIATELY set a password for root. If it doesn't, then make sure you are entering the password EXACTLY as you set it. Be car
here for a quick overview of the site Help Center Detailed answers to any questions you might #1045 access denied for user localhost using password yes have Meta Discuss the workings and policies of this site About
Error 1045 Mysql Windows
Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads
Mysql Access Denied For User 'root'@'localhost' (using Password No)
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 https://ubuntuforums.org/showthread.php?t=1985847 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 http://stackoverflow.com/questions/16325115/sqlstate28000-1045-access-denied-for-user-rootlocalhost-using-password 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? &nda
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 http://askubuntu.com/questions/401449/error-104528000-access-denied-for-user-rootlocalhost-using-password-no 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 access denied 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 access denied for 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