SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: Error

  1. #1
    SitePoint Member
    Join Date
    Jun 2004
    Location
    Sacramento
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Error

    I have installed Mysql on my server at work and I am trying to create a database...
    at the mysql prompt I type:
    mysql>create database jokes;
    and get the message:
    Error 1044: Access Denied for user: '@localhost' to database 'jokes'

    Please let me know how to fix this.
    Thank you!

  2. #2
    SitePoint Addict silent's Avatar
    Join Date
    Jun 2004
    Location
    Roaming North America
    Posts
    220
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    it's a permissions problem. You are logged in as a user that does not have rights to do that operation. See manual: http://dev.mysql.com/doc/mysql/en/Adding_users.html

  3. #3
    SitePoint Member
    Join Date
    Jun 2004
    Location
    Sacramento
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I went to the prompt and typed in
    mysql> --user=root mysql;
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
    received error 1045: Access denied for user: '@localhost' Using password:NO)
    Any solutions?

  4. #4
    SitePoint Addict silent's Avatar
    Join Date
    Jun 2004
    Location
    Roaming North America
    Posts
    220
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by ccc2001
    I went to the prompt and typed in
    mysql> --user=root mysql;
    mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    -> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
    received error 1045: Access denied for user: '@localhost' Using password:NO)
    Any solutions?
    You're not logged in to the MySQL server as a user that has permissions to execute a GRANT statement.


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
  •