Multiple instances on single host - Percona MySQL 5.7

MySQL & MariaDB Percona Server for MySQL 8.0
1

Hi there

when connecting to percona mysql 5.7 on port 3307 facing the below error,not able to connect the multiple instances

root@test5:~# mysql -u root -p --port=3307 --socket=/var/lib/mysql1/mysqld.sock
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql1/mysqld.sock' (2)

Below is the config file

[mysqld_multi]

mysqld     = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin


user       = root
password   = test123


[mysqld]
user   = mysql
datadir  = /var/lib/mysql
socket  = /var/lib/mysql/mysql.sock
pid-file = /var/run/mysqld/mysqld.pid
log-error    = /var/log/mysql/error.log
port  = 3306
skip_name_resolve
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links = 0

# Recommended in standard MySQL setup
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld1]
user  = mysql
pid-file = /var/run/mysqld/mysqld1.pid
socket  = /var/lib/mysql1/mysqld1.sock
port  = 3307
datadir  = /var/lib/mysql1
log-error    = /var/log/mysql1/error.log
2

Hey @AneeshBabu,

your config states that socket is socket = /var/lib/mysql1/mysqld1.sock, but you are trying to connect to /var/lib/mysql1/mysqld.sock.

mysqld1.sock
vs
mysqld.sock

Can you please double check?