Skip to content

[Help]MySQL

Featured Replies

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?

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

 

 

then open MySQLInstanceConfig and re-configure it

  • Author

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.

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

  • Author

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.

  • Author

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)

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

  • Author

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.

set password = password("yournewpassword");

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

  • Author

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 :-/

  • Author

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 :)

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

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

check mysql folder :]

Guest
This topic is now closed to further replies.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.