Migrate a old mysql password to ISPconfig 3.

Discussion in 'Installation/Configuration' started by yoplait, Dec 30, 2009.

  1. yoplait

    yoplait Member

    Hi,
    I've got a server where mysql is running and I want to keep the passwords of the mysql users. (not all the table.

    When I copy/cut this password in the new mysql server (with ISPconfig), by phpmyadmin, it doesn't work at all.

    The first are of that kind (in the mysql database and user table) : "*7DEF473825D29482CFB18DC7540DF38B26F6B416"
    and in the new one, I think, it's the same type : "*F9F02D46753B3997FBC925D2EC6E09292651D7B3"

    But, I can see, there is also, in the dbispconfig database, a table called "web_database", with a field called "database_password" where the passwords are in clear...
    Must I put the old passwords there ?
    If yes, the problem is that I don't know the old passwords "in clear" ^^ .

    Thanks for your help !

    --
    And sorry for my english, I'm french !
     
  2. yoplait

    yoplait Member

    Ok, I tried changing this both passwords with a old one (one I know, to put it in clear in the ISPconfig database), but nothing change and the password which were fixed with ISPconfig 3 is still working... So the passwords of mysql users are not stored in mysql ?

    I begin to be afraid :p .
     
  3. falko

    falko Super Moderator Howtoforge Staff

    Did you run
    Code:
    FLUSH PRIVILEGES;
    or restart MySQL after you changed the password?
     
  4. yoplait

    yoplait Member

    Ouarg ! So stupid, that was that. thanks a lot ! I didn't think about that.

    The good thing is to see I don't need to know the old passwords in clear.
    I imagine that ISPconfig use his table to generate, afterwards, the mysql password, isn't it ?

    That's good to know ! :)
     

Share This Page