Mysql Error 1045 Sqlstate 28000 Er_access_denied_error
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 Documentation Social Media Facebook Twitter Useful error 1045 sqlstate 28000 access denied for user 'root'@'localhost' Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity error 1045 28000 access denied for user localhost using password yes Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Official Flavours Support New to Ubuntu [SOLVED] MySQL giving pdo connection error sqlstate 28000 1045 access denied for user Error 28000, Access Denied ...(using password: YES) Having an Issue With Posting ? Do you want to help us debug the posting issues ? < is the place to report it, thanks ! Page 1 of 2 12 Last
#1045 Access Denied For User Localhost Using Password Yes
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 giving Error 28000, Access Denied ...(using password: YES) Hello all, I have installed mysql using instructions from: https://help.ubuntu.com/community/ApacheMySQLPHP 000webhost access denied for user 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 careful of special characters. Also try using your hostname, i.e. mysql -h xxxxx -u root -p. You show in your initial message that you are having mysql request your password. If you are trying to enter your password on
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 mysqladmin: connect to server at 'localhost' failed Stack Overflow the company Business Learn more about hiring developers or posting ads with
Error 1045 Mysql
us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is
Mysql Access Denied For User ''@'localhost'
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 https://ubuntuforums.org/showthread.php?t=1985847 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 http://stackoverflow.com/questions/16325115/sqlstate28000-1045-access-denied-for-user-rootlocalhost-using-password 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 ter
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and http://stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y 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 http://www.tikalk.com/devops/solution-mysql-error-1045-access-denied-userlocalhost-breaks-openstack/ 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 access denied a minute: Sign up ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) up vote 50 down vote favorite 37 I am an electrical engineering who mainly play around with power system instead of programming. Recently, I have been following a manual to install a software suite on Ubuntu. I have no knowledge on mySQL at all, actually. I access denied for have done the following installations on my Ubuntu. sudo apt-get update sudo apt-get install mysql-server-5.5 sudo apt-get install mysql-client-5.5 sudo apt-get install mysql-common sudo apt-get install glade sudo apt-get install ntp Then I do me@ubuntu:~/Desktop/iPDC-v1.3.1/DBServer-1.1$ mysql -uroot -proot <"Db.sql" I ended up with the following error message. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) How may I fix it and continue? mysql linux ubuntu share|improve this question asked Feb 21 '14 at 20:52 Sibbs Gambling 3,2621042104 1 This does not seem to be strictly programming-related to me. I flagged it for migration to SuperUser –Uli Köhler Feb 21 '14 at 20:55 add a comment| 12 Answers 12 active oldest votes up vote 54 down vote accepted The default root password is blank (i.e. empty string) not root. So you can just login as: mysql -u root You should obviously change your root password after installation mysqladmin -u root password [newpassword] In most cases you should also set up individual user accounts before working extensively with the DB as well. Update: For MySQL 5.7+ please see
1045 25 Jun. 2012 I was working on an OpenStack Essex installation on 2 desktops. Shortly after Ifinished setting up the controller in an all-in-one configuration, and while working on the nova-compute node, openstack crashed. The first thing i noticed was an AppArmor popup informing glance-registry has crashed unexpectedly. Further inspection revealed that the 'glance-registry' daemon is starting and crashing in an andless loop. All other OpenStack services were inoperational and the nova log files in /var/log/upstart/nova-* were huge. Greping /var/log/glance/registry.logfor 'error' i found this (on the controller): 2012-06-16 12:57:42 1356 ERROR [glance.registry.db.api] Error configuring registry database with supplied sql_connection 'mysql://glance:openstack@10.0.0.40/glance'. Got error: (OperationalError) (1045, "Access denied for user 'glance'@'ostk-controller1' (using password: YES)") None None This suggested something is wrong with mysql. Testing access from the commandline produced the same error: $ mysql -uglance -popenstack ERROR 1045 (28000): Access denied for user 'glance'@'localhost' (using password: YES) Wondering what change prvoked this ERROR 1045, i spent hours googling around. There're plenty of ERROR 1045 descriptions, but none of them explained the problem or helped me resolve it - which is the reason for this post. The Problem The logfile of mysqld,/var/log/upstart/mysql.log, reported yet another error: 120618 14:07:31 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.24-0ubuntu0.12.04.1' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) mysqld is alive Checking for tables which need an upgrade, are corrupt or were not closed cleanly. 120618 14:07:36 [ERROR] Cannot find or open table nova/projects from the internal data dictionary of InnoDB though the .frm file for the table exists.Maybe you have deleted and recreated InnoDB data This looked like a DB corruption. Assuming healing it will solve the problem I wasted a few hours on that, in vain. Finally it turned this is a harmless alert that has nothing to do with the Access Denied issue (but is probably a nova bug). Some posts on the subject suggested that the socket permissions prevented local access. In my installation: # ll /var/run/mysqld/mysqld.sock srwxrwxrwx 1 mysql mysql 0 Jun 18 17:34 /var/run/mysqld/mysqld.sock Which is ok. Back to mysql's user accounts. User 'glance' was properly def