[Help]MySQL

[-$karos-]

Hello there.

 

I have done this countless times and I never had any error.

 

Until today...

 

 

I was bored and thought experementing in my own server would be fun...

So i found MySQL and Navicat to install them... But i had already installed MySQL...

 

It had a curent password gasp but i don't remember the password i put xD

 

So... i deleted it from Control Panel Uninstall thingy..

I deleted some files that stayed from it at Program Files and Rebooted the computer.

After that I run the install exe and still it has that curent password!

 

I give it a shot but it gets stuck at "Apply Security Settings"

 

I have never got that problem ffs...

Any Ideas?

[DrHouse__]

Check my last post in this thread http://www.maxcheaters.com/forum/index.php?topic=78827.0

 

There are problems in mysql win installer, paths are wrong

[ExTrEmEDwarf]

C:\Program Files\MySQL\MySQL Server 5.0\bin

 

 

then open MySQLInstanceConfig and re-configure it

[-$karos-]

It is 5.1 btw...

 

And I ran CC cleaner.

 

I'll retry with my method and if it won't work ill try it.

[ExTrEmEDwarf]

If u uninstall mysql there the configs are not deleted..u should delete them before re-installing it.

[-$karos-]

If u uninstall mysql there the configs are not deleted..u should delete them before re-installing it.

 

did that.

 

But still it has the "curent password" option... wtf?

I have put a random password and i don't remember it.. so it won't let me connect now :@

 

I guess...

 

________________________________________________________________________________________________________________

 

Check my last post in this thread http://www.maxcheaters.com/forum/index.php?topic=78827.0

 

There are problems in mysql win installer, paths are wrong

 

I don't have that error.

[WizZy™]

set password = password("yournewpassword");

have fun.

[-$karos-]

set password = password("yournewpassword");

have fun.

Uhm... yeah...

 

 

I had a password that i don't remember and it is required.

 

By reading the replies you understand that I have put a password and now it is saved and i don't remember it.

Even if I uninstall it the pwd still stays.It is not as the usual install just put the password and ur done IT REQUIRES THE OLD to change it. (WHICH I DON'T KNOW THE OLD ONE)

 

How do i remove the old password completely so it wont have the "set current password" gasp?

 

(It is not that simple Leeroy)

[DrHouse__]

uhmm sorry I missunderstood your problem ;)

 

So you forgot root password right? Ok, here is a little trick:

 

1) Stop your mysql service

2) Start the server with --skip-grant-tables

3) now  you can log in without password (user root and no pass). Set new root password

4) you are done =)

 

 

EDIT: Just in case you dont understand my explanation, I found a (actually tons of them) tutorial(s) for you in google (keywords = "mysql forgotten root password")

http://www.howtoforge.com/reset-forgotten-mysql-root-password

[-$karos-]

uhmm sorry I missunderstood your problem ;)

 

So you forgot root password right? Ok, here is a little trick:

 

1) Stop your mysql service

2) Start the server with --skip-grant-tables

3) now  you can log in without password (user root and no pass). Set new root password

4) you are done =)

 

 

EDIT: Just in case you dont understand my explanation, I found a (actually tons of them) tutorial(s) for you in google (keywords = "mysql forgotten root password")

http://www.howtoforge.com/reset-forgotten-mysql-root-password

 

Thanks i'll try them. (I'm at the local net now so..)

Btw Google doesn't like me.

[WizZy™]

set password = password("yournewpassword");

execute this in navicat's console for example... it doesnt need the old password ,you made me test it.

[-$karos-]

It has 3 gasps not 2...

 

I know what you mean... i tested on internet cafe and works..

 

but something is wrong at my house :-/

[WizZy™]

Well this is the only way to change the passw.

It works for sure..

[-$karos-]

Well this is the only way to change the passw.

It works for sure..

 

Well... i kinda f***ed it up :P

 

So i uninstalled it, cleaned registry and still it has the curent password gasp

I don't know how to fix it so... I'll do it the easy way..

 

Downloaded mysql 5.0... it will do the job.. thanks anyway :)

[WizZy™]

It wont do the job ,it will be same :D

When you uninstall SQL ,some files aren't deleted..

check mysql folder :]

[-$karos-]

It wont do the job ,it will be same :D

When you uninstall SQL ,some files aren't deleted..

check mysql folder :]

 

Sorry to disappoint you but it did the job =]