had installed mySQL database in my Windows XP machine. When I tried to create a database I am getting the following error. I have my.ini file in my \windows directory. The userid and password are blank. I tried with default user id ODBC and local host my computer name but does not work. How to change the privileges and fix the problem ?

Can someone inform me ASAP ?


==============Error message ======================
C:\mysql\bin>mysqladmin create database store
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: ''@'localhost' to database 'database''
============================================

Krishna

The default privilege doesn't allow that your should create a other user using grant statement