host 127.0 0.1 is not allowed to connect to this mysql server
snippet in sql

host 127.0 0.1 is not allowed to connect to this mysql server

user9921

UPDATE mysql.user SET host='%' WHERE user='root';

host not allowed to connect to this mysql server

user6100

    mysql -u root -p
    -- root password

    CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

    GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;

    CREATE USER 'username'@'%' IDENTIFIED BY 'password';

    GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;

    FLUSH PRIVILEGES;

    EXIT;