|Message: Thank you lowhanginghoney, I tried it and it got a little further. |
Using the " to compensate for the spaces, vista came back with another error msg:
The filename, directory name, or volume label syntax is incorrect.
I right clicked on the volume in 'my computer' - (C:) and gave full control to the administrator user (me) and the Vista Administrator. Then I tried it again and - you guessed it - I got a different error msg -
090120 22:45:44 InnoDB: Operating system error number 5 in a file operation.
InnoDB: The Error means mysql does not have the access rights to the directory. It may also be you have created a subdirectory File name .\ibdata1
InnoDB: File operation call:'open'. Cannot continue operation.
So aside from my syntax error with the " when using spaces (thank you for the tip lowhanginghoney), It now feels like I am at a point where Vista will not let mysql overwrite the root user password - I need to get Vista to grant the proper rights to mysql so it can reset the password.
Thank you for your help earlier, Please advise.