SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    BLYAT! theGWS's Avatar
    Join Date
    Jun 2001
    Location
    Melbourne, AU & Seattle, WA
    Posts
    502
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ERROR 1044: Access denied for user

    I'm on pg 29 of Kevin Yank's book. I'm trying to create the jokes database. At the mysql> prompt I entered:

    CREATE DATABASE jokes;

    Then, instead of creating the database, it returns this line:

    ERROR 1044: Access denied for user: '@localhost' to database 'jokes'

    Any clues why or how to fix it? It worked when I was using Win2K and IIS, but since I found out Mac OS X can do this I've started over on that platform.
    ~Dorian

  2. #2
    BLYAT! theGWS's Avatar
    Join Date
    Jun 2001
    Location
    Melbourne, AU & Seattle, WA
    Posts
    502
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I don't know if this is the proper way to do this, but I've been messing around and typed:

    mysql -u root

    Then it let me create the database called jokes.
    ~Dorian

  3. #3
    SitePoint Member
    Join Date
    Jun 2002
    Location
    Denver, CO
    Posts
    18
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You need to GRANT permissions to the table for the user account you typically use (which shouldn't be root!). I don't know what book you're looking at, but check out chapters on users/permissions.


Bookmarks

Posting Permissions

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