Mysqldump Got 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 mysqldump got error 1045 access denied for user 'odbc'@'localhost' site About Us Learn more about Stack Overflow the company Business Learn more
Mysqldump Access Is Denied
about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Mysqldump: Got Error: 1045: Access Denied For User When Using Lock Tables
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 mysqldump Error 1045
Mysqldump Error 1044
Access denied despite correct passwords etc up vote 26 down vote favorite 6 This is a tricky one, I have the following output: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect When attempting to export my database with mysqldump on Windows XP. The username is root, the password is correct and contains only alphanumeric characters. I mysqldump access denied when using lock tables have tried different cases, with/without quotes, specifying using -u and -p, specifying using --user= and --password= and other methods of specifying user/passwords etc, specifying the host (it's all local) and even specifying the database using --databases instead of just blank. The error is always the same when using a password and always the same except the "NO" message when without. I have tried many fixes found through searches with no success. One fix suggested inspecting mysql.conf, but the Windows build doesn't seem to have one. The credentials (and indeed commandline parameters) work perfectly with mysql.exe - this problem only seems to be affecting mysqldump.exe. Many thanks for your help. mysql localhost access-denied mysql-error-1045 windows-xp-sp3 share|improve this question edited Nov 19 '13 at 12:53 asked Nov 18 '13 at 23:01 DdlyHeadshot 131124 3 did you try with -p option without applying the password? then you should be prompted for the password. –rubo77 Nov 18 '13 at 23:06 Are you able to connect to the database with mysql client using the same credentials? –Kacer Nov 18 '13 at 23:06 Same credentials, identical login part of the command-line to that
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 mysql error 1045 access denied for user root localhost using password yes working on the nova-compute node, openstack crashed. The first thing i noticed mysqldump got error 1044 access denied for user localhost to database was an AppArmor popup informing glance-registry has crashed unexpectedly. Further inspection revealed that the 'glance-registry' daemon is starting and mysqldump: couldn't find table: 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): http://stackoverflow.com/questions/20059823/mysqldump-error-1045-access-denied-despite-correct-passwords-etc 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 http://www.tikalk.com/devops/solution-mysql-error-1045-access-denied-userlocalhost-breaks-openstack/ 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/m
Sign in Pricing Blog Support Search GitHub https://github.com/welaika/wordmove/issues/193 This repository Watch 61 Star 1,010 Fork 118 http://dba.stackexchange.com/questions/89113/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y welaika/wordmove Code Issues 59 Pull requests 4 Projects 0 Wiki Pulse Graphs New issue mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect #193 Closed rwbrown72 opened access denied this Issue Jul 27, 2015 · 4 comments Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 2 participants rwbrown72 commented Jul 27, 2015 Hello.. and thanks for a cool gem. I'm testing out this gem access denied for and I'm having an issue with the dump.sql. I'm going to delete this test server as soon as I'm finished writing this. Here is the error I'm getting: Russells-iMac:jjlaw Home$ wordmove push --all -e live ▬▬ ✓ Using Movefile: ./Movefile ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ ▬▬ ✓ Pushing wordpress core ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ remote | put_directory: /Applications/MAMP/htdocs/jjlaw /var/www/html/jjlaw .git/ .gitignore .sass-cache/ bin/ tmp/* Gemfile* Movefile wp-config.php wp-content/*.sql wp-content/* I, [2015-07-27T13:46:35.031210 #52357] INFO -- : rsync --progress -e 'ssh root@###.###.##.###' -rlpt --compress --omit-dir-times --delete --exclude .git/ --exclude .gitignore --exclude .sass-cache/ --exclude bin/ --exclude 'tmp/*' --exclude 'Gemfile*' --exclude Movefile --exclude wp-config.php --exclude 'wp-content/*.sql' --exclude 'wp-content/*' /Applications/MAMP/htdocs/jjlaw/ :/var/www/html/jjlaw building file list ... 1096 files to consider sent 22137 bytes received 20 bytes 14771.33 bytes/sec total size is 16314178 speedup is 736.30 ▬▬ ✓ Pushing Uploads â–¬â–
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 Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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: YES) up vote 0 down vote favorite I know this might be a duplicate of some other posts. But those solutions didn't work for me and I've lot of issues within those answers. Neither could I comment nor post in there, I'm posting a question. In my case, I logged into mysql as 'root' and tried to import a sql file into the database. I then exited, did nothing and when again tried to login with the same user. But this time it was showing as bash-2.05$ mysql -u root -p ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) And I tried all different solutions(suggestions from other posts) like mysql -u root -ppwd -h127.0.0.1 mysql -u root -ppwd --protocol=TCP. These suggestions didn't work for me. I couldn't login as the root and without that I will not be having permissions to change any privileges. I'm sure user and password are the correct ones. Apart from all this, I'm using this database for a drupal website. The website gives me an error as PDOException: SQLSTATE[28000] [1045] Access denied for user 'root'@'localhost' (using password: YES) in lock_may_be_available() (line 167 of /home/apache2/htdocs/website/includes/lock.inc). I couldn't trace what's going wrong with this. mysqldump errors error-handling share|improve this question asked Jan 12 '15 at 23:51 gimibarak 106117 Examine the source sql file you ran. Did it contain anything like a mysql.users table or any GRANT, set password or create user queries? It's possible you blew out your root account credentials with that. –atxdba Jan 13 '15 at 0:41 ya, it has mysql.users table or GRANT. It may be the reason. What if I delete that particular database? Does it work? –gimibarak Jan 13 '15 at 0:45 See the link in my answer below on how to restore –atxdba Jan 13 '15 at 0:51 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted If you have