| Author |
Message |
Lonni |
|
Post subject: Need a quick hand with SQL
Posted: May 05, 2007 - 10:54 PM
|
|
Joined: May 05, 2007
Posts: 4
Status: Offline
|
|
Hi everyone,
I'm having some trouble with SQL.
On a misclick I accidently deleted the root account (don't laugh too hard..) and now I'm unable to get access to SQL.
I've tried reinstalling SQL but to no avail.
Does anyone know how to fix this?
I am my own host so I have access to everything.
Thanks in advance,
Lonni |
|
|
| |
|
|
|
 |
mars |
|
Post subject: RE: Need a quick hand with SQL
Posted: May 05, 2007 - 11:33 PM
|
|
Site Admin

Joined: Aug 15, 2004
Posts: 3970
Status: Offline
|
|
| If you deleted the root account and you don't have another account with root access you will need to reinstall the server itself. |
_________________
|
| |
|
|
|
 |
Lonni |
|
Post subject: RE: Need a quick hand with SQL
Posted: May 05, 2007 - 11:49 PM
|
|
Joined: May 05, 2007
Posts: 4
Status: Offline
|
|
I uninstalled SQL and reinstalled it twice and it did nothing.
I am thinking that I must be missing some config files but I have no clue where they are at.
Unless you are telling me that I'll need to reinstall SuSE? |
|
|
| |
|
|
|
 |
mars |
|
Post subject: RE: Need a quick hand with SQL
Posted: May 06, 2007 - 03:38 AM
|
|
Site Admin

Joined: Aug 15, 2004
Posts: 3970
Status: Offline
|
|
| If you deleted the root account then yes you will have to reinstall SuSe. |
_________________
|
| |
|
|
|
 |
Lonni |
|
Post subject: RE: Need a quick hand with SQL
Posted: May 06, 2007 - 05:32 AM
|
|
Joined: May 05, 2007
Posts: 4
Status: Offline
|
|
I didn't delete the actual SuSe root account, just the SQL one.
I'm posting from the root account on SuSe atm. |
|
|
| |
|
|
|
 |
mars |
|
Post subject: RE: Need a quick hand with SQL
Posted: May 06, 2007 - 04:24 PM
|
|
Site Admin

Joined: Aug 15, 2004
Posts: 3970
Status: Offline
|
|
|
|
|
 |
Lonni |
|
Post subject: RE: Need a quick hand with SQL
Posted: May 08, 2007 - 12:39 AM
|
|
Joined: May 05, 2007
Posts: 4
Status: Offline
|
|
I just reinstalled SuSE.
A 40min reinstall/reconfig was much easier than time on top of the 4+ hours I had already invested.
Now I have a new problem though...
I installed PNphpBB2 forums and just exploring the admin options, I clicked the option to create a theme based on the pnPHP theme. After this, my forums were gone, just a blank white page. I reinstalled them but again, to no avail, gah!
Ever run into this one?  |
|
|
| |
|
|
|
 |
mars |
|
Post subject: RE: Need a quick hand with SQL
Posted: May 08, 2007 - 01:23 AM
|
|
Site Admin

Joined: Aug 15, 2004
Posts: 3970
Status: Offline
|
|
Yes, use PhpMyAdmin to reset it to PNTheme
 |
_________________
|
| |
|
|
|
 |
|
|