1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MYSQL Question

Discussion in 'Plesk for Windows - 8.x and Older' started by keymasterdk, Oct 30, 2004.

  1. keymasterdk

    keymasterdk Basic Pleskian

    Mar 4, 2008
    Likes Received:

    I have installed my site with the database and all works grate, but it seams that i cant get access to a give place in the database. : #1044 - Access denied for user: 'keymlux@localhost' to database 'test' so sombody told me to go to the database and send this to it : grant all on test.* to keymlux@localhost identified by 'XXXX';
    But when i do that i will get a access error again... what can i do to give me the previlliges i need....

    Ahh before i forget the same mean told me that i also can do this :
    Log on the server as root.
    mysql -p <enter>
    rootpassword <enter>
    You will then get this :
    Now type:
    grant all on test.* to keymlux@localhost identified by 'XXXt';<enter> You get 0 querie 0 row effected :
    Type this :
    flush privileges;<enter>

    So my question is where to type that, or is it a better way ??

    Regards John
  2. Nucles

    Nucles Guest

    i have the same problem...