Hit the right button on the wrong moment... It should be: Leaving a space between -u (=user) and the user_name should not be a problem it is if you supply a password on the commandline in the form of -p'your_password' :(
> -----Oorspronkelijk bericht----- > Van: B. van Ouwerkerk [mailto:[EMAIL PROTECTED] > Verzonden: zondag 23 november 2003 14:11 > Aan: 'Mikael Fridh'; [EMAIL PROTECTED]; 'Nilesh Avalani' > Onderwerp: RE: restoring mysqldump ??? > > > mysql -u user_name -p reporter < dumpfile > > Leaving a space between -u (=user) and the user_name should > not be a problem it is if you supply a password on the > commandline -p'your_password' but -u user_name > > > > B. > > > -----Oorspronkelijk bericht----- > > Van: Mikael Fridh [mailto:[EMAIL PROTECTED] > > Verzonden: zondag 23 november 2003 13:48 > > Aan: [EMAIL PROTECTED]; Nilesh Avalani > > Onderwerp: Re: restoring mysqldump ??? > > > > > > > but when i try to run : > > > % mysql -u root reporter < reporter-dump-Sat.sql > > > > mysql -uroot -p reporter < dumpfile > > > > > it says : > > > ERROR 1044: Access denied for user: '@localhost' to database > > > 'reporter'. > > > > think it's because of that extra space between the '-u' and > > 'root' you also need the -p parameter so you can enter your > > root password. > > > > Mike > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
