AHHH! I bet that is why I was having such a horrible time last night trying to upgrade! I finally said fsck it and reverted back to 3.23.55...
I don't use a root password on localhost... Now I'll try your suggestions and see if it works. *sigh* *crosses fingers* > -----Original Message----- > From: Scott Haneda [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 28, 2003 1:59 PM > To: MySql > Subject: Re: upgrading to v 4.1 > > > on 05/28/2003 1:51 PM, Ted Rogers at [EMAIL PROTECTED] wrote: > > > Is it recommended that I upgrade MySQL 3.23.53 to 4.1.x? > Are then any > > special notes I might remember when doing so? > > (Mac OS X Server 10.2.6) > > > > Ted > > Yeah, I posted this and no reply, but you need to do this > > Subject : mysql_fix_privilege_tables behaves odd, explain this > Well this is very interesting > > At the start of the script they have > root_password="$1" > host="localhost" > user="root" > > I added in just below the above > echo "----------------------------------------------------------" > echo $root_password > echo "----------------------------------------------------------" > > Then if you try > sh mysql_fix_privilege_tables -p somepassword > Guess what you get... > ---------------------------------------------------------- > -p somepassword > ---------------------------------------------------------- > > So it seems the script takes the whole argument... > > sh mysql_fix_privilege_tables my_root_pass > Works fine > > Is this standard behavior? > The Script says > echo "If you get 'Access denied' errors, you should run this > script again" > echo "and give the MySQL root user password as an argument!" > > Does not really tell you there is some special way to do it. > What is the > heck is $1 anyway? And why is it a literally quoted value? > > ------------------------------------------------------------- > Scott Haneda Tel: 415.898.2602 > http://www.newgeo.com Fax: 313.557.5052 > [EMAIL PROTECTED] Novato, CA U.S.A. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]