Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 6th August 2008, 13:13
blesbok blesbok is offline
Junior Member
 
Join Date: Mar 2008
Posts: 11
Thanks: 3
Thanked 3 Times in 2 Posts
Question retrieve or reset ISPConfig password?

my ISPConfig Admin password's changed and i don't believe i did it this time. Seems a Fedora upgrade may have been responsible. I'd given the command: [root@billsrange ~]# yum groupinstall "KDE (K Desktop Environment)" "GNOME Desktop Environment" "X Software Development"

This messed up a few settings including my network configuration. (It did solve 1 or 2 things ) After that, my ISPConfig password didn't work and kdewalletmanager was mangled too.

Is there a way to regain access or do i have to reinstall ISPConfig all over again? Any attention given too this will be muchh appreciated.
Reply With Quote
The Following User Says Thank You to blesbok For This Useful Post:
robertoshulze2257 (24th May 2014)
Sponsored Links
  #2  
Old 6th August 2008, 13:50
blesbok blesbok is offline
Junior Member
 
Join Date: Mar 2008
Posts: 11
Thanks: 3
Thanked 3 Times in 2 Posts
Smile hooray!

relax! i found a way after following 'Similar threads' below this post.

I used:

# mysql db_ispconfig -p
Enter password: <type in the root password>
UPDATE sys_user SET passwort = md5('myNewPassword') WHERE username = 'admin';

Thanks CleberDantas
Reply With Quote
The Following 2 Users Say Thank You to blesbok For This Useful Post:
mayasl (4th February 2014), Williamsl (11th July 2014)
  #3  
Old 23rd April 2009, 20:40
CyD CyD is offline
Junior Member
 
Join Date: Feb 2009
Posts: 9
Thanks: 0
Thanked 3 Times in 2 Posts
Default

Thanks blesbok, I had a similar problem where I reset the admin password from the ISPConfig 3 interface, and afterwards couldn't log in. Your post got me back in!
Reply With Quote
The Following 2 Users Say Thank You to CyD For This Useful Post:
bowlAltetle (21st July 2014), Williamsl (26th July 2014)
  #4  
Old 24th April 2009, 22:52
Breanainn Breanainn is offline
Junior Member
 
Join Date: Apr 2009
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
Default

Thanks great post.

in 3.0.1.1 thline should be

# mysql dbispconfig -p

# mysql db_ispconfig -p

for some reason the undersocre was left out of the name in my clean new install
Reply With Quote
The Following User Says Thank You to Breanainn For This Useful Post:
Williamsl (9th July 2014)
  #5  
Old 29th March 2010, 21:44
BCHarvey BCHarvey is offline
Junior Member
 
Join Date: Dec 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

And if you forgot your mysql password use these instructions:

Linux Users:

Log on to your Linux machine as the root user. The steps involved in resetting the MySQL root password are to stop the MySQL server, restart it without the permissions active so you can log into MySQL as root without a password, set a new password, and then restart it normally. Here’s how you do it. First, stop the MySQL server:

# /etc/init.d/mysql stop

Now start the MySQL server using the --skip-grant-tables option, which will run the server without loading the permissions settings:

# mysqld_safe --skip-grant-tables &

The & option at the end makes the command you have executed run as a background process. Now log on to your MySQL server as root:

# mysql -u root

It should allow you in without prompting for a password. The following steps will set the new password:

mysql> use mysql;
mysql> update user set password=PASSWORD(”NewMySQLPassword”) where User=’root’;
mysql> flush privileges;
mysql> quit

Replace “NewMySQLPassword” with your own password. Here’s what happens here. The first line selects the MySQL configuration tables. The second line updates the value of the field “Password” for the user “root” to “NewMySQLPassword”. The third line flushes the old set of privileges and makes sure your new password is used everywhere. Now, the last step is to restart the server normally and use your new root password to log in:

# /etc/init.d/mysql stop
# /etc/init.d/mysql start
# mysql -u root -pNewMySQLPassword

Congratulations, your new MySQL root password is set and your MySQL server is ready to be used again. Remember to update all your applications to use this password if you are using it anywhere.
Reply With Quote
  #6  
Old 4th February 2014, 22:36
mayasl mayasl is offline
Junior Member
 
Join Date: Feb 2014
Posts: 2
Thanks: 1
Thanked 1 Time in 1 Post
Thumbs up

Quote:
Originally Posted by blesbok View Post
relax! i found a way after following 'Similar threads' below this post.

I used:

# mysql db_ispconfig -p
Enter password: <type in the root password>
UPDATE sys_user SET passwort = md5('myNewPassword') WHERE username = 'admin';

Thanks CleberDantas
Thank you so much man.

I had such a situation. I was helpless and thought of re-installing the entire server. Yet just thought to take a look at HTF and searched the forum.

Thank god! Got it!

You are a life saver.

And of course it's not password, it's passwort.
Reply With Quote
The Following User Says Thank You to mayasl For This Useful Post:
bowlAltetle (21st July 2014)
  #7  
Old 23rd May 2014, 09:57
peter_castr peter_castr is offline
Junior Member
 
Join Date: Mar 2014
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by BCHarvey View Post
And if you forgot your mysql password use these instructions:

Linux Users:

Log on to your Linux machine as the root user. The steps involved in resetting the MySQL root password are to stop the MySQL server, restart it without the permissions active so you can log into MySQL as root without a password, set a new password, and then restart it normally. Here’s how you do it. First, stop the MySQL server:

# /etc/init.d/mysql stop

Now start the MySQL server using the --skip-grant-tables option, which will run the server without loading the permissions settings:

# mysqld_safe --skip-grant-tables &

The & option at the end makes the command you have executed run as a background process. Now log on to your MySQL server as root:

# mysql -u root

It should allow you in without prompting for a password. The following steps will set the new password:

mysql> use mysql;
mysql> update user set password=PASSWORD(”NewMySQLPassword”) where User=’root’;
mysql> flush privileges;
mysql> quit

Replace “NewMySQLPassword” with your own password. Here’s what happens here. The first line selects the MySQL configuration tables. The second line updates the value of the field “Password” for the user “root” to “NewMySQLPassword”. The third line flushes the old set of privileges and makes sure your new password is used everywhere. Now, the last step is to restart the server normally and use your new root password to log in:

# /etc/init.d/mysql stop
# /etc/init.d/mysql start
# mysql -u root -pNewMySQLPassword

Congratulations, your new MySQL root password is set and your MySQL server is ready to be used again. Remember to update all your applications to use this password if you are using it anywhere.
Does this work properly on all MySQL versions?
__________________
Windows vps server, windows cloud hosting from a reputable hosting provider.

Last edited by peter_castr; 23rd May 2014 at 10:00.
Reply With Quote
  #8  
Old 23rd May 2014, 10:01
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,704
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
 
Default

Quote:
Originally Posted by peter_castr View Post
Does this work properly on all MySQL versions?
Yes, that works on all mysql versions.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following 2 Users Say Thank You to till For This Useful Post:
bowlAltetle (21st July 2014), Williamsl (10th July 2014)
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
Where do I change the ispconfig - mysql password. begmarz Installation/Configuration 3 25th June 2010 16:13
ISPConfig 3.0.0.5 Beta Released till General 77 23rd July 2008 12:14
ISPConfig update reset the whole database ehsan General 8 27th May 2008 09:50
Upgraded but forgot password.. ispconfig server dont start - what now? teveo1 Installation/Configuration 2 30th August 2007 09:00
ISPConfig 2.3.2-dev released till General 9 4th June 2007 10:46


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


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