Authentication Trouble About Mysqldump: Error 1045
I got a quite strange problem when I tried to setup a database backup
shell. I put it this way:
"bin/mysqldump --opt --user=xxx --password=xxx DB > DB.bak"
However, error 1045 came to me to say "Access denied for user
'xxx'@'localhost' (using password: YES) when trying to connect".
None the less, I'm absolutely full of confidence on my correct username
and password, simply because if I do it this way:
"bin/mysqldump --opt --user=xxx DB > DB.bak",and input the same
password, everything goes well.
Could you please give me some suggestion concerning the issue?
View Complete Forum Thread with Replies
Related Forum Messages:
Mysqldump: Got Error: 1045
I am trying to get Mysqldump to work on a Mysql database for a new customer I have inherited. I am not too familiar with MySQL, but I do know their whole organization hinges on this one database and it is not gettting backed up. It is running in a Windows 2000 Server environment. From the c:mysqlin fold I ran the following command: mysqldump --opt -u 2005golfit@localhost -p "golfit 2005" > backup.s ql When I was prompted for the password I entered the password from the Navicat 'Manage Users' where the access for all the users is defined.I get returned the following error: mysqldump: Got error: 1045: Access denied for user: '2005golfit@localhost@localhost' (Using password: YES) when trying to connect Would the configuration file have the right user / password for this command and where would I find the config file? Can I use Mysqldump while the mysql-max-nt service is still running? One other question that might me related to this error, can I get mysqldump to work in I come in remotely to Windows 2000 Server using Terminal Server? It just occured to me that when I start a second session on Windows 2000 Server, that does not mean another instance of mysql-max-nt starts, correct?
View Replies !
Unable To Generate Snapshot Using Mysqldump - Got Error: 1045
I am trying to create a snapshot (backup) of my MySQL database (INNODB) using the mysqldump tool as follows: mysqldump -p bank > bank.sql; Where bank is the name of the database I wish to backup. When I run the command I get prompted for a password "pass" which then generates the following error: mysqldump: Got error: 1045: Access denied for user 'ODBC'@'localhost' (using password: YES) when trying to connect To logon to the database I typically use the MySQL Command Line Client (Windows Start-> Program -> MySql -> MYSQL Server 5.1 -> MySQL Command Line). When I select this it prompts me for the password ("pass") which I enter and then can load my database and perform whatever operations are needed. So my question is - why does the same password not working for mysqldump? I don't recall ever setting a different one nor do I recall doing anything with a username... This is all done locally (on my pc) under an account with admin rights... Anyone have an idea?
View Replies !
Mysqldump :: Bin/mysqldump: Got Error: 1: Can't Create/write To File
When executing the following command: bin/mysqldump -u root -p -T /Users/bj/Desktop/ tfc The following error appears: bin/mysqldump: Got error: 1: Can't create/write to file '/Users/bj/Desktop/acts.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' However, it does write the 'acts.sql' file which one of the files in the tfc database. I suspect this has something to do with permissions, but even when I run this as 'unix root user' I get the same error.
View Replies !
Error 1045 Access Denied Error
All of our applications run under the root username. (I prefere we not run that way, but that is the way our system is setup currently). When I run mysql I get the error: ERROR 1045(28000): Access denied for user 'root'@'localhost' (using password: NO). Looking at the documentation it recommended that I look at the table mysql.user. I shutdown mysql and start it up again (using mysql_safe and adding the parameter --skip-grant-tables). Once the server was running with skip-grant-tables, I was able to login into user mysql by type: mysql mysql...... I saw the row that had user "root" and host "localhost" had no password. In fact all "root" rows had no password and all the permissions columns were set to "Y". So I stopped the server and restarted it again without the skip-grant-tables and again I got the ERROR 1045 mesasge. (All of this when I was running as root). I also tried mysql -u root (it gave me the same error). Are the new security issues going from version 4.0 to 4.1 that keep me from logging into mysql as root? We desire to be able to log in as root with out a password. Other things I tried: I tried running mysqladmin....I tried mysql_fix_privilege_tables...it would not let me do any of these commands.
View Replies !
Getting Error Nr. 1045
I'm trying to install MySQL. During the security settings portion fo the setup. I keep getting a Connection Error. Error Nr. 1045 Access denied for user'root'@'localhost'(using password:YES) ........ I had Zonealarm running. Changed the trusted zone security setting to low(disabled) then selected "retry" Failed again. Rebooted, turned off Zonealarm, going through configuration wizard I changed the root password to "YES" connection still failed... I'm obviously not crossing a "T" somewhere.
View Replies !
Error Nr. 1045
I am getting this error: 'Error Nr. 1045 Access denied for user 'root'@'localhost'(using password: YES) The thing is I did have a password but I can't recall it and therefore I am stuck as I need the old password even if I want to change to a new one. At the very end of the error message I am being told that if I am re-installing after a previous install (which is precisely what I am doing) the data directory was not removed automatically and therefore the old password from the old installation is still needed. I am advised to re-run the Configuration wizard. However the problem remains even if I do that. Is there anyway I can manually remove the 'data directory'?
View Replies !
Error Nr 1045
I have got MySQL 5.0. I went into Control Panel ->windows firewall>Exceptions tab>"Add Port"button:name:mysql,Port:3306 TCP; Chose "Add Program" button. Browsed to MySQL(C:Program Filesmysql 5.0in I started MySQL Server Instance Config Wizard I typed whatever password. Confirmed it and: it displayed : The security settings could not be applied. Error 1045. My OS is Windows Vista.
View Replies !
ERROR 1045
I have just intalled mysql. I did the set new password thing by following the tut, it seemed like it did nothing. I got to a part where I had to exit mysql. Now whenever I use the mysql command it gives me this: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) HELP. What do I do. I have had great problems trying to get this running, I re-installed 3 times and all 3 I could not get anything working.... I have heard about the phpmyadmin, I have tried installing that with no success...
View Replies !
Error 1045?
I am completly new to My SQL 5.0 and want to install it so I can play around with some database design. I have installed it okay but receive an error message when I go through the Configuration Wizard. The error number is 1045 and the window says "Access denied for user 'root'@'localhost' (using password NO). The error description mentions the TCP port on my firewall. I have checked this and it is open so there should be no reason why it can't connect. Has anyone experienced a simliar problem. If so how did you get around it.
View Replies !
ERROR 1044 And 1045
I have a curious problem with the ERROR 1044 and 1045: -system: OS X 10.4.3 (bash shell) -bash schell prompt: /~ kssun$ -I have set passwd to 'kssun' -I set path: PATH=${PATH}:/usr/local/mysql/bin - symptom 1 when I type mysql (without passwd), I enter mysql prog with following greeting msg: --------------------------------------------------------------------------------------------- Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 56 to server version: 5.0.17-standard Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> --------------------------------------------------------------------------------------------------- But when I try to create database, I get ERROR 1044: ---------------------------------- mysql> create database hi; ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'hi' --------------------------------- for information: ------------------------------------------- mysql> select user(); +-----------------+ | user() | +-----------------+ | kssun@localhost | +-----------------+ 1 row in set (0.00 sec) ------------------------------------------------------ -Symptom 2 I try then to login with -u option, here are the results: (1) login as kssun w/o passwd successed as like login w/o user name, ERROR 1044 for create database, select user() show kssun@localhost (2) login as kssun with passwd failed, ERROR 1045, however I typed the passwd that I set for bash shell ------------------------------------------------------------------- ras75-3-82-226-221-2:~ kssun$ mysql -u kssun -p Enter password: ERROR 1045 (28000): Access denied for user 'kssun'@'localhost' (using password: YES) --------------------------------------------------------------- (3) login as root (w/o passwd) successed to create dababase without any difficulty and user become: ---------------------------------- mysql> select user(); +----------------+ | user() | +----------------+ | root@localhost | +----------------+ Would someone have un idea of this mysterious situation?
View Replies !
Getting MySQL ERROR: 1045
i ll follow all the guidelines as days pass through. I am getting following error when i try to login to mysql prompt. c:mysqlin>mysql -u root -p password:***** ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
View Replies !
Install Error 1045
I have previously installed MySql and uninstalled it. Now when I try to install it again I get Error 1045 during the installation process. I has some waffle about firewalls which I turned off. Also it talks about problems caused by previous installations and using the same root password... which I can't remeber. Is there any way of resetting this? Without reinstalling windows..?
View Replies !
ERROR 1045 (28000)
I insalled mysql on my Linux Enterprise AS platform. When I contact the mysql Server: [root@LinuxServer usr]# mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) what's the rong ?
View Replies !
Error 1045 On Windows XP
I install MySQL on Windows XP and set the username "admin" and password "tester". I can't login in the command, using mysql -u admin -p Enter password: ****** I get ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES) I typed the username and password correctly but I still get the error. Anyone pls. help me,
View Replies !
Connection Error Err Nr 1045
I am trying to set up MySQL 4.1 on windows 2003 web server. I have installed mysql and when configuring i get the Err Nr 1045 Access denied for user root@local host (using password: No) when trying to apply the security settings. I have running a linksys rooter. I have configured the rooter to allow access to port 3306 and forwarded to the web server.
View Replies !
MySql Error 1045
I cannot enter with the user root, nor with another user. this is an error? they have algun procedure to correct it? I already tries several things that find in Internet but did not work.
View Replies !
MySQL Error Nr. 1045 When I Log In . . . ? ? ? ?
The Installation was complet succesfully and when i opened the WinMyAdmin for first time it asked me for user name and password. The user name and password that i gave are : username : admin password : 18922981 Now that i'm trying to log in to mySQL server with the preview pssword and username i'm gettin the "MySQL Error Nr. 1045 " error code . . . But if i try to login as "root" with empty password then i getting full access to mySQL server. How can i get the same permissions either with the username and password that i gave at the first login in mySQL server?
View Replies !
Can't Log In As Anyone But Root. Error 1045
I can GRANT permissions to new users from both the MySQL monitor and phpmyadmin. However, when trying to connect with the new username and password (from either the command line or from a PHP script) I get an error. Here's a copypaste of me logging into the console, adding a user, logging out, and trying to log in as the new user: bash-2.05a$ /usr/local/bin/mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 522 to server version: 3.23.55-entropy.ch Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> grant all -> on * -> to test identified by 'test123' -> ; Query OK, 0 rows affected (0.00 sec) mysql> quit Bye bash-2.05a$ /usr/local/bin/mysql -u test -p Enter password: ERROR 1045: Access denied for user: 'test@localhost' (Using password: YES) bash-2.05a$ Anyone know what's going on? I've googled to no avail.
View Replies !
ERROR 1045 :: LAMP On Ubuntu
I have installed LAMP on an ubuntu machine. Now when I use the command: mysql -u memyid -p it gives me this error: ERROR 1045 (28000): Access denied for user 'memyid'@'localhost' (using password: YES) I did input the password that I set when installing the lamp package. But I do not know why it is acting this way... could some one tell me where I'm going wrong?
View Replies !
ERROR 1045 Using -u -p With Correct Password
I'm facing a strange problem on a freshly installed Debian. I defined passwords for root and several others users I created. When I try to connect using the command : mysql -u root -prootpassword I receive ERROR 1045 Access Denied for user root@localhost using password=YES but when connecting using mysql -u root -p and typing the password when asked for, it connects without any problem ... This is the same with mysqldump, so I can't automate backups .. The problem appears with each and every user, whatever their rights PHPMyAdmin works perfectly, if needed. Any idea ?
View Replies !
Default User Error 1045
mysql install is ok,I did not choose a password。so my username is 'root' and my password is 'root',my host address is 'localhost',my Port is '3306',my database is empty,why connection filed? error is access denied for user 'root'@'localhost'(useing password:YES).
View Replies !
Error 1045 After Fresh Install
I've just installed MySQL on my home machine. I'm absolutely new to MySQL and have encountered the following error after the command mysql -u root -p: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) During installation I never set a password. I've input 'admin', 'root' and other guesses in as the password - the error is always the same. If I provide a carriage return without entering anything, the error changes slightly: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I've seen this question posted elsewhere but have been hard-pressed to understand answers provided. Can someone provide an absolute newb with some guidance?
View Replies !
Authentication Protocol :: Run-time Error'-2147467259 (800004005)
I am running winXP, mysql, vb 6.0/vbscript. when i connect through odbc it gave me the following error. Run-time error'-2147467259 (800004005) [MySQL][ODBC 3.51 Driver] Client does not support authentication protocol requested by server; consider upgrading MySQL Client When i connect this mysql with vb 6.0/vbscript in windows 98 it runs perfectly.
View Replies !
Error 1045: Access Denied For User
why each time I try to access my database using: c:mysqlininmysql -root -p and afterwards:(i.e. after inputting my at the password prompt) Enter Password: '******' I get the following: Error 1045: Access denied for user: 'ODBC@localhost'(Using password: YES) This is rather confusing to me, as I'm pretty sure that I had used the same password to pass through this particular 'door' yesterday my settings are in the following format: mysql>SET PASSWORD FOR root@localhost=PASSWORD("******"); Query OK, 0 rows affected (0.00 sec) mysql>SET PASSWORD FOR root@"%"=PASSWORD("******"); Query OK, 0 rows affected (0.00 sec) mysql>FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) Really the password that I'm using is exactly the same one I had assigned to my root few days ago after installing MySQL, PHP and APACHE successfuly, and which I have been using without problem until this afternoon.
View Replies !
Error 1045 OBDC@localhost ... Using Password YES
I posted a message earlier regarding denial of access into mysql database - "Error 1045 Acess denied to user ODBC@localhost..Using password YES". I've just came across a possible solution in mysql manual, section:A.4.2 "How to Reset a Forgotten Root Password" where it says: # Take down the mysqld server by sending a kill (not kill -9) to the mysqld # server. The pid is stored in a `.pid' file, which is normally in the MySQL # database directory: # shell> kill `cat /mysql-data-directory/hostname.pid` # You must be either the Unix root user or the same user mysqld runs as to do # this. # Restart mysqld with the --skip-grant-tables option. # Set a new password with the mysqladmin password command: This gist hasn't really helped me out, or I should perhaps say that I can't figure out the steps the above info is suggesting. I'm using windows 98 - incase OS info will be required for any analysis. Does anyone know how exactly I can restart mysqld with the---skip-grant-table option? For clarity, I'd like to mention that I did not forget my password - I simply could not acces mysql from the command prompt as usual with c:mysqlin-root -p...Enter password ****, and so on! I'm only trying this as a last resort - to get rid of the old password so as to install a new one.
View Replies !
Login Failure (error Code 1045)
I'm trying to connect to my MySQL database with OpenOffice.org Base. Unfortunately it isn't working. I created a new account with PHPMyAdmin. I just use the OOo wizard to create a connection. While testing the connection I get the error code 1045. I checked the username and password, they are correct. But I still get the message "access denied for user username@localhost.localdomain". There is no problem login in with PHP.
View Replies !
Connection Problem Error 1045 (28000)
when i give the command; memos memo # mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) or this one; memos memo # mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
View Replies !
ERROR 1045 When Testing In The Control Center
In the MySQL Control Center 0.9.4-beta, I right click the top level server name and choose the Edit option. Then I have entered a User Name and a Password in the General TAB. I then mark the option "Promt for Password" and hit the "Test" button. I get a small window where I should enter the password for User name@Host name. I enter the password and hit the OK button. Now I get the error message "ERROR 1045; Access denied for user; 'User name@Host name' (Using password: YES)" When looking in the Help menu, the Contents - F1 is not activated, so I can't get any online help. I'm just wondering why the test for the password failed and why there are no online help in the consol?
View Replies !
ERROR 1045 (28000) Access Denied
ERROR 1045 (28000) Access denied Here is my problem: I can connect to mysql using root user and password. (both with phpMyAdmin and terminal command "shell>mysql -u root -p") When I try to connect with another user, this error appear: #1045: Access denied for user 'xxx'@'localhost' (using password: YES) In the mysql table "user" I see all users with encrypted password. Here's my conf: MySQL 4.1.13a on Mac OS X Server 10.4 I've also installed phpMyAdmin 2.6.4-pl4 and php 5.0.4.
View Replies !
Mysql Error 1045 Access Denied
in dreamweaver when ever i try to connect i get the error message ysql error 1045 access denied for user root@localhost password "yes" i'm pretty sure i did this sql statement correctly to grant all use on the database Mysql>GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'mypassword';
View Replies !
Error Number. 1045 Access Denied For User
everything works right up to applying security settings, then I get the above error message and it tells me: If a personal firewall is running on your machine, please make sure you have opened the TCP port 3306 for connections. Now I am running Norton Security Online - Rogers Yahoo! Online Protection and I just have no clue how to open the tcp port 3306.
View Replies !
ERROR 1045 (28000): Access Denied For User 'root'@'localhost'
Using mySQL 4.1.22 on Linux, I got this error message suddenly this morning (it worked ok yesterday): --------- [root@server]# /usr/local/mysql/bin/mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ---------- I created a '/root/root.sql' file: -------- SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxxxx'); -------- And killed the process and restarted: -------- [root@server ~]# /usr/local/mysql/bin/mysqld_safe --init-file=/root/root.sql & [1] 2494 [root@server ~]# Starting mysqld daemon with databases from /usr/local/mysql/var -------- But I get the same error message :( In my '/usr/local/mysql/var/server.err' file there's no error message: -- 070220 07:03:40 mysqld started 070220 07:03:40 InnoDB: Started; log sequence number 0 3758734 /usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.1.22' socket: '/tmp/mysql.sock' port: 3306 Source distribution ------- What am I doing wrong?
View Replies !
Remote Access Not Working: Error 1251 Client Does Not Support Authentication Protocol Requested By Server
I'm trying to set up my MySQL database for remote access. I've never been a DB admin so this is all mostly new to me. I am binding to my public IP address, and I have created a new user with the following grant commands run from the mysql command line on the server: mysql> grant all privileges on prs_data.* to 'username'@'%' identified by 'change'; Query OK, 0 rows affected (0.00 sec) mysql> grant all privileges on prs_data.* to 'username'@'localhost' identified by 'change'; Query OK, 0 rows affected (0.01 sec) When I try to connect remotely from another host, here's what happens:
View Replies !
Mysqldump, Getting Error Error #1016, Can't Open *.ibd File
So we have a MySQL database that suddenly started reporting "can't open *.ibd file" errors on InnoDB tables in phpMyAdmin. (MyISAM are fine). To recover the data is all I want at this point -- so one suggestion I came across was to try and dump using mysqldump like this: mysqldump -u root -p mydatabase databasedump.sql Enter password: ******************* mysqldump: Got error: 1016: Can't open file: 'access.ibd' (errno: 1) when using LOCK TABLES Is there a way to run this dump so that it will export the database tables and ignore the *.ibd error? I had read that removing *.frm files might help, but our testing suggests that it isn't effective either.
View Replies !
Getting Error : ERROR 1045
At the time of installation i got some options to choose form they were 1)NO Configuration 2)For a website or so like 3)localhost 4)and one more that i dont remenber Then i clicked on the second option Next screen shows message ================================================== ==== news and mail messages (following the username and @ sign) This name will be used by other programs besides Postfix; it should be the single, full domain name(FQDN) form which mail will appear to orignate. Code:
View Replies !
Mysqldump :: ERROR 1064 (42000): You Have An Error In Your SQL
I am runnning MySQL Server v 5.0 on my local machine which has Windows XP Pro SP2 installed. I have a database "mydb" and I am trying to make use of the mysqldump command since the past 2 days (taking help from mysql.com as well as google) I have gone through the tutorial http://www.devarticles.com/c/a/MySQL...ith-MySQLDump/ but still unable to see how to make use of it. This is the command I am running in the MySQL Command Line. mysqldump --host=localhost –-user root –-password=toor mydb > sql.dump but getting the following error ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump --host=localhost --user root --password=toor mydb > sql.dump' at line 1
View Replies !
ERROR 1045: Access Denied For User: '"root"@localhost' (Using Password: YES)
I have been working on this for three days (about 16 hours) to no avail. I have root access on a dedicated server running whm/cpanel on Redhat 9. I have followed every instruction from mysql.com as well as every suggestion I've been able to find. These are the two errors I bounce between: ERROR 1045: Access denied for user: '"root"@localhost' (Using password: YES) and ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I'm out of ideas.
View Replies !
Error While Using Mysqldump
I am using Mysql 4.0.13-max-log on Solaris 2.8 If I run mysqldump like below /usr/local/mysql/bin/mysqldump -u root -pabc -d -r /usr/local/mysql/testbackup/schemadump.sql --all-databases It abort with following error /usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table 'address' (Can't open file: 'address.InnoDB'. (errno: 1)) But if I take out -u root -p option then it work fine. Also I don't have any table like address, see below Code:
View Replies !
Mysqldump Giving Error
im currently using mysql Ver 11.18 Distrib 3.23.58, for redhat-linux-gnu (i386), for some reason i have problems running mysqldump program, i have tried the followings and they all gave me error, could someone point me out? thanks. mysqldump --opt --user="g8" --password="xxx" --databases="g8" mysqldump --opt --user="g8" --password="xxx" --database="g8" mysqldump --opt --user="g8" --password="xxx" --database g8 g8 is my username and also the database name im using, and xxx is my password.
View Replies !
|
TRACKER
