Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 4 of 4
  1. #1
    Senior Member
    Join Date
    Aug 2003
    Posts
    194
    Member #
    2782
    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?

  2.  

  3. #2
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times
    GRANT ALL on dbname.* to 'username'@'localhost' identified by 'password';

  4. #3
    WDF Staff smoseley's Avatar
    Join Date
    Mar 2003
    Location
    Boston, MA
    Posts
    9,729
    Member #
    819
    Liked
    205 times
    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.

  5. #4
    Senior Member
    Join Date
    Aug 2003
    Posts
    194
    Member #
    2782
    That's what I needed!

    Thanks.


Remove Ads

Posting Permissions

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

Search tags for this page

1142 - create command denied to user
,
1142 - create view command denied to user
,
create command denied
,

create command denied to user

,
create command denied to user grant all
,
create command denied to user mysql
,
create command denied to user phpmyadmin
,
godaddy mysql migration create command denied to user
,
mysql create command denied to user
,
mysql create user command denied
Click on a term to search for related topics.
All times are GMT -6. The time now is 08:14 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com