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 4th June 2013, 06:29
dayjahone dayjahone is offline
Senior Member
 
Join Date: Jan 2007
Posts: 421
Thanks: 31
Thanked 0 Times in 0 Posts
Default Resetting admin mysql password

I tried to create a new DNS record that somehow came up as a new site. I tried to delete it, and it won't empty from my trash. So, now, I have a website that is stuck in my dns's trash. I can't create a new site with that domain because it says it is already in use. I was going to login to phpmyadmin as root and search for anything with that domain and delete it. The trouble is I need to reset my mysql password in order to do that. Please help!
Reply With Quote
Sponsored Links
  #2  
Old 4th June 2013, 09:11
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,006
Thanks: 826
Thanked 5,377 Times in 4,224 Posts
Default

Quote:
I was going to login to phpmyadmin as root and search for anything with that domain and delete it.
I wont do that if you are not 100% familar with the databse layout, it will break your database when you miss a single record which depends on one of the deleted records and the records are only connected by ID's, so you wnt find them by searching for the domain name.

A better solution for such a broken record is to change the domain name to a name that does not conflicts with existing records e.g. prepend a "broken-" to the name.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 4th June 2013, 15:44
dayjahone dayjahone is offline
Senior Member
 
Join Date: Jan 2007
Posts: 421
Thanks: 31
Thanked 0 Times in 0 Posts
Default

I tried that before, and it gave me this error:

Quote:
error_web_no_user_decrease_10error_web_no_user_dec rease_2error_web_no_domain_decrease_10error_web_no _domain_decrease_2error_web_no_database_decrease_1 0error_web_no_database_decrease_2Invalid domain name: ""
Any other ideas?
Reply With Quote
  #4  
Old 5th June 2013, 21:22
monkfish monkfish is offline
HowtoForge Supporter
 
Join Date: Mar 2013
Posts: 106
Thanks: 9
Thanked 15 Times in 14 Posts
Default

ignore me. its ispconfig 2. my bad.

Last edited by monkfish; 5th June 2013 at 21:33. Reason: whoops its ispconfig 2. deleted wrong info, my bad
Reply With Quote
  #5  
Old 5th June 2013, 22:24
dayjahone dayjahone is offline
Senior Member
 
Join Date: Jan 2007
Posts: 421
Thanks: 31
Thanked 0 Times in 0 Posts
Default

Yeah, ISPC 2. I did do all of the database repair things in the tools menu, but it didn't help.
Reply With Quote
  #6  
Old 6th June 2013, 03:30
dayjahone dayjahone is offline
Senior Member
 
Join Date: Jan 2007
Posts: 421
Thanks: 31
Thanked 0 Times in 0 Posts
 
Default

Can anyone help me delete the right thing in the database?

I did a search and found the following:

1 match inside table del_status
1 match inside table isp_isp_web

If I change the domain in phpMyAdmin, will it break everything?

Last edited by dayjahone; 6th June 2013 at 03:58.
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
help cant access anything locally or from ip jimmie Installation/Configuration 14 5th March 2013 07:58
ISPconfig3 creating user with old mysql password hashes? Justin Albstmeijer General 2 1st October 2012 13:35
Mysql root password kielb Installation/Configuration 5 4th February 2011 17:43
MySQL root password recovery irben Server Operation 1 10th December 2007 23:01
Rename folder -> create new folder equals contents of old folder BlueStream General 20 15th December 2006 03:32


All times are GMT +2. The time now is 08:07.


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