zypher11 wrote:no clue what that means heh.
Even if you didn't know what the specific arguments did, you should at least be able to read that error message and understand the gist of what it's saying.
"Option 'foo' shouldn't be used; we'd rather you use option 'bar'."
They're honestly being fairly transparent. The argument "--default-character-set" is quite obvious too, assuming you've worked with a DB schema before; it's the character set that the server will choose automatically when a new database/table/column is created that doesn't explicitly state which character set should be used.
zypher11 wrote:Anyways like i said, followed all the different walk throughs word for word and every file path was perfectly correct yet i continue to get the same error
Well wait a minute - you never told us about any error you got. All you showed us above is a warning message... from all appearances, whatever command you tried to execute appears to have succeeded without error.
Speaking of the command, can you show us the exact command you used to invoke mysqld from the CLI?
zypher11 wrote:It makes absolutely no sense why uninstalling it wouldnt remove the password.
Sure it does... uninstalling the server simply removes the daemon/software from your computer. You could then easily install it elsewhere, copy over the data folder, and you're instantly online in a new location. Uninstalling the server itself has no bearing on adding/removing/editing the GRANT tables, nor should it - I don't want any uninstaller nuking my server configuration... I just want it to uninstall the server.
If you need to change the GRANT tables from a failed restore and/or lost password... well, that's what the MySQL documentation is for. :p
zypher11 wrote:Instead of giving us 10 different ways of resetting it, all of which don't work.
The developers provide only one way of resetting the root password, with three different variations depending upon which one is most applicable to you; all three can be found in the MySQL manual page you linked to in your first post.
As I said above, I attempted the step-by-step procedure offered by the guide on my Windows XP workstation and it worked as expected (which reminds me - I need to go and add my root password back! 😛). There's most likely a typo in the command you're executing or the file you created that you're not seeing (hence why I asked for the exact command above).
zypher11 wrote:Im not putting "--default-character-set" anywhere in the command so only assumption is that its talking about --defaults-file part of the cmd
I'd have to see the exact command you executed, but it's quite possible that mysqld is referring to a definition in your my.ini file that it found, and it simply meant that the option "default-character-set" (wherever you're defining it - be it on the CLI or in your my.ini file) is depreciated.
Do you see any lines beginning with "default-character-set=" in your my.ini file (hint: check about 15-20 lines under the "[mysqld]" section header)? If so, that's what's causing the warning.
