On the machine where MySQL is started, configure the instance

It's starting mysql On the machine , Configure the instance

[root@node1 ~]# yum install -y libaio numactl-libs
[root@node1 ~]# mkdir -p /data/mysql 
[root@node1 ~]# chown mysql.mysql /data/mysql
[root@node1 ~]# tar xf mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz
[root@node1 ~]# mv mysql-5.7.37-linux-glibc2.12-x86_64 /usr/local/mysql
[root@node1 ~]# chown -R root.root /usr/local/mysql/
[root@node1 ~]# /usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/data/mysql
[root@node1 ~]# grep password /data/mysql/mysql.log
2022-04-11T14:15:33.754322Z 1 [Note] A temporary password is generated for root@localhost: g3(ujLzfFi.f

[root@node1 ~]# cat /etc/my.cnf
[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
log-error=/data/mysql/mysql.log
pid-file=/data/mysql/mysql.pid
skip_name_resolve = 1

[client]
socket=/data/mysql/mysql.sock

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

[root@node1 ~]#  cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
[root@node1 ~]#  chkconfig --add mysqld
[root@node1 ~]# service mysqld start

[root@node1 ~]# /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf  --basedir=/usr/local/mysql --datadir=/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/data/mysql/error.log --open-files-limit=65535 --pid-file=mysqldb.pid --socket=/data/mysql/mysql.sock --port=3306    &

[root@node1 ~]# /usr/local/mysql/bin/mysql -uroot -p
Enter password:
mysql> alter user root@localhost identified by "123456";
mysql> flush privileges;
mysql> create database test1;
mysql> exit

Start the second instance

Because it failed to restart mysql service , Start using this time root start-up

[mysqld_multi]
mysqld = /usr/local/mysql /bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
log = /data/mysql/mysqld_multi.log


[mysqld]
datadir=/data/mysql
socket=/data/mysql/mysql.sock
log-error=/data/mysql/mysql.log
pid-file=/data/mysql/mysql.pid
skip_name_resolve = 1

[client]
socket=/data/mysql/mysql.sock


[mysqld3307]
skip-grant-tables    // Because the password was not found . Let's skip here 
user=root           // The startup here is changed to root
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/data/mysql2
port=3307
server_id=3307
socket=/tmp/mysql_3307.sock
log-output=file
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /data/mysql2/slow.log
log-error = /data/mysql2/error.log
binlog_format = mixed
log-bin = /data/mysql2/mysql3307_bin

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

[root@node1 ~]# export PATH=/usr/local/mysql/bin:$PATH
[root@node1 ~]# /usr/local/mysql/bin/mysqld_multi start  3307
[root@node1 ~]# ss -antup | grep 3307
tcp    LISTEN     0      80     [::]:3307               [::]:*   

[root@node1 ~]# mysql -S /tmp/mysql_3307.sock -p
mysql> set password for root@localhost = password('654321');
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> set password for root@localhost = password('654321');
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql> exit

[root@node1 ~]# mysql -S /mysql/data/mysql.sock -p123456  -e "show databases;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| test1              |
+--------------------+
[root@node1 ~]# mysql -S /tmp/mysql_3307.sock -p654321  -e "show databases;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+