Unanswered: Problems creating a database on Windows XP Home Edition
I have installed the latest available version of MySQL available for Windows (NT,ME,XP, etc), it has all installed fine as far as I can see, the MySQL Administrator has run ok, i set up the username and password as expected, all seems to be ok. I am running on a local machine, thus the binding IP address is 127.0.0.1, all connections seem to be ok.
However, when I go into mysql at command prompt, and use the following command "create database snort;", i get a message stating I do not have the required privileges and access is denied, which is very starnge as there is only one account set up under my machine which is mine that is operating at administrator level
Does anyone have any incite into why this is happenng?