error 1044?

Discussion in 'MySQL' started by ЄxDeus™, Aug 5, 2009.

Thread Status:
Not open for further replies.
  1. #1
    this is error

    SQL query:

    --
    -- Database: `information_schema`
    --
    CREATE DATABASE `information_schema` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    MySQL said: Documentation
    #1044 - Access denied for user 'tat1'@'localhost' to database 'information_schema'


    how do i fix that in simple terms?
     
    ЄxDeus™, Aug 5, 2009 IP
  2. RHS-Chris

    RHS-Chris Well-Known Member

    Messages:
    1,007
    Likes Received:
    35
    Best Answers:
    10
    Trophy Points:
    150
    #2
    The user does not have access to the database. You would need to grant the user privileges to that database.
     
    RHS-Chris, Aug 5, 2009 IP
  3. ЄxDeus™

    ЄxDeus™ Well-Known Member

    Messages:
    2,860
    Likes Received:
    214
    Best Answers:
    1
    Trophy Points:
    155
    #3
    but how do i fix it i give it full access to the database
     
    ЄxDeus™, Aug 5, 2009 IP
  4. RHS-Chris

    RHS-Chris Well-Known Member

    Messages:
    1,007
    Likes Received:
    35
    Best Answers:
    10
    Trophy Points:
    150
    #4
    Use PhpMyAdmin for this. Make sure you log in as the root user, then, grant the user in question access to the db, through the privileges area of PhpMyAdmin.
     
    RHS-Chris, Aug 5, 2009 IP
Thread Status:
Not open for further replies.