Erros #1044 and #1045 with Database

Discussion in 'MySQL' started by Torans, Apr 26, 2009.

  1. #1
    Hi, I am keep getting these 2 errors when i try to log in to my DB or if i try to import DB to new Host.

    This is short background what is actually happening.

    I purchased Hostgator.com Reseller Hosting. I set it up etc... Started to set up my sites, which i want to transfer from godaddy to this new hosting.

    Transfered my first site hosting fiels and got as far as database.

    1. I have made a new database
    2. I have made new db user
    3. I have given all PRIVILEGES to that user saved .

    Now when i log in to my phpmyAdmin via CP , i already see that the account i am loged in is actually my main log in acc webmaste and it shows in RED, that i got no PRIVILEGES.

    Then i Simply pick the new creaated DB, press import and this is what i get:

    Right then i realized that i can't really log in with my new user i created as well, simply coz when i clicked MyphpAdmin from that domein Host CP it automatically opened new window and logged me in with my main acc.

    So i though i need to install separate phpMyAdmin, so i did that i installed it in my man root and called it phpMyAdmin2 = Link works fine brings up the log in area when i try to log in now with a user i created it gives me this error:

    I have been trying a lot different things and i just can't understand where is the problem, so do my mates. :/

    There is one more thing i don't understand, when i am logged in in my CP and press myphpadmin,

    [​IMG]

    like in the screen shoot i will be automatically send to new Window and logged into my database,


    Any help from you folks will be highly appreciated,

    Thanks

    V.
     
    Torans, Apr 26, 2009 IP
  2. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #2
    you need to create the mysql acounts first by clicking "mysql databases"

    procedure

    1. make a new db say varisk
    2. create a user
    3. give all privelages

    then in script config add new details

    Thats all

    Regards

    Alex
     
    kmap, Apr 26, 2009 IP
  3. Torans

    Torans Active Member

    Messages:
    1,418
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    80
    #3
    I have done all this! But i didn't do anything in my script config!
     
    Torans, Apr 26, 2009 IP