linux mysql库目录

# 查看MySQL配置文件my.cnf的位置
mysql --help | grep "Default options" -A 1

# 编辑配置文件，确认datadir路径
sudo nano /etc/my.cnf

# 更改库目录的所有者和权限
sudo chown -R mysql:mysql /var/lib/mysql
sudo chmod -R 750 /var/lib/mysql

# 检查磁盘空间使用情况
df -h

# 清理不必要的文件或扩展磁盘空间
sudo resize2fs /dev/sda1  # 示例命令，具体操作根据实际情况而定

import mysql.connector

try:
    connection = mysql.connector.connect(
        host="localhost",
        user="your_username",
        password="your_password",
        database="your_database"
    )
    if connection.is_connected():
        db_info = connection.get_server_info()
        print("Connected to MySQL Server version ", db_info)
        cursor = connection.cursor()
        cursor.execute("select database();")
        record = cursor.fetchone()
        print("You're connected to database: ", record)
except mysql.connector.Error as e:
    print("Error while connecting to MySQL", e)
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("MySQL connection is closed")