Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2009
    Posts
    1

    Unanswered: cannot create a new database

    I am a newbie using mySQL on unix (Mac OS/X). I have done simple operations, such as CREATE DATABASE, CREATE TABLE, SELECT, etc, but suddenly I find that I cannot do update operations, such as CREATE DATABASE.

    Here is my results.
    mysql> show databases;
    +--------------------+
    | Database |
    +--------------------+
    | information_schema |
    +--------------------+

    mysql> create database ladsondb;
    ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'ladsondb'

    mysql> grant ALL on *.* to richardladson@'localhost';
    ERROR 1045 (28000): Access denied for user ''@'localhost' (using password: NO)

    I suspect this is a basic problem, but it is a show-stopper for me.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Yup looks like a permissions problem to me
    if you GRANTed permisions on the command line client, did you FLUSH PRIVILEGES afterwards. Mind you I'd also want to check the syntax of the grant statement you used

    An alternative way of setting permissions is to use MySQL Adminsitrator which is part of the MySQL GUI tools from MySQL.

    mind you I'd also want to check the syntax of the grant statement you used
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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