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
See Related Forum Messages: Follow the Links Below to View Complete Thread
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?
Mysqldump: Got Error: 1045: Access Denied For User: 'bonosa@localhost'
On windows I had no problem doing this: mysqldump --opt pmadb1 > testfile; but on linux I get: fromB> mysqldump --opt pmadb1 > may16 mysqldump: Got error: 1045: Access denied for user: 'bonosa@localhost' (Using password: NO) when trying to connect What do I need to do here to get it to work?
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.
Error 1045
i have a problem with mysql database. On a linux machine at the first connect to database i have deleted from users "@linux" and "@localhost" so when i try to connect from my machine to my database i receive follow message : mysql error 1045: access denied for root@localhost I have try to reinstall mysql packages my problem persist!
Error 1045
i'm running off vista and downloaded mysql and when i use the mysql browser and put in localhost,port 3306 and administrator or root or my name it gives me a 1045 error ... how do i configure the connection step by step so it could work.
ERROR 1045
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?
Error 1045
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?
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.
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.
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.
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,
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.
Error: 1045 (28000)
I have just installed mysql 4.1.14 on windows xp professional I am trying to test it by using the mysql test command from with the command prompt. However I get the following message: ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)
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 ?
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?
Error 1045 For New XP Install
I'm unable to make a connection using MySQL Administrator with a brand new install for xp. I get an access denied to "ODBC@localhost". I tried pinging and it pings. I tried copying the my.ini file to Windows. And I see that this is a common issue for newbie's like myself. I've used Mysql before but have never installed it.
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.
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.
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?
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..?
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 ?
ERROR 1045: Access Denied For User
Situation: One common MySQL database server on SuSE 9.1 with all updates. Uses 'rinetd'. Has entries for the appropriate IP addresses of all servers. NOTE: If the appropirate entries are NOT in rinetd, the error message is: ERROR 2013: Lost connection to MySQL server during query Using the exact same query from prompt on several clients (some are SuSE 9.1, some are older Redhat systems, but none are configured identically). Example (upper case indicates private stuff): mysql -uUSER -pPASSWORD -h MYSQLSERVER.TLD.COM -e "select * from sometable" DATABASENAME returns correct results on all but one server. On that one problemmatic server (SuSE 9.1), the result is: ERROR 1045: Access denied for user: 'USER@localhost' (Using password: YES) Has anyone had a similar problem? Ideas for the soluton? I feel like there is a missing configuration option on the problematic client, or a missing library, or something, but have not been able to isolate anything. Yes, the -u and -p are the SAME from each client (this is all inside the firewall), so I don't see how this can be a user or privileges problem. Anyway, I've done 'flush privileges' and I've restarted the database server (/etc/init.d/mysqld restart), even the server has rebooted since
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?
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.
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.
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.
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.
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';
MySQL Error 1045 Not Connecting Useing Password:yes
i have just finished setting up my ragnarok files and database but now i cant connect them because it says i get the right pass word but it fails on the applying security settings and i get: Error Nr. 1045 access denied for user 'root'@'localhost'(using password: Yes). i used root as the password but i just cant seem to get a connection.
ERROR 1045 (28000): Access Denied For User
All I want to do is load a simple txt file to a database. I use the follwoign command: mysql> LOAD DATA INFILE "30000lines.txt" INTO TABLE mytable; and i get the following error: ERROR 1045 (28000): Access denied for user 'userme'@'%' (using password: YES) When I do a grant for teh tabel i get the following message: Code:
ERROR 1251: Client Does Not Support Authentication Protocol Requested
I have a problem with a MySQL environment. - One server (Windows) - Two instances of mysql (4.0.27 & 5.x.x) - Each instance are running as a service with a different port number (tcp 3307/3306) - Both services are set up with their own parameter files, so they point to the correct binary and data directory When I try to log on through the console against the MySQL 5 database by starting c:program filesmysql5inmysql, then everything is working as it should. If I try to do the same against the Mysql 4 database, it returns an error that the client does not support the authentication protocol requested.
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: Ɗ.1.22' socket: '/tmp/mysql.sock' port: 3306 Source distribution -------
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?
ERROR 1045 (28000): Access Denied For User 'root'@'localhost'
I'm attempting to install Bugzilla. I'm stuck because the last two modules that are required in Perl won't run. The apparent reason is that the root login fails. I tried it manually to, and here's what I get: [root@10 bugzilla-2.18.3]# mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I created the database and login via a Perl module called template: /opt/ActivePerl-5.8/bin/perl-static -MCPAN -e 'install "Template"'
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?
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.
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:
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:
Mysqldump Error
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.
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:
Mysqldump Error
I want to take dump of a single table (TYPE = InnoDB) using mysqldump here is the command i used Code: mysqldump -utestuser -p db_name table1 table2 -w 'table1.fid=table2.id' > backup.sql the error i get is Code: mysqldump: Got error: 1109: Unknown table 'table2' in where clause when retrieving data from server
Mysqldump Error
please give me solution for this.. i am stuck in the error...i have executed the command like this: mysqldump --add-drop-table -h hostname -u username -p password --databases dbname > backup.sql but it is not working... giving me error that "please check statement".
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.
Error With Tables Using Mysqldump
I'm running mysql 4. I create backups of my database using mysqldump to create sql files. Today i tried to load one of my backups to a test database and i got a syntax error. I believe the problem is in the create statements of the sql file, for example i have a create query that contains an index (below): Create Table computerleads ( company varchar(100) not null default '', telephone varchar(20) not null default '', recno int(9) not null auto_increment, Key index (recno) ) Type=MyISAM; I think the error is the word KEY when creating the index. When i remove it the query works. Why is this key word put in? Is it a bug in the program ? There are many tables and it would take a very long time to edit each table in the sql file.
Transfer Mysqldump 3.23 -> 4.1 (error)
I have a mysqldump from my old server who's using MySQL 3.23 (FC2). I want to integrate it in my new server who's using MySQL 4.0 (FC4). The command mysql -uuser -p < dump.sql gives the following errors: ERROR 1064 (42000) at line 231: 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 'column int(10) unsigned NOT NULL default '0', position varchar(20) NOT NULL de' at line 7 It seems a version incompatibility. I checked the manual but i did find nothing. Is there a posibility for converting?
Mysqldump Recurring Error
I use mysqldump to backup the contents of our mysql databases. For several evenings now, I have been encountering the same error whilst running the dumps. The scenario is that three of my four databases on this installation successfully dump. The fourth database dump consistently errors out on row 244,316 of its 324,653 total rows (after successfully dumping 81 previous tables), with this diagnostic:CODEmysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `dd_data_elements` at row: 244316 Error: Backup of schema <next schema name> was not successful (0 seconds): mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when trying to connect
MySqlDump Vs Delphi Error
The following Delphi code is not working. If I copy the values from ProgName and PParams and put them in a Dos windows they work fine......
Mysqldump: Got Error: 1044
i cannot use mysqldump ! I get thiss error message ! mysqldump: Got error: 1044: Access denied for user **** when using LOCK TABLES I am using this command : mysqldump -u*** -h**** -p*** db > dardaniablu.sql
ERROR 1064 When Attempting Mysqldump
I have installed mysql version 5 on my windows xp machine. I have used the mysql data migration tool to import/migrate a database from ms access. I am logged into localhost as root without a password. The database name is: 331539_conndemo, it has two tables. At the command line I can mysql> show databases; (return) and I can view the list of databases on this server. I can use the database, and use select statements to return data to the command line. It does exist, and I am logged on to the server! I want to do a dump of this database, so that I can import it to a webserver thru php admin. I do not have command line access to the webserver. I can not make mysqldump work correctly. Here is how it looks on my screen, including the prompt: mysql> mysqldump -u root -p 331539_conndemo > 331539_conndemo.sql ; (return) I get this error 1064 (420000) you have an error in your syntax, check the manual...blah blah...but there is no other useful information. I have also tried it without a space between .sql and ; so that the line looks like this: mysql> mysqldump -u root -p 331539_conndemo > 331539_conndemo.sql; (return) (same error) I have also tried simpler methods: mysql> mysqldump 331539_conndemo > 331539_conndemo.sql; (return) and mysql> mysqldump 331539_conndemo; (return) all give the same error.
|
TRACKER
