mysql help google isn't working well - GoFuckYourself.com

Tony Montana · 04-12-2005, 12:54 PM

I currently don't have grant priviledges on my mysql account

I don't remember the damn root password

I need to add another user but it wont' let me

I run windows servers and it won't even let me do it from command because i don't know the root password

How can I get password for root or how can I add another user with grant options?

Tony Montana · 04-12-2005, 12:54 PM

Oh, also. I have root access to the server. I don't think passwords are stored in any certin files(if so i'm guessing their encypted 128bit+)?

Jon2 · 04-12-2005, 12:56 PM

Quote:

Originally Posted by Tony Montana

I run windows servers

You lost me at this

Jon

Babaganoosh · 04-12-2005, 12:58 PM

Check if the root password is blank. If you don't remember setting it, it may very well be blank.

Tony Montana · 04-12-2005, 01:01 PM

Quote:

Originally Posted by Babaganoosh

Check if the root password is blank. If you don't remember setting it, it may very well be blank.

I was trying no password before. Tried just putting a password with it blank, didn't work

VideoJ · 04-12-2005, 01:06 PM

shut down mysqld and restart it with the --skip-grant-tables option. that ignores the password protection, you can reset the root password and then restart it again. That's how you can fix it in unix land, windows is similar i think

04-12-2005, 12:54 PM	#1
Tony Montana Confirmed User Join Date: Jan 2005 Posts: 794	mysql help google isn't working well I currently don't have grant priviledges on my mysql account I don't remember the damn root password I need to add another user but it wont' let me I run windows servers and it won't even let me do it from command because i don't know the root password How can I get password for root or how can I add another user with grant options? __________________ I am a marketing Genius.

04-12-2005, 12:54 PM	#2
Tony Montana Confirmed User Join Date: Jan 2005 Posts: 794	Oh, also. I have root access to the server. I don't think passwords are stored in any certin files(if so i'm guessing their encypted 128bit+)? __________________ I am a marketing Genius.

04-12-2005, 12:58 PM	#4
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	Check if the root password is blank. If you don't remember setting it, it may very well be blank. __________________ I like pie.

04-12-2005, 01:06 PM	#6
VideoJ Confirmed User Join Date: Aug 2002 Location: S. Florida Posts: 750	shut down mysqld and restart it with the --skip-grant-tables option. that ignores the password protection, you can reset the root password and then restart it again. That's how you can fix it in unix land, windows is similar i think __________________ Somebody stole my damn signture...