Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Unanswered: MySQL Error Very Urgent

    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

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    The default privilege doesn't allow that your should create a other user using grant statement
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •