resetting root password...

[orange]

hi guys,
one of the procedures to reset the ROOT password in the Reference Manual is to create an 'init file'.
The procedure says to save it with any name. What is the reason behind using ~/ at the start of the file name? Where is this file suppose to go?
When I try 'mysqld_safe --init-file=myown-init' it keeps telling me it can't find the file? how do I change 'USING password NO' to 'USING PASSWORD YES'

Thanx, -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

"~" is UNIX/Linux shell shorthand for "my home directory". "~/mysql-init" is the same as "$HOME/mysql-init" except the former works even if you unset the $HOME shell variable.

You need to give the full location of that init file.

"USING PASSWORD: YES" means you specified a password when trying to connect. This is done with the "-p" option to most MySQL commands.

You can use "-pxxxx" (note there must be no space in that) or "--password=xxxx", or just "-p" and then type the password when it prompts you. Then it'll change to "USING PASSWORD: YES". Of course, you only see the error if you give the _wrong_ password. :-)

If you just hit return after being prompted for a password, it still counts as "USING PASSWORD: NO". -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --