Got Error 1045
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss mysqldump got error 1045 access denied for user 'odbc'@'localhost' the workings and policies of this site About Us Learn more mysqldump access is denied about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack
Mysqldump Got Error 1045 Access Denied For User When Using Lock Tables
Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping
Mysqldump Error 1044
each other. Join them; it only takes a minute: Sign up mysqldump Error 1045 Access denied despite correct passwords etc up vote 25 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 error 1045 (28000): access denied for user ''@'localhost' (using password: yes) database with mysqldump on Windows XP. The username is root, the password is correct and contains only alphanumeric characters. I 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 126124 3 did you try with -p option without applying the password? then you should be prompted for the p
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.
Mysqldump Got Error 1044 Access Denied For User Localhost To Database
The first thing i noticed was an AppArmor popup informing glance-registry has crashed mysqldump access denied when using lock tables unexpectedly. Further inspection revealed that the 'glance-registry' daemon is starting and crashing in an andless loop. All other OpenStack services were mysqldump couldn t find table 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 http://stackoverflow.com/questions/20059823/mysqldump-error-1045-access-denied-despite-correct-passwords-etc 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 http://www.tikalk.com/devops/solution-mysql-error-1045-access-denied-userlocalhost-breaks-openstack/ 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 (!). Connecting from any remote host (same command
'root If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start http://forum.directadmin.com/showthread.php?t=40083 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 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 access denied 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 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 access denied for 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,271 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 #4 SeLLeRoNe View Profile View Forum Posts Visit Homepage Crazy Network Join Date Oct 2004 Location London, UK Posts 6,271 i still dont get why use root for make backups... is not supposed to as i know.. he should do using da_admin access to mysql... Honestly ive no idea, maybe someone else will have much better ideas. 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-16-2011,12:33 AM #5 DirectAdmin Su