List:General Discussion« Previous MessageNext Message »
From:Scott Haneda Date:May 28 2003 8:59pm
Subject:Re: upgrading to v 4.1
View as plain text  
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.

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