If you have 'root' privileges to the server itself, then shutdown mysql and restart it with --skip-grant-tables. This should allow you to log in as root without being prompted for a password.
Regards, Bhavin. ----- Original Message ----- From: "Norris, Joseph" <[EMAIL PROTECTED]> To: "'Kevin Bednar'" <[EMAIL PROTECTED]>; "Norris, Joseph" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 08, 2002 9:56 AM Subject: RE: Using unix mysql db files under windows mysql > Do you have any user for the db? If so you might have the permissions to do > the dump. Its worth a try. > > > -----Original Message----- > From: Kevin Bednar [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 08, 2002 9:50 AM > To: 'Norris, Joseph'; [EMAIL PROTECTED] > Subject: RE: Using unix mysql db files under windows mysql > > > I don't have the root login password for mysql Joe. This was a machine > we inhertited and has 1 site on it. This is why we want to move > everything off of it. Can you do a mysqldump without the root mysql > login? > > Kevin Bednar > Network Engineer > Dedicated Access Support > 1-888-TELLURIAN > (973) 300-9211 Ext. 126 > Tellurian Networks - Le Package Totale > http://www.tellurian.net > > > > -----Original Message----- > From: Norris, Joseph [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 08, 2002 12:48 PM > To: 'Kevin Bednar'; [EMAIL PROTECTED] > Subject: RE: Using unix mysql db files under windows mysql > > > You can not do mysqldump on unix, rebuild on windows? > > > -----Original Message----- > From: Kevin Bednar [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 08, 2002 9:42 AM > To: [EMAIL PROTECTED] > Subject: Using unix mysql db files under windows mysql > > > Hello all, > I have access to the database files themselves from a linux > installation of mysql, but not the root login priveleges under mysql > itself. I know that if I could connect via mysql itself I could just > copy the databases from one server to another but I cant. I copied the > db files over via ftp onto a windows server running mysql and it sees > the 2 databases but if I try to actually access the colums, etc. I get > errors. I also noticed the file extensions on the unix files are > different, except for the .frm files. Is there an import tool or > something else I can run to import these files into the windows version > of mysql so that I can start using them again? The web site these are > used for is being migrated off unix onto windows. TIA! > > Kevin Bednar > Network Engineer > Dedicated Access Support > 1-888-TELLURIAN > (973) 300-9211 Ext. 126 > Tellurian Networks - Le Package Totale > http://www.tellurian.net > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
