Welcome to WebDesignForums.net!
You're currently viewing WDF as a guest. By registering for a free account, you'll be able to participate with other members in our friendly community. Being a member allows you to ask questions and get answers for those troublesome web development tasks!

In addition, as a member you'll be able to post your websites up for review. Using our unique website review system you can gain some amazing feedback from some of the best web developers around. This is a completely free service to all registered members.

Ready to register yet? Registration is 100% free. Click Here To Join Now!

CREATE command denied to user

Discussion in 'Database Systems Help' started by Abstract, Nov 4, 2009.

  1. Offline

    Abstract Member

    Message Count:
    194
    Likes Received:
    0
    Trophy Points:
    16
    Hello friendly people,

    I am transferring one of my client's websites from my host to theirs. They are using GoDaddy's linux web hosting.

    As I have done with many other client's sites, I exported the data from the old database into a text file. Then I created a new database in their GoDaddy hosting account.

    In attempt to import the data, I receive the following error message:
    #1142 - CREATE command denied to user 'username'@'host' for table 'table_name'

    I am not experienced with MySQL so I had no idea what this meant; and I have never seen this error with other sites I have attempted to transfer either.

    So after some research on the net, I saw that I need to grant privileges to my user before performing any actions.

    :cross-eyed: - I have never had to "grant" privileges with any others users... so I found this a little weird.

    Any way, looking through PHPmyAdmin, I see there is another database that has a user_privileges table. What do I need to do to give myself permissions to perform actions with this database?


    Abstract, Nov 4, 2009
    #1

  2. WDF Go Premium, Drop Ads

  3. Online

    smoseley Administrator

    Message Count:
    9,727
    Likes Received:
    192
    Trophy Points:
    63
    Location:
    Boston, MA
    GRANT ALL on dbname.* to 'username'@'localhost' identified by 'password';


    smoseley, Nov 5, 2009
    #2
  4. Online

    smoseley Administrator

    Message Count:
    9,727
    Likes Received:
    192
    Trophy Points:
    63
    Location:
    Boston, MA
    in phpmyadmin you have to from the home screen click "priveleges". Then find the user, and add the database to that user's priveleges (if it's not there, or edit it if it is), then specify which permissions that user should have.


    smoseley, Nov 5, 2009
    #3
  5. Offline

    Abstract Member

    Message Count:
    194
    Likes Received:
    0
    Trophy Points:
    16
    That's what I needed!

    Thanks.


    Abstract, Nov 15, 2009
    #4
(You have insufficient privileges to reply here.)

Share This Page