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

Create user mysql after upgrade to 4.1

Discussion in 'Plesk for Linux - 8.x and Older' started by Ste_000, Feb 3, 2006.

  1. Ste_000

    Ste_000 Guest

    0
     
    Hi to all, i have upgraded my mysql version to mysql 4.1.15 . Now there is a problem, when i create a mysql user , he can't connect to db because mysql say that haven't permissions !
    For this problem i tried some solutions, and now when i create a user, i use this instruction to work connection : mysql> SET PASSWORD FOR
    -> 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); > this for each user who i create !!!

    but if there is a solution for this problem it's better ! thanks again, bye Ste
     
  2. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    965
    Likes Received:
    32
    Location:
    Romania
    /etc/my.cnf

    add

    old-password

    But all password created in new MySQL need to be recreate.
     
  3. Ste_000

    Ste_000 Guest

    0
     
    so i add this line "old-password" to /etc/my.cnf ? thanks again
     
  4. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    965
    Likes Received:
    32
    Location:
    Romania
    Yes ...
     
  5. Ste_000

    Ste_000 Guest

    0
     
    excuse me, but i'm not expert ! it isn't this line "old-passwords=1" to add ? and after i must reset also some password for plesk or not?

    Thanks
     
  6. lvalics

    lvalics Silver Pleskian Plesk Guru

    36
    43%
    Joined:
    Jun 20, 2003
    Messages:
    965
    Likes Received:
    32
    Location:
    Romania
    log-bin
    server-id=1
    old-password

    This is how I have ...
     
  7. Ste_000

    Ste_000 Guest

    0
     
    so i edited my my.cnf now and now all works !!! so what say ? thanks very much !!!! bye Ste
     
Loading...