Posts by batZen

    i have this log entrys many times:


    sicher, dass du das root password falsch aufgeschrieben hast?


    schonmal mit:



    Code
    1. mysql -u root -h 127.0.0.1 -p

    versucht?


    Denke, dass bei dir root@localhost beim Update auf 1.3.0 verschwunden ist.

    try 127.0.0.1 as host


    or try this to fix the problem:


    Code
    1. # mysql -h 127.0.0.1 -u root -p
    2. # CREATE USER 'root'@'localhost' IDENTIFIED BY '<password>';
    3. # GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' WITH GRANT OPTION;
    4. # flush privileges;
    5. # quit

    for sql root access try



    Code
    1. mysql -h 127.0.0.1 -u root -p


    should work, got the same problem after update to cause 1.3.0 root@localhost was deleted.


    you can fix this with:


    Code
    1. # mysql -h 127.0.0.1 -u root -p
    2. # CREATE USER 'root'@'localhost' IDENTIFIED BY '<password>';
    3. # GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' WITH GRANT OPTION;
    4. # flush privileges;
    5. # quit

    sql version


    Code
    1. +-----------------+
    2. | VERSION() |
    3. +-----------------+
    4. | 5.5.49-0+deb8u1 |
    5. +-----------------+

    Debian 8.5 jessie


    -----


    the root@localhost must be removed during upgrade to 1.3.0 as the login worked for installation and creating imscp_user but not after.

    i think i got a similiar problem, after upgrading to 1.3.0 i can't login with the root user anymore...



    Code
    1. +------+-----------+
    2. | user | host |
    3. +------+-----------+
    4. | root | 127.0.0.1 |
    5. | root | ::1 |
    6. +------+-----------+
    7. 2 rows in set (0.00 sec)

    this users are created, other user like the new imscp_user works..