Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2005
    Posts
    266

    Unanswered: retrieving password

    I have installed MySql 5
    and now when i try to run MySql Administrator 1.1.9 I have no idea at all what is Server Host (localhost maybe !) Username and Pasword

    where can I find this informations ?

    thank you

  2. #2
    Join Date
    Apr 2006
    Location
    Denver, Co. USA
    Posts
    242
    At the end of the installation procedure, you should have been given the opportunity to run a "MySQL Server Instance Config Wizard." This sets up the mysql server to run and has a page where the password is created for root access.

    If you did not run the config wizard at the time of installation, there is a shortcut to it on your start menu.

    Once you have the server instance configured and the mysql server software is running, you will be able to connect using the mysql administrator.

    If you are running the mysql administrator on the same computer with the mysql server software (which is the likely case), the information you enter will be -
    Server Host: localhost
    Username: root
    Password: the root password you entered in the config wizard

  3. #3
    Join Date
    Dec 2005
    Posts
    266
    yes but I have forgotten the given password and I want to retrieve it
    it is the only subject of that thread

    thanks

  4. #4
    Join Date
    Apr 2006
    Location
    Denver, Co. USA
    Posts
    242
    You forgot your password! MySql saves passwords using a one way encryption hash. There is no way to get it to tell you what it is.

    You have two choices -

    1) Try various passwords until you find the one that works.

    2) Use the MySQL Server Instance Config Wizard to remove the current instance and then create a new one.

  5. #5
    Join Date
    Dec 2005
    Posts
    266
    the second one .. but a I allready regret MS SQL 2005

    thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •