List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:May 28 2003 10:09pm
Subject:RE: upgrading to v 4.1
View as plain text  
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:lists@stripped] 
> 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 trogers@stripped 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
> scott@stripped                            Novato, CA U.S.A.
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?> unsub=daevid@stripped
> 

Thread
upgrading to v 4.1Ted Rogers28 May
  • Re: upgrading to v 4.1Scott Haneda28 May
    • mysqlhotcopy script problemstu zimny28 May
    • RE: upgrading to v 4.1Daevid Vincent29 May
  • RE: upgrading to v 4.1Kieran Kelleher29 May
  • Re: upgrading to v 4.1LS29 May
    • Re: upgrading to v 4.1Jocelyn Fournier29 May
      • Re: upgrading to v 4.1LS29 May
    • timestamps and time zones2Hosts.com29 May
      • Re: timestamps and time zonesEgor Egorov29 May
        • RE: timestamps and time zonesAndrew Hazen29 May
    • Re: upgrading to v 4.1Jeremy Zawodny29 May
      • Re: upgrading to v 4.1LS30 May