when starting mysql Galera i get ERROR 2002 (HY000): Can't connect to local MySQL

153 views
Skip to first unread message

Ali Nasser

unread,
Oct 5, 2022, 3:31:43 AM10/5/22
to codership
i have done setup of galera between three nodes when i do mysql service restart the follwing issue is appearing :

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) 


same goes for the remaing nodes

mysql version : 8.0.28-26.10 
Os:luinx ubuntu 22.04
galera version 4

brian....@gmail.com

unread,
Oct 5, 2022, 4:08:34 AM10/5/22
to codership
Hi

Following e.g. guide https://www.digitalocean.com/community/tutorials/how-to-configure-a-galera-cluster-with-mariadb-on-centos-7-servers   

Did you stop any running MySQL instance and did you create the cluster on the (your own picking) first node?    "sudo galera_new_cluster"

Regards
Brian 
Reply all
Reply to author
Forward
0 new messages