Closed Thread
Results 1 to 4 of 4

Thread: Can't delete sql db

  1. #1
    pball is offline x10Hosting Member pball is an unknown quantity at this point
    Join Date
    Jan 2009
    Posts
    25

    Can't delete sql db

    I imported a db using phpmyadmin and that db doesn't appear in the cPanel MySQL Databases area. So it ends up that I can't delete it. There is no real problem, I made another db named differently and everything works. I'm just picky and don't care for extra stuff laying around.

  2. #2
    vv.bbcc19's Avatar
    vv.bbcc19 is offline Community Advocate vv.bbcc19 is just really nice
    Join Date
    Jun 2010
    Location
    India
    Posts
    1,505

    Re: Can't delete sql db

    Generally, I make a database(blank ofcourse) and then import content.You must have done the same and if that is done the database appears in the database area.Then the authorized user could delete/edit the database.
    So check the following
    -->You might not have sufficient privilages to use frop database , either give permission from phpmyadmin to user , to drop databse or create a new user give all permission.
    If you stuck with the creation..this is how it is

    1.go to cpanel - sql wizard
    2.add a new database with any name
    3.then it will ask you to add db user with password-then give all privilages to that user

    after you have created db and user
    1.go to phpmyadmin
    2.upload your sql file
    3.and you are done

    I think its giving error bcoz you haven't created db and password
    Revert back.
    BCV | Community Support Representative
    █ x10Hosting - Giving Away Hosting Since 2004
    Premium Hosting | VPS Services

  3. #3
    pball is offline x10Hosting Member pball is an unknown quantity at this point
    Join Date
    Jan 2009
    Posts
    25

    Re: Can't delete sql db

    Uh, I don't really understand what that has to do with a db I can't delete.

    I'll try explaining again
    Inside cPanel - MySQL Databases there is 1 db listed, the good one.
    Inside phpmyadmin there are 2 dbs listed, the good one and the one I can't delete.

    Some how that bad db isn't listed in the cpanel mysql area so i can't add a user to it or delete it.

  4. #4
    Skizzerz's Avatar
    Skizzerz is offline Contributors Skizzerz will become famous soon enough
    Join Date
    Nov 2007
    Location
    Texas
    Posts
    2,153

    Re: Can't delete sql db

    If it isn't causing any harm, or using up your number of allowed databases, I would just ignore it.

Closed Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers