一个电脑能装两个mysql

# 下载MySQL安装包
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz

# 解压
tar -xvf mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz -C /usr/local/

mkdir -p /usr/local/mysql1
mkdir -p /usr/local/mysql2

cp -R /usr/local/mysql-8.0.23-linux-glibc2.12-x86_64/* /usr/local/mysql1/
cp -R /usr/local/mysql-8.0.23-linux-glibc2.12-x86_64/* /usr/local/mysql2/

[mysqld]
basedir=/usr/local/mysql1
datadir=/usr/local/mysql1/data
port=3306
socket=/tmp/mysql1.sock

# 对于第二个实例
[mysqld]
basedir=/usr/local/mysql2
datadir=/usr/local/mysql2/data
port=3307
socket=/tmp/mysql2.sock

/usr/local/mysql1/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql1 --datadir=/usr/local/mysql1/data
/usr/local/mysql2/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql2 --datadir=/usr/local/mysql2/data

/usr/local/mysql1/bin/mysqld_safe --defaults-file=/usr/local/mysql1/my.cnf &
/usr/local/mysql2/bin/mysqld_safe --defaults-file=/usr/local/mysql2/my.cnf &

import mysql.connector

# 连接第一个实例
conn1 = mysql.connector.connect(
    host="localhost",
    port=3306,
    user="root",
    password="your_password1",
    database="db1"
)

# 连接第二个实例
conn2 = mysql.connector.connect(
    host="localhost",
    port=3307,
    user="root",
    password="your_password2",
    database="db2"
)

# 执行查询
cursor1 = conn1.cursor()
cursor1.execute("SELECT * FROM table1")
result1 = cursor1.fetchall()

cursor2 = conn2.cursor()
cursor2.execute("SELECT * FROM table2")
result2 = cursor2.fetchall()

print(result1)
print(result2)

# 关闭连接
conn1.close()
conn2.close()