Yes I had the same problem... instalation went well.. (under win2k) I could connect via command line but if I wannted to perform any operation... I received the
error:
<![CDATA[
'Access denied for user: '@myservername' to database 'db''
]]>
I didnt know what was it.. thx to your posts I know now that u have to use "user -u root" (in my case the -h servername) is not nessasery.. after all the bug was related to the empty user name. Anyways u should do it like that eg.:
<![CDATA[
mysqladmin -u root create db01
]]>
This way it works fine... to ease my life I prepared bat file... and now I just have to call it like that , eg.
<![CDATA[
do.bat mysqladmin drop db01
]]>
The bat file looks like that...
<![CDATA[
%1 -u root %2
]]>
First parameter after do.bat is in the %1 and the second is in the %2 variable... If u ommit the -p parameter u will not be promted to enter password (if password is not set)
