If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > retrieving password

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-15-06, 11:15
anselme anselme is offline
Registered User
 
Join Date: Dec 2005
Posts: 266
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
Reply With Quote
  #2 (permalink)  
Old 04-15-06, 14:24
dbmab dbmab is offline
Registered User
 
Join Date: Apr 2006
Location: Denver, Co. USA
Posts: 240
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
Reply With Quote
  #3 (permalink)  
Old 04-15-06, 16:46
anselme anselme is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 04-15-06, 17:26
dbmab dbmab is offline
Registered User
 
Join Date: Apr 2006
Location: Denver, Co. USA
Posts: 240
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.
Reply With Quote
  #5 (permalink)  
Old 04-16-06, 09:55
anselme anselme is offline
Registered User
 
Join Date: Dec 2005
Posts: 266
the second one .. but a I allready regret MS SQL 2005

thank you
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On