Please notice: This is an archive. Go to www.degneboligs.com for the new site!

Add Reply
Mysql problem; Help meeeeeeeee
Topic Started: Nov 23 2010, 03:24 PM (377 Views)
Operator jubiiboy
Member Avatar
:)
I have a little problem

im running my own private server sometimes for ideas for build

but i accidently deleted the folder and now i cant configure the server setting right becouse i forgot the Mysql password
How do i reset it? :psyduck:
Posted Image

Don't worry the zombie is looking for brains, you're safe!
Offline Profile Quote Post Goto Top
 
Super Operator Givo
Member Avatar
Psychic
Reinstall ?
Posted Image
Offline Profile Quote Post Goto Top
 
Admin Degnebolig
Member Avatar
Administrator
Yeah, reinstall it.
Offline Profile Quote Post Goto Top
 
U231
Member Avatar
Veteran
That doesn't work because the mysql root info is stored in registry. You can simply delete all registry entries of mysql and then reinstall.
Or you could use this command to reset the password:

Stop the mysql service from the services tab in computer management.
Open up console (administrator mode when on vista/7)

Type:UPDATE mysql.user SET Password=PASSWORD('enteryourpassword') WHERE User='root';
replace enteryourpassword with the password you would like

next type: FLUSH PRIVILEGES;

Start the mysql service again and you're good to go.
Edited by U231, Nov 23 2010, 04:22 PM.
Offline Profile Quote Post Goto Top
 
Admin Degnebolig
Member Avatar
Administrator
Didn't know that U231, thanks :)
I take it you've got an IT-related education..?
Offline Profile Quote Post Goto Top
 
U231
Member Avatar
Veteran
Yes I graduated in network engineering :P
Studying software engineering right now
Offline Profile Quote Post Goto Top
 
Operator jubiiboy
Member Avatar
:)
What console? is it the cmd console?
you open by searching run and type cmd
Edited by jubiiboy, Nov 23 2010, 04:56 PM.
Posted Image

Don't worry the zombie is looking for brains, you're safe!
Offline Profile Quote Post Goto Top
 
Admin Degnebolig
Member Avatar
Administrator
I can't quite translate the Danish educations for some reason, odd considering it's IT.
I'm an educated "webintegrator", which basically means making websites. It also touches some other subjects related to this, like Photoshop (I don't know how many hours of experience I got with that, think 2 digits), Flash and installing and maintaining servers on Linux.

I also got some odd ends from this, like how to make nice .pdf's with InDesign and some of the other niche Adobe products.. And Photography. I don't know what for, but yeah.

It's mainly used a "springboard" (If that makes sense in English) for other educations which is dependant on it.

I'm going for the datamatiker education next, which google suggest means "Computer Science". That's totally not a very generic name.
Afaik, it's something akin to software engineering.
Offline Profile Quote Post Goto Top
 
U231
Member Avatar
Veteran
It;s odd because IT is supposed to be international, but it sounds like a branch we have here splitting from software engineering. It's more a blend of media and design + some software.
I'm HORRIBLE at designing things, so I stick to typing in 1's and 0's as we call it here :P

And jubiiboy, it depends on how you have installed mysql, if console line is included, you can use cmd, else you have to use the mysql console.
Edited by U231, Nov 23 2010, 05:09 PM.
Offline Profile Quote Post Goto Top
 
Admin Degnebolig
Member Avatar
Administrator
Exactly, supposedly international..

And I know what you mean, I can't for the sake of my life think design.
All of my sites have been minimalistic with no fancy 'shopped menu icons, focusing on functionality and usability between browsers and/or media devices.
Offline Profile Quote Post Goto Top
 
Operator jubiiboy
Member Avatar
:)
I dont know where the hell i find it in Regedit
Posted Image

Don't worry the zombie is looking for brains, you're safe!
Offline Profile Quote Post Goto Top
 
U231
Member Avatar
Veteran
You want to delete every MySQL entry? just search for "mysql" and delete everything that has that in it.

Before I forget, make sure you UNINSTALL MySQL before you attempt to remove registry entries.
Actually, don't mess around in registry at all, do like I posted and reset your MySQL password using the "MySQL Command Line".
It should be part of the MySQL shortcut list in your programs folder (start -> all programs).
Edited by U231, Nov 23 2010, 06:38 PM.
Offline Profile Quote Post Goto Top
 
Operator jubiiboy
Member Avatar
:)
Only problem is that i need my pass to do that

Damn im silly its my own name thats the pass
New problem i cant start it !!!!!!!
Edited by jubiiboy, Nov 23 2010, 08:03 PM.
Posted Image

Don't worry the zombie is looking for brains, you're safe!
Offline Profile Quote Post Goto Top
 
Super Operator Givo
Member Avatar
Psychic
[windows key] + R


My "run" went walk about some day, that's a shortcut if any thing happens w/e
Posted Image
Offline Profile Quote Post Goto Top
 
Operator jubiiboy
Member Avatar
:)
No i cant start it as a windows service

when i do the setup it f!cks up

Somebody help me on teamviewer
Edited by jubiiboy, Nov 24 2010, 07:19 PM.
Posted Image

Don't worry the zombie is looking for brains, you're safe!
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Minecraft · Next Topic »
Add Reply

Theme by Sith of the ZBTZ and Outline