List:General Discussion« Previous MessageNext Message »
From:Scott Haneda Date:May 27 2003 11:26pm
Subject:mysql_fix_privilege_tables behaves odd, explain this
View as plain text  
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
Stripping HTML from db contentAndrew Hazen26 May
  • Re: Stripping HTML from db contentStefan Hinz26 May
    • Looking for more detail on upgrading to 4 from 3Scott Haneda26 May
      • RE: Looking for more detail on upgrading to 4 from 3electroteque27 May
        • Re: Looking for more detail on upgrading to 4 from 3Scott Haneda27 May
          • Re: Looking for more detail on upgrading to 4 from 3daniel27 May
            • Re: Looking for more detail on upgrading to 4 from 3Scott Haneda27 May
              • mysql_fix_privilege_tables behaves odd, explain thisScott Haneda27 May
              • mysql_fix_privilege_tables behaves odd, explain thisScott Haneda27 May
        • Frustrations with upgrading to 4 from 3, and a lack of notes and docsScott Haneda27 May