1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

HELP! Cannot drop PHPmyadmin database sql

Discussion in 'BlackHat Lounge' started by MiLiTARYiV, Dec 13, 2009.

  1. MiLiTARYiV

    MiLiTARYiV Senior Member

    Joined:
    Jan 9, 2008
    Messages:
    959
    Likes Received:
    595
    Occupation:
    Webmaster
    Location:
    The Office
    Can anyone help me. I'm having trouble dropping a database. Its giving me a error message of

    "Access denied for user '*****@'localhost' to database '******'


    I was trying to import a database that i found over the net. I think it does have a user namer. i do know the user name
     
  2. srhcom

    srhcom Junior Member

    Joined:
    May 12, 2009
    Messages:
    101
    Likes Received:
    52
    Go to My SQL Databases and add the user into the database.
     
  3. nixnash

    nixnash Power Member

    Joined:
    Oct 26, 2009
    Messages:
    581
    Likes Received:
    204
    Occupation:
    Student
    Location:
    BHW
    You do 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.
    Hope it helps
    Ritesh
     
  4. MiLiTARYiV

    MiLiTARYiV Senior Member

    Joined:
    Jan 9, 2008
    Messages:
    959
    Likes Received:
    595
    Occupation:
    Webmaster
    Location:
    The Office
    well the data base does not show up in mysql, I created the user name but there is no database in there to add it too, although it is in phpmyadmin..

    Also the database name in myphpadmin has a underscore_
    When i try to create the database with the same name in mysql it will not let me use underscore
     
    Last edited: Dec 13, 2009
  5. MiLiTARYiV

    MiLiTARYiV Senior Member

    Joined:
    Jan 9, 2008
    Messages:
    959
    Likes Received:
    595
    Occupation:
    Webmaster
    Location:
    The Office
    how do i do that in myphpadmin(create new user for the database)?
     
  6. MiLiTARYiV

    MiLiTARYiV Senior Member

    Joined:
    Jan 9, 2008
    Messages:
    959
    Likes Received:
    595
    Occupation:
    Webmaster
    Location:
    The Office
    still open for suggestions
     
  7. pavan

    pavan Elite Member

    Joined:
    Mar 30, 2008
    Messages:
    1,603
    Likes Received:
    432
    ok listen
    here is the solution
    go to cpanel - sql wizard
    add a new database with any name
    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
    go to phpmyadmin
    upload your sql file
    and you are done

    its giving error bcoz you haven't created db and password