Jul 7th 2016 #1 Hey Guys, i lost a paper with my SQL pw and i had to set a new one.I did: Code sudo /etc/init.d/mysql stopsudo mysqld_safe --skip-grant-tables &mysql -urootuse mysql;update user set password=PASSWORD("mynewpassword") where User='root';flush privileges;quitsudo /etc/init.d/mysql stopsudo /etc/init.d/mysql start Then i did Code perl /usr/local/src/imscp-1.3.0/imscp-autoinstall -dr sql And now i get the following error (attached). Any ideas? Version: 1.3.0OS: Debian Jessie kind regards
Jul 7th 2016 #2 try 127.0.0.1 as host or try this to fix the problem: Code # mysql -h 127.0.0.1 -u root -p # CREATE USER 'root'@'localhost' IDENTIFIED BY '<password>'; # GRANT ALL PRIVILEGES on *.* to 'root'@'localhost' WITH GRANT OPTION; # flush privileges; # quit