Mysqldump Error 1045
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 mysqldump got error 1045 access denied for user 'odbc'@'localhost' more about Stack Overflow the company Business Learn more about hiring developers or posting
Mysqldump Access Is Denied
ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community mysqldump got error 1045 access denied for user when using lock tables 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 mysqldump: Got error: 1045 Access denied up vote 2 down mysqldump error 1044 vote favorite I am logged into an AWS instance and trying to copy a mysql database to a .sql file. I am using the command: mysqldump -u [username] -p [databasename] > [database].sql Then entering the password and the following message comes up. "mysqldump: Got error: 1045: Access denied for user '[username]'@'localhost' (using password: YES) when trying to connect." I can login directly to mysql using the same credentials as
Mysqldump Access Denied When Using Lock Tables
above, but still get the same error. I have tried a bunch of different ways for the command above, but it seems to be an issue with permissions or something similar. The user does have all privileges for the database when looking in phpmyadmin so I am not sure what is wrong? Any suggestions? Thanks mysql mysqldump share|improve this question edited May 19 '14 at 18:40 ρss 2,27661741 asked May 19 '14 at 18:37 KyleBunga 23115 Stack Overflow is a site for programming and development questions. This question appears to be off-topic because it is not about programming or development. See What topics can I ask about here in the Help Center. Perhaps Super User or Unix & Linux Stack Exchange would be a better place to ask. Also see Where do I post questions about Dev Ops?. –jww Apr 2 at 0:49 It also looks like a duplicate of mysqldump Error 1045 Access denied despite correct passwords etc. –jww Apr 2 at 0:50 Also see How to have MySQL entitle the root user? on Super User. It attempts to avoid resetting passwords. –jww Apr 2 at 11:27 add a comment| 3 Answers 3 active oldest vot
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 mysql error 1045 access denied for user root localhost using password yes crashed. The first thing i noticed was an AppArmor popup informing glance-registry has mysqldump: got error: 1044: access denied for user ''@'localhost' to database crashed unexpectedly. Further inspection revealed that the 'glance-registry' daemon is starting and crashing in an andless loop. All other OpenStack
Mysqldump Couldn T Find Table
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 http://stackoverflow.com/questions/23744866/mysqldump-got-error-1045-access-denied '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 http://www.tikalk.com/devops/solution-mysql-error-1045-access-denied-userlocalhost-breaks-openstack/ 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 defined in mysql, as well as 'keystone' and 'nova'. Permissions and grants looked ok - and let's recall openstack worked (!).
'root If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have http://forum.directadmin.com/showthread.php?t=40083 to register before you can post: click the register link above to https://ubuntuforums.org/showthread.php?t=1988939 proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: Got error: 1045: Access denied for user 'root Thread Tools Show Printable Version Email this Page… Display Linear Mode Switch to Hybrid Mode Switch access denied to Threaded Mode 04-15-2011,01:49 AM #1 gvh View Profile View Forum Posts Verified User Join Date May 2010 Posts 37 Got error: 1045: Access denied for user 'root hello this is my problem when I full backup , this error looks Code: Error while backing up database tunak_db Error while backing up database tunak_db: The sql file is 0 access denied for bytes in size: /home/tunak/backups/backup/ifede_db.sql mysqldump error output: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect Code: mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect http://www.directadmin.com/forum/showthread.php?t=37587 http://www.directadmin.com/forum/new...newthread&f=38 I tried all of them did not work I cant solve this problem can you help me thank you Reply With Quote 04-15-2011,08:11 AM #2 SeLLeRoNe View Profile View Forum Posts Visit Homepage Crazy Network Join Date Oct 2004 Location London, UK Posts 6,287 Try this command for optimize and repair all databases Code: /usr/bin/mysqlcheck -uda_admin -p`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --auto-repair --check --optimize --all-databases Regards SeLLeRoNe - Andrea Iannucci DevOps Engineer - System Administrator If you need my support write me an E-Mail to Support@CrazyNetwork.it Reply With Quote 04-15-2011,12:15 PM #3 gvh View Profile View Forum Posts Verified User Join Date May 2010 Posts 37 not solved mysqldump error output: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect Reply With Quote 04-15-2011,12:56 PM #
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 Links Distrowatch Bugs: Ubuntu PPAs: Ubuntu Web Upd8: Ubuntu OMG! Ubuntu Ubuntu Insights Planet Ubuntu Activity Page Please read before SSO login Advanced Search Forum The Ubuntu Forum Community Ubuntu Specialised Support Ubuntu Servers, Cloud and Juju Server Platforms [ubuntu] Ubuntu 12.04 - mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' Having an Issue With Posting ? Do you want to help us debug the posting issues ? < is the place to report it, thanks ! Results 1 to 7 of 7 Thread: Ubuntu 12.04 - mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode May 28th, 2012 #1 vavr View Profile View Forum Posts Private Message Spilled the Beans Join Date May 2012 Beans 14 Ubuntu 12.04 - mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' Hi @ all I hava make a windows share folder which has been mount in mu 12.04 server. i'm trying to to run a mysqldump commnad in order to backup my db and then if it works to make it work automatically via the crontab and from then directly to my server. the command : mysqldump -u root -pRootPassword --all-databases | gzip > /mnt/backup/MYSQL_Backup/DBname_`date '+%m-%d-%Y'`.sql.gz and i am getting the error : Error : -bash: /mnt/backup/MYSQL_Backup/Nessus_05-28-2012.sql.gz: Permission denied mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect. Any help plz? thanks Adv Reply May 28th, 2012 #2 LHammonds View Profile View Forum Posts Private Message Dipped in Ubuntu Join Date Sep 2011 Location Behind you! Beans 564 DistroUbuntu 12.04 Precise Pangolin Re: Ubuntu 12.04 - mysqldump: Got error: 1045: Access denied for user 'root'@'localho Well, that looks like a file permission / access problem more than a mysqldump problem. Type "whoami" to see what ID you are currently logged in as. Then do "ls -l /mnt/backup" and make sure the ID has read/write access. The next thing you want to do after you clean up your permission problem is to change how you are calling your mysqldump command. You do