Resetting Mysql Command Line root password

19/12/2007, 20h58

Hey guys,
I'm really pissed off atm because mysql has locked me out of the MYSQL
command line. I had a password and now it doesn't work
how do i reset it?
Thanks
Chris

19/12/2007, 22h07

On Wed, 19 Dec 2007 11:58:54 -0800 (PST), chrisdude911
<chriswillis10@gmail.com> wrote:

>Hey guys,
>I'm really pissed off atm because mysql has locked me out of the MYSQL
>command line. I had a password and now it doesn't work
>how do i reset it?

Copy the subject of this thread into a Google search
textbox. Hit Enter. Click the first link.

>Thanks
>Chris
--
( Kees
)
c[_] Eat, drink and be merry, for tomorrow they may make it illegal. (Stanislaw Gierlicki) (#38)

19/12/2007, 22h16

i've done that and i got a message saying mysql-nt.exe is not a valid
win32 application

19/12/2007, 22h43

chrisdude911 wrote:
> i've done that and i got a message saying mysql-nt.exe is not a valid
> win32 application

Did you try the MySQL manual at all?

http://dev.mysql.com/doc/refman/5.0/...ssions-windows

Jonathan

20/12/2007, 02h27

On Wed, 19 Dec 2007 11:58:54 -0800 (PST), chrisdude911
<chriswillis10@gmail.com> wrote:

>Hey guys,
>I'm really pissed off atm because mysql has locked me out of the MYSQL
>command line.

Mysql did it, eh? Feh.
--
gburnore at DataBasix dot Com
---------------------------------------------------------------------------
How you look depends on where you go.
---------------------------------------------------------------------------
Gary L. Burnore | ÝÛ³ºÝ³Þ³ºÝ³³ÝÛºÝ³Þ³ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ³ºÝ³Þ³ºÝ³³ÝÛºÝ³Þ³ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
Official .sig, Accept no substitutes. | ÝÛ³ºÝ³Þ³ºÝ³³ÝÛºÝ³Þ³ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ 0 1 7 2 3 / Ý³Þ 3 7 4 9 3 0 Û³
Black Helicopter Repair Services, Ltd.| Official Proof of Purchase
================================================== =========================

20/12/2007, 08h35

On 19 Dec, 21:43, Jonathan <jonat...@heelal.nl> wrote:
> chrisdude911 wrote:
> > i've done that and i got a message saying mysql-nt.exe is not a valid
> > win32 application
>
> Did you try the MySQL manual at all?
>
> http://dev.mysql.com/doc/refman/5.0/...sions.html#res...
>
> Jonathan

yup thats exactly what i did

20/12/2007, 10h41

On Wed, 19 Dec 2007 13:16:39 -0800 (PST), chrisdude911
<chriswillis10@gmail.com> wrote:

>i've done that

You didn't tell us before what you already tried and what
went wrong with that.

>and i got a message saying mysql-nt.exe
>is not a valid win32 application

That should be mysqld-nt.exe
--
( Kees
)
c[_] Eat, drink and be merry, for tomorrow they may make it illegal. (Stanislaw Gierlicki) (#38)

20/12/2007, 17h02

what should i do now?

20/12/2007, 23h25

On Thu, 20 Dec 2007 08:02:45 -0800 (PST), chrisdude911
<chriswillis10@gmail.com> wrote:

>what should i do now?

Follow the recipe at

http://dev.mysql.com/doc/refman/5.0/...rmissions.html
with the correct program name, not mysql-nt.exe , but
rather mysqld-nt.exe. That way you start the server in a
special way for just one time which makes it set the
password for the root user.
That should work.
--
( Kees
)
c[_] Eat, drink and be merry, for tomorrow they may make it illegal. (Stanislaw Gierlicki) (#38)

21/12/2007, 10h02

ok i've got through the first part of code

now it says

C:\Documents and Settings\Chris> --defaults-file="C:\Program
Files\MySQL
\MySQL Server 5.0\my.ini"
'--defaults-file' is not recognized as an internal or external
command,
operable program or batch file.

C:\Documents and Settings\Chris> --init-file=C:\mysql-init.txt
'--init-file' is not recognized as an internal or external command,
operable program or batch file.

i have also tired it with no spaces before default and init file same
result

!

22/12/2007, 01h00

On Fri, 21 Dec 2007 01:02:48 -0800 (PST), chrisdude911
<chriswillis10@gmail.com> wrote:

>ok i've got through the first part of code
>
>now it says
>
>
> C:\Documents and Settings\Chris> --defaults-file="C:\Program
>Files\MySQL
>\MySQL Server 5.0\my.ini"
>'--defaults-file' is not recognized as an internal or external
>command,
>operable program or batch file.
>
>C:\Documents and Settings\Chris> --init-file=C:\mysql-init.txt
>'--init-file' is not recognized as an internal or external command,
>operable program or batch file.
>
>
>i have also tired it with no spaces before default and init file same
>result
>
>!

The example on the website should be typed on one line in
the CMD window.

--
( Kees
)
c[_] If Windows is the Solution, may we have the problem back? (#198)

19/12/2007, 22h07	#2
Kees Nuyt Messages: n/a Hébergeur:	Re: Resetting Mysql Command Line root password On Wed, 19 Dec 2007 11:58:54 -0800 (PST), chrisdude911 <chriswillis10@gmail.com> wrote: >Hey guys, >I'm really pissed off atm because mysql has locked me out of the MYSQL >command line. I had a password and now it doesn't work >how do i reset it? Copy the subject of this thread into a Google search textbox. Hit Enter. Click the first link. >Thanks >Chris -- ( Kees ) c[_] Eat, drink and be merry, for tomorrow they may make it illegal. (Stanislaw Gierlicki) (#38)

19/12/2007, 22h43	#4
Jonathan Messages: n/a Hébergeur:	Re: Resetting Mysql Command Line root password chrisdude911 wrote: > i've done that and i got a message saying mysql-nt.exe is not a valid > win32 application Did you try the MySQL manual at all? http://dev.mysql.com/doc/refman/5.0/...ssions-windows Jonathan

20/12/2007, 02h27	#5
Gary L. Burnore Messages: n/a Hébergeur:	Re: Resetting Mysql Command Line root password On Wed, 19 Dec 2007 11:58:54 -0800 (PST), chrisdude911 <chriswillis10@gmail.com> wrote: >Hey guys, >I'm really pissed off atm because mysql has locked me out of the MYSQL >command line. Mysql did it, eh? Feh. -- gburnore at DataBasix dot Com --------------------------------------------------------------------------- How you look depends on where you go. --------------------------------------------------------------------------- Gary L. Burnore \| ÝÛ³ºÝ³Þ³ºÝ³³ÝÛºÝ³Þ³ºÝ³Ý³Þ³ºÝ³ÝÝÛ³ \| ÝÛ³ºÝ³Þ³ºÝ³³ÝÛºÝ³Þ³ºÝ³Ý³Þ³ºÝ³ÝÝÛ³ Official .sig, Accept no substitutes. \| ÝÛ³ºÝ³Þ³ºÝ³³ÝÛºÝ³Þ³ºÝ³Ý³Þ³ºÝ³ÝÝÛ³ \| ÝÛ 0 1 7 2 3 / Ý³Þ 3 7 4 9 3 0 Û³ Black Helicopter Repair Services, Ltd.\| Official Proof of Purchase ================================================== =========================

20/12/2007, 08h35	#6
chrisdude911 Messages: n/a Hébergeur:	Re: Resetting Mysql Command Line root password On 19 Dec, 21:43, Jonathan <jonat...@heelal.nl> wrote: > chrisdude911 wrote: > > i've done that and i got a message saying mysql-nt.exe is not a valid > > win32 application > > Did you try the MySQL manual at all? > > http://dev.mysql.com/doc/refman/5.0/...sions.html#res... > > Jonathan yup thats exactly what i did

20/12/2007, 10h41	#7
Kees Nuyt Messages: n/a Hébergeur:	Re: Resetting Mysql Command Line root password On Wed, 19 Dec 2007 13:16:39 -0800 (PST), chrisdude911 <chriswillis10@gmail.com> wrote: >i've done that You didn't tell us before what you already tried and what went wrong with that. >and i got a message saying mysql-nt.exe >is not a valid win32 application That should be mysqld-nt.exe -- ( Kees ) c[_] Eat, drink and be merry, for tomorrow they may make it illegal. (Stanislaw Gierlicki) (#38)

19/12/2007, 20h58	#1
chrisdude911 Messages: n/a Hébergeur:	Resetting Mysql Command Line root password Hey guys, I'm really pissed off atm because mysql has locked me out of the MYSQL command line. I had a password and now it doesn't work how do i reset it? Thanks Chris

19/12/2007, 22h16	#3
chrisdude911 Messages: n/a Hébergeur:	Re: Resetting Mysql Command Line root password i've done that and i got a message saying mysql-nt.exe is not a valid win32 application

20/12/2007, 17h02	#8
chrisdude911 Messages: n/a Hébergeur:	Re: Resetting Mysql Command Line root password what should i do now?

20/12/2007, 23h25	#9
Kees Nuyt Messages: n/a Hébergeur:	Re: Resetting Mysql Command Line root password On Thu, 20 Dec 2007 08:02:45 -0800 (PST), chrisdude911 <chriswillis10@gmail.com> wrote: >what should i do now? Follow the recipe at http://dev.mysql.com/doc/refman/5.0/...rmissions.html with the correct program name, not mysql-nt.exe , but rather mysqld-nt.exe. That way you start the server in a special way for just one time which makes it set the password for the root user. That should work. -- ( Kees ) c[_] Eat, drink and be merry, for tomorrow they may make it illegal. (Stanislaw Gierlicki) (#38)

21/12/2007, 10h02	#10
chrisdude911 Messages: n/a Hébergeur:	Re: Resetting Mysql Command Line root password ok i've got through the first part of code now it says C:\Documents and Settings\Chris> --defaults-file="C:\Program Files\MySQL \MySQL Server 5.0\my.ini" '--defaults-file' is not recognized as an internal or external command, operable program or batch file. C:\Documents and Settings\Chris> --init-file=C:\mysql-init.txt '--init-file' is not recognized as an internal or external command, operable program or batch file. i have also tired it with no spaces before default and init file same result !

22/12/2007, 01h00	#11
Kees Nuyt Messages: n/a Hébergeur:	Re: Resetting Mysql Command Line root password On Fri, 21 Dec 2007 01:02:48 -0800 (PST), chrisdude911 <chriswillis10@gmail.com> wrote: >ok i've got through the first part of code > >now it says > > > C:\Documents and Settings\Chris> --defaults-file="C:\Program >Files\MySQL >\MySQL Server 5.0\my.ini" >'--defaults-file' is not recognized as an internal or external >command, >operable program or batch file. > >C:\Documents and Settings\Chris> --init-file=C:\mysql-init.txt >'--init-file' is not recognized as an internal or external command, >operable program or batch file. > > >i have also tired it with no spaces before default and init file same >result > >! The example on the website should be typed on one line in the CMD window. -- ( Kees ) c[_] If Windows is the Solution, may we have the problem back? (#198)

Outils de la discussion
Afficher une version imprimable Envoyer un lien vers cette page par email