#11  
Old 23rd August 2005, 01:28
m u r m u r is offline
Senior Member
 
Join Date: Jul 2005
Posts: 152
Thanks: 13
Thanked 1 Time in 1 Post
Send a message via AIM to m u r Send a message via MSN to m u r
Default

Yes! Thanks!!!!!!
Reply With Quote
Sponsored Links
  #12  
Old 23rd August 2005, 01:28
m u r m u r is offline
Senior Member
 
Join Date: Jul 2005
Posts: 152
Thanks: 13
Thanked 1 Time in 1 Post
Send a message via AIM to m u r Send a message via MSN to m u r
Default

Yes!!! Thanks!!!
Reply With Quote
  #13  
Old 16th February 2007, 01:16
AdamZtech AdamZtech is offline
Junior Member
 
Join Date: Feb 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Reset ISPConfig Admin Password from Command Line

Quote:
Originally Posted by m u r
Is there any way to retrieve or reset the admin password for ISPConfig? Am I screwed?

I'm almost positive I'm entering the right password, but ISPConfig won't let me in. I can still login on the machine as root.
I had a similar problem. I used a random password generator that created a password with "/" in it, and I couldn't log in after I changed my admin password. I read this thread, and thought that it was too much trouble to setup phpMyAdmin, so after a little research, I figured a way to reset the admin password through the command line:

> mysql -h localhost -u root -p
> use ispconfigdb
> update sys_user set passwort = md5('admin') where username = 'admin';
> quit

First line logs you into mysql from the command line with your mysql root password. The third line resets the the admin user password to "admin".
Reply With Quote
  #14  
Old 16th February 2007, 08:49
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

Quote:
> use ispconfigdb
> update sys_user set passwort = md5('admin') where username = 'admin';
May I ask to copy/paste the actual commands you used? As this syntax can never work. It should be:
Code:
use ispconfigdb;
update sys_user set password = md5('admin') where username = 'admin';
Reply With Quote
  #15  
Old 16th February 2007, 09:07
AdamZtech AdamZtech is offline
Junior Member
 
Join Date: Feb 2007
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sorry, but the commands are long gone from my screen and buffer.

I'm sure your corrections are right on, though the "update..." command was a copy and paste from a previous post in this thread.
Reply With Quote
  #16  
Old 16th February 2007, 18:39
falko falko is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,726 Times in 2,565 Posts
Default

Quote:
Originally Posted by martinfst
May I ask to copy/paste the actual commands you used? As this syntax can never work. It should be:
Code:
use ispconfigdb;
update sys_user set password = md5('admin') where username = 'admin';
Actually, passwort is correct, as password is a reserved word in MySQL.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #17  
Old 16th February 2007, 21:35
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
 
Default

Apologies, I had mixed up the mysqladmin password change command and the change of an item in an application specific table.
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
root password for Knoppix? kermit Technical 3 8th May 2007 00:06
Forgot root password leno Technical 3 8th October 2005 23:40
Installing on a x86_64 based system? hkaiser Installation/Configuration 23 20th August 2005 20:51
Uninstalled/Reinstalled now FTP users are not added adamluz Installation/Configuration 2 18th August 2005 23:47
ProFTPD Logins and Authentication pete General 9 14th August 2005 23:24


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


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