#1  
Old 7th December 2006, 05:42
badgerbox76 badgerbox76 is offline
Senior Member
 
Join Date: Feb 2006
Posts: 178
Thanks: 6
Thanked 1 Time in 1 Post
Unhappy I forgot my admin password :(

How can i get back my admin password or make a new one. Thanks
Reply With Quote
Sponsored Links
  #2  
Old 7th December 2006, 10:24
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,989
Thanks: 840
Thanked 5,647 Times in 4,457 Posts
Default

You can set the admin password with e.g. phpmyadmin. Login to the ISPConfig database and change the passwort column in the table sys_user where username = admin to the new password and select "md5" as encryption function.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 8th December 2006, 00:22
badgerbox76 badgerbox76 is offline
Senior Member
 
Join Date: Feb 2006
Posts: 178
Thanks: 6
Thanked 1 Time in 1 Post
Default

I have not installed phpmyadmin yet so what else can i do?
Reply With Quote
  #4  
Old 8th December 2006, 05:43
badgerbox76 badgerbox76 is offline
Senior Member
 
Join Date: Feb 2006
Posts: 178
Thanks: 6
Thanked 1 Time in 1 Post
Default

never mind i just reinstalled ispconfig.
Reply With Quote
  #5  
Old 8th December 2006, 10:58
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,989
Thanks: 840
Thanked 5,647 Times in 4,457 Posts
Default

Quote:
Originally Posted by badgerbox76
I have not installed phpmyadmin yet so what else can i do?
Use the commandline mysql client to change the password.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 21st January 2007, 08:15
MixMasterMark MixMasterMark is offline
Junior Member
 
Join Date: Jan 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default mysql command?

I get as far as
>USE ispconfigdb;
Then I
>SHOW TABLES;
I can see the sys_user but I'm not sure of the command. Can you help.

Thanks in advance. Cheers!
Reply With Quote
  #7  
Old 21st January 2007, 15:59
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,989
Thanks: 840
Thanked 5,647 Times in 4,457 Posts
 
Default

You can update the admin password with this SQL query:

Quote:
UPDATE sys_user SET passwort = md5('admin') WHERE username = 'admin';
This resets the password for the user admin to "admin"
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Installation Problem - Lost admin password Novacom Installation/Configuration 5 29th November 2006 06:44
Forgot username and password wcchandler Installation/Configuration 1 18th August 2006 11:39
Admin default password gimi Installation/Configuration 3 19th July 2006 14:47
How to install BFD (Brute Force Detection) domino Tips/Tricks/Mods 9 31st March 2006 23:40
ISPConfig admin Password linuxuser1 Installation/Configuration 2 21st October 2005 14:38


All times are GMT +2. The time now is 09:54.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.