exporting tables with password fields

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Matt
    #1

    exporting tables with password fields

    I am making a copy of a dB on my local machine so I can work on the
    interface. But the username/password combination -- which works on the
    "live" site -- doesn't work on my local machine. Is there something
    about the PASSWORD() fxn in mysql that is specific to the installation?
    Tags: None
    • Matt
      #2
      more info

      Matt wrote:[color=blue]
      > I am making a copy of a dB on my local machine so I can work on the
      > interface. But the username/password combination -- which works on the
      > "live" site -- doesn't work on my local machine. Is there something
      > about the PASSWORD() fxn in mysql that is specific to the installation?[/color]

      both are using mysql 4.1.12

        Comment

        • Gordon Burditt
          #3
          Re: exporting tables with password fields

          >I am making a copy of a dB on my local machine so I can work on the[color=blue]
          >interface. But the username/password combination -- which works on the
          >"live" site -- doesn't work on my local machine. Is there something
          >about the PASSWORD() fxn in mysql that is specific to the installation?[/color]

          Just copying the dB doesn't copy permissions to use it. Did
          you GRANT appropriate permissions? PASSWORD() changed a couple of
          times in different versions but if you're using the same version on
          both it shouldn't matter. What's the length of the result of PASSWORD()
          on each system? As I recall two variants of the length are 16 and 41.
          Try SELECT PASSWORD('foo') on both systems.

          Gordon L. Burditt

            Comment

            • Matt
              #4
              Re: exporting tables with password fields

              Gordon Burditt wrote:[color=blue][color=green]
              >>I am making a copy of a dB on my local machine so I can work on the
              >>interface. But the username/password combination -- which works on the
              >>"live" site -- doesn't work on my local machine. Is there something
              >>about the PASSWORD() fxn in mysql that is specific to the installation?[/color]
              >
              >
              > Just copying the dB doesn't copy permissions to use it. Did
              > you GRANT appropriate permissions? PASSWORD() changed a couple of
              > times in different versions but if you're using the same version on
              > both it shouldn't matter. What's the length of the result of PASSWORD()
              > on each system? As I recall two variants of the length are 16 and 41.
              > Try SELECT PASSWORD('foo') on both systems.
              >
              > Gordon L. Burditt[/color]

              dB permissions were good -- i've done all that before. Got it fixed and
              you were right; it was to do with the hash algorithm changeover in
              4.11. My prod. server had the system var old_passwords=O n but not my local.

              So anyone else who runs into this: it's not enough that both
              installations use 4.1.11 (or .12 or whatev) -- use SHOW VARIABLES like
              'old_%' to see that setting.

                Comment

                Previous template Next
                Working...