HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   General (http://www.howtoforge.com/forums/forumdisplay.php?f=15)
-   -   Resetting admin mysql password (http://www.howtoforge.com/forums/showthread.php?t=62076)

dayjahone 4th June 2013 06:29

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!

till 4th June 2013 09:11

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.

dayjahone 4th June 2013 15:44

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?

monkfish 5th June 2013 21:22

ignore me. its ispconfig 2. my bad.

dayjahone 5th June 2013 22:24

Yeah, ISPC 2. I did do all of the database repair things in the tools menu, but it didn't help.

dayjahone 6th June 2013 03:30

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?


All times are GMT +2. The time now is 14:26.

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