i believe if you simply add it to the appropriate table (user) and set the appropriate privlidges - then flush privliges and tables - then try the dump - note: i didn't actually try this on my database, but it *should* work. otherwise, i bet if you muck around in the archives for awhile you will find a better answer than i can give you. http://www.mysql.com/documentation/searchlists.html good luck! jd -----Original Message----- From: tclug-list-admin at mn-linux.org [mailto:tclug-list-admin at mn-linux.org]On Behalf Of Raymond Norton Sent: Thursday, January 17, 2002 11:11 AM To: tclug-list at mn-linux.org Subject: [TCLUG] mysqldump mysqladmin I am messing with more MySql, trying to dump tables to .txt files. I am getting permission denied within this: mysqldump -uroot -p Meet_A_Geek Customers >MeetAGeek_Customers.txt I get the same without specifying the user. I was messing with mysqladmin and getting the same type of problems, when I discovered the password is blank, nothing there. It gives me the info I need without any password. I looked up how to change it, but all I can find is info on changing it from one password to another. I am guessing the problems are related. Can I get any pointers on how to set the password and get a successful dump? Raymond -------------- next part -------------- An HTML attachment was scrubbed... URL: http://shadowknight.real-time.com/pipermail/tclug-list/attachments/20020117/668c6f73/attachment.html