topic Installation Error of Expedition.... in Expedition Discussions

Installation Error of Expedition....

YeungHing — Fri, 02 Jul 2021 02:42:22 GMT

I am prompted for root pw, after I key in it. It sucks for around 10min and then return errors...
May I know how to get around this?

Setting UP the DB server.

spawn mysql_secure_installation

Securing the MySQL server deployment.

Enter password for user root:
Error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Re: Installation Error of Expedition....

lychiang — Fri, 02 Jul 2021 02:50:07 GMT

Don’t need to enter anything , the script should continue to run after few minutes

Re: Installation Error of Expedition....

YeungHing — Fri, 02 Jul 2021 05:30:44 GMT

No Luck... Yet, I try to set mysql root pw to null, run the setup script again and seems can go through

sudo systemctl stop mysql
sudo mysqld_safe --skip-grant-tables&
sudo mysql --user=root mysql

UPDATE mysql.user SET authentication_string=null WHERE User='root';
FLUSH PRIVILEGES;
exit;

sudo systemctl start mysql

Re: Installation Error of Expedition....

dgildelaig — Fri, 02 Jul 2021 06:33:30 GMT

Ads @lychiang mentions, the script already does the password changes for you. I would recommend restarting the installation process on a clean instance.In your current case, once you installed the services, they have been set with some settings (such as the credentials to manage them) and the script may not be able to proceed with the next steps if it cannot enter with valid credentials.